Excel - highlighted blank rows

Tip: delete blank rows in Excel, Mac Office 2008

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.

Data file with blank rows

This CSV from AT&T comes complete with a lot of blank rows.

2. Press “Control+G” to bring up a special “find” window

I have not been able to find this window in Excel menus.

Excel' go to menu

Keyboard command: Control + G

3. Select “Special…”

Excel Go To dialog

Select “Special” on the “Go To” dialog

4. Select “Blanks” in the “Go To Special” dialog

Excel Go To Special dialog

Select “Blanks” in the Go To Special dialog

5. Click “OK” on the “Go To Special” dialog

Your “blank rows” are now highlighted.

Excel - highlighted blank rows

Press OK to highlight the blank rows

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”

Excel - shift cells up

Select “Shift cells up” and click “OK”

8. Success!

Your blank rows are gone!

Excel - blank rows deleted

Success!

 

Thanks to comments on HowToGeek and Windows instructions on Chandoo.org.

 

One thought on “Tip: delete blank rows in Excel, Mac Office 2008

Leave a Reply