Delete all blank rows in sheet?

[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

 

[JulieD]

Hi Gregg

if you

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

it will work, but you must highlight a COLUMN not a ROW

Cheers
JulieD

 

[Gord Dibben]

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

 

[Gord Dibben]

Gregg

Here is your original posting from many moons ago.

Note: question is "how to delete all blank rows in a sheet"

http://snipurl.com/8kit

Gord

 

[Gregg Hill]

But I want to delete all blank rows and all blank columns. Any way to do
that?

Gregg

 

[Gregg Hill]

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

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

 

[Gregg Hill]

Nevermind, Gord answered it!

Thanks!

Gregg Hill