Tame your computer – delete the empties

18 Jul

Excel is a popular program that can save you countless hours in calculating and recalculating information. You can also use its powerful filters and PivotTables to quickly retrieve information and manipulate it in numerous ways. Blank rows, however, makes this all difficult and messy. OK, you can obviously delete your empty rows one by one, but there’s a quick way to select and delete all of them.

Here’s how:

  1. If necessary, select the range containing the empty rows.
  2. Press F5 and click on the Special button.
  3. Click on the Blanks radio button and click OK.
  4. All rows containing a blank cell anywhere in the row are selected, so be careful to check the data!
  5. On the Home tab, in the Cells group, click on the arrow next to the Delete button and select Delete Sheet Rows.

And wouldn’t these steps be a great one to record as a macro? See Tip 351 for further details.

Advertisements

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

%d bloggers like this: