Removing blank rows

  • Thread starter Thread starter Wickiup
  • Start date Start date
W

Wickiup

Hi newbie here,

Excel 2007

I have a very large worksheet with hundreds of random empty rows.
How do I "automate" the deletion all of these rows?

Thank you

-*-
Jim Curts
 
Hi,

1. Click the column letter on one of the columns with data and blank row.
2. Press Ctrl+- (control minus) and respond Entire Row.

If this helps, please click the Yes button.

cheers,
Shane Devenshire
 
I accidently stumbled onto a solution last night that worked very well. I
selected delete duplicates and they all went away.

Not having any more blank rows to bother with I must ask:
Does the solution you posted get rid of all the blank rows or only the one
you select?

Thanks

-*-
Jim Curts
 
Hi,

The method I demonstrated gets rid of all blank rows in the range selected.
The Remove Duplicates command is only available in 2007, in prior versions
you need to use another approach. Also, there is one difference between
Remove Duplicates and the delete blank rows - the Remove Duplicates command
assumes you want to retain one item of an repeating set, this is fine, but
different that the method I showed.

if this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Yep, I realize that but needed a quick fix. ;-)

I will make note of your method so I can do it right next time.

I do not see any Yes button but will click anyway just for you.

Thank you

-*-
Jim Curts
 
Back
Top