Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Empty Rows from Worksheets
Hi guys and Girls
I have a problem that i cant figure out here. I have a document with several worksheets, on two of these worksheets it has added all 65000+ Rows all but 3 rows are empty but the document saves as though there is data in these rows, I have deleted the rows, cleared contents but i still cant seem to actually delete the empty rows from showing on the document, Has anyone had this and how can i fix it without having to Re-Do all the work done on the sheet because i have alot of data that is reliant on the values within this sheet. Thanks Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Removing empty cells from spreadsheet data | Excel Discussion (Misc queries) | |||
How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |