In an Excel 2010 file, there are about 100 rows containing data, but the whole work sheet displays 1048576 blank rows (making the file about 2.5 mb). I need to delete blank rows after the data. But selecting the row and deleting it is doing nothing. How to delete these unwanted rows?
This is my excel file: http://www.mediafire.com/download.php?au957fcnh3odbcd
Can someone explain what is wrong with this file?