Categories
Personal Technology

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.

 

By Kathy E. Gill

Digital evangelist, speaker, writer, educator. Transplanted Southerner; teach newbies to ride motorcycles! @kegill

1 reply on “Tip: delete blank rows in Excel, Mac Office 2008”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.