Deleting empty rows automatically

[Bigweed]

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

 

[Allllen]

Here are some easy ways for you to do it manually.

Select all the data where you want to remove blank rows.
Sort by one of the columns that has blanks in it.
Now all the blanks rows are together.
Now select the blank rows and delete them all at the same time using CTRL-
(control-minus)

- or -

Select all the data where you want to remove blank rows.
Data > Filter > Autofilter
Filter for (blank) on one of the columns
Now select all the blank rows that are showing.
Do CTRL- (control-minus) to remove these lines.
Note that this may take a bit longer, especially if you have a lot of
formulae.

You may or may not get a few posts suggesting macros for this. Whether or
not you go to the trouble of setting those up really depends how often you
are likely to have to do this.

 

[Gord Dibben]

Select a column.

F5>Special>Blanks

Edit>Delete>Entire Row


Gord Dibben MS Excel MVP