ExcelBanter - Deleting empty rows

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Deleting empty rows (https://www.excelbanter.com/new-users-excel/218840-deleting-empty-rows.html)

Felix

Deleting empty rows

How can I easily delete empty rows on a huge worksheet (other than sorting)?
(Excel 2007)

Felix

Muhammed Rafeek M

Deleting empty rows

Use filter. Or Select blank rows by using Edit-Goto-Special-Blanks, option
and delete

"Felix" wrote:

How can I easily delete empty rows on a huge worksheet (other than sorting)?
(Excel 2007)

Felix

All times are GMT +1. The time now is 03:56 PM.