Select a column.

F5SpecialBlanks

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 04:00:01 -0700, Bigweed
wrote:

Hi to all

I have a spreadsheet which has lots of rows of data. It also has lots of
empty rows in between the rows of data. Is there any way of deleting the
empty rows automatically, instead of highlighting each of them one at a time
and deleting them that way? Maybe theres an option within Excel somewhere
where Excel deletes empty rows within a selection? All help most appreciated

Thanks
Bigweed