| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why the extra rows??
For some reason one of my sheets is 2-3 times longer then it should be. I
tried deleting all the row past my data, removed all borders, and deleted any possable conditional formating/formating, there could be. Why are they still there!! Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why the extra rows??
It´s excel what you are talking about?
The blank columns can´t be delected, it means, the number os columns still the same after deleting. I hope this information can help. Robert Brown escreveu: For some reason one of my sheets is 2-3 times longer then it should be. I tried deleting all the row past my data, removed all borders, and deleted any possable conditional formating/formating, there could be. Why are they still there!! Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why the extra rows??
At the risk of stating the obvious you need to delete 'spare' column as well
as rows AND save the file. Do you still have a problem? Regards. Bill Ridgeway Computer Solutions "Robert Brown" wrote in message ... For some reason one of my sheets is 2-3 times longer then it should be. I tried deleting all the row past my data, removed all borders, and deleted any possable conditional formating/formating, there could be. Why are they still there!! Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why the extra rows??
Yeh i did the column thing too, I have never had a problum with this before.
Any other suggestions? O and I deleted the "Blank columns/rows" to make sure nothing was in them by accident, which would be the obvious first thing to do. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
| how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Linear Mode
