Ok, So, this doesn’t fall under “Discussions” or “Questions” category, since It’s simply a solution. A user at our workplace was having trouble with certain Crystal Reports generate excel sheets. There were about 1000 rows which were randomly empty. This is how I took care of it :
– First, before you make any drastic changes to any workbook always make sure you have a backup copy in case you need to restore the original data .
– Now, select the cells in one column from the top of your list to the bottom (e.g. click on “A” column to select everything below it).
– Make sure that all the blank cells in this selected range are the rows you want to delete.
– Select Edit, Goto (or press F5).
– Click the Special… button.
– Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
– Now choose Edit, Delete, select the Entire Row option and click OK.
MAKE SURE YOU SAVE YOUR SHEET AFTER THIS.
I know this might have been documented by someone earlier (even on the net, but I wanted to put it here, just in case someone needed it.