|
In a excel 2010 file, there are data in about 100 rows, but the whole work sheet displays 1048576 blank rows (making the file about 2.5 mb). I need to delete balnk rows after the data. But selecting the row and deleting is doing nothing. How to delete these unwanted rows? EDIT: This is my excel file: http://www.mediafire.com/download.php?au957fcnh3odbcd can someone explain what is wrong with this file??
| |||||||||||||
feedback
|
|
There is definitely something wrong with your file. It might be easier to copy the 100 rows you want to keep to a new workbook file rather than try to delete a million rows. A search for duplicates in the whole document found and removed over 1 million duplicates. So there are hidden characters or something occupying space in that workbook. That still didn't help because the save size after that went up to 35MB. Solution: Once I copied the rows you have populated to a new workbook, the saved file size is only 10K. | |||
|
feedback
|
|
Select the rows you want to delete. If you have Office 2003: http://www.mrexcel.com/archive/Edit/4259.html 2007 and later: in the ribbon on start, there is the button delete (block called cells), click the small arrow under it and choose delete rows. | |||||
|
feedback
|
