HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET?

[sandman832]

--
zzzzzzz

[Gord Dibben]

Data>Filter>Autofilter to filter for blanks.

OR Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 07:40:35 -0800, sandman832
<sandman832@discussions.microsoft.com> wrote:

[sandman832]

Gord, that's amazing! I used the Select column - F5 routine and immediately
removed over 1600 blank lines from a huge spreadsheet. Thanks so much!
--
zzzzzzz


"Gord Dibben" wrote:

> Data>Filter>Autofilter to filter for blanks.
>
> OR Select a column and F5>Special>Blanks>OK
>
> Edit>Delete>Entire Row.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 9 Mar 2006 07:40:35 -0800, sandman832
> <sandman832@discussions.microsoft.com> wrote:
>
>
>