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?
This is my excel file: http://www.mediafire.com/download.php?au957fcnh3odbcd
can someone explain what is wrong with this file??