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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET? (https://www.excelbanter.com/excel-discussion-misc-queries/76200-how-can-i-easily-remove-multiple-blank-rows-spreadsheet.html)

sandman832

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

--
zzzzzzz

Gord Dibben

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

DataFilterAutofilter to filter for blanks.

OR Select a column and F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 07:40:35 -0800, sandman832
wrote:

sandman832

HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET

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:

DataFilterAutofilter to filter for blanks.

OR Select a column and F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

On Thu, 9 Mar 2006 07:40:35 -0800, sandman832
wrote:

All times are GMT +1. The time now is 06:25 AM.