If you haven’t upgraded Mac Office because 2008 does what you need to do … this tip may be for you: how to delete Excel blank rows.
I’m working with data from AT&T, and the CSV has a blank row between each row of data. (Think “double-space” in writing.) I want to rid the data of the blank rows without having to manually click-and-delete each row.
1. Select the blank rows that you want to delete.
All the how-to’s online suggest including the row “above” and “below” the affected area.
2. Press “Control+G” to bring up a special “find” window
I have not been able to find this window in Excel menus.
3. Select “Special…”
4. Select “Blanks” in the “Go To Special” dialog
5. Click “OK” on the “Go To Special” dialog
Your “blank rows” are now highlighted.
6. Press “Control+minus” to delete the highlighted rows
That’s the “minus” key (to the left of the plus key on top row).
7. Select “Shift cells up”
Your blank rows are gone!