In Excel I have a workbook, and want to select all blank rows for.

[Guest]

I have a worksheet with around 19,000 rows, some of which are blank. It's a
price list I do regularly. How can I select all blank rows and then delete
them. It will take hours to do them all manually.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

 

[Gord Dibben]

If a blank in any column means the entire row is blank, you can select column
A and.....

Edit>Go To>Special>Blanks>OK.

Edit>Delete>Entire Row.

Gord Dibben Excel MVP

On Fri, 15 Oct 2004 08:17:06 -0700, "HANDY ANDY" <HANDY

 

[Dave Peterson]

Maybe you could sort your data and the blanks will be at the bottom.