How to delete blank rows in excel

Posted: November 26, 2009 in Microsoft, Office, Tips
Tags: , ,

Deleting blank rows is a common thing one would like to do after importing data to excel. There are dozens of ways of achieving the same. I bet, this being one of the simplest:

1. Press F5 on the keyboard. The ‘Go To’ dialog window appears.
2. Click ‘Special..’ button at the bottom left corner of the dialog box.
3. The ‘Go To Special’ dialog window opens.
4. Select ‘Blanks’ radio button and click ok.
5. All the blank rows will be selected on the excel.
6. Click ‘Delete Cells’ under ‘Home’ Tab.
7. This will delete all blank rows on the excel.

Comments
  1. Justin says:

    Could I grab one please! Thanks

  2. Justin says:

    Sorry posted in wrong one – I meant for the wave!

  3. abbysays says:

    @Justin: Sure.. gimme ur mail id…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s