Delete all blank rows in sheet?

  • Thread starter Thread starter Gregg Hill
  • Start date Start date
G

Gregg Hill

Hello!

Many moons ago, Gord Dibben posted this step as a reply to my "how do I
remove all blank columns" question for Excel 2002.

Highlight a column....Edit>Go To>Special>Blanks>OK. Delete>Entire Row.

Now I am using Excel 2003 and I want to delete all blank rows and columns in
a sheet. The above method does not work. Once I highlight a column or row
and click on Edit>Go To>Special>Blanks>OK, then click Edit>Delete>Entire
Row, it only deletes the row I had highlighted. I want to delete EVERY blank
row in the sheet, since there are many gaps in the sheet caused by blank
rows in between rows with data.

Any ideas!

Gregg Hill
 
Gregg

I would NOT have posted that reply to a question of "how do I delete all blank
columns".

"All blank rows", yes.

To remove blank columns, select a row only then Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Column.

To remove blank rows, follow the original suggestion.

Gord
 
I sit corrected. I went back to the original post. Thanks again!

Gregg Hill

********************
From: Gord_Dibben (Gord_Dibben)
Subject: Re: How to delete all blank rows in a sheet?


View this article only
Newsgroups: microsoft.public.excel
Date: 2004-01-05 09:06:15 PST

Gregg

MS did include something so simple..

Highlight a column....Edit>Go To>Special>Blanks>OK. Delete>Entire Row.

Gord Dibben Excel MVP

That is awesome, thank you very much! Why didn't MS include something so
simple? I have Excel 2002 and it can't even do it without the add-in! Thanks
for the link to that incredible time-saver.

Gregg Hill
Click to expand...
*********************"Gord Dibben said:
Gregg

I would NOT have posted that reply to a question of "how do I delete all blank
columns".

"All blank rows", yes.

To remove blank columns, select a row only then Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Column.

To remove blank rows, follow the original suggestion.

Gord
Click to expand...
 
Back
Top