ExcelBanter - How do i delete empty rows in a spreadsheet

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

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

- - How do i delete empty rows in a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/150926-how-do-i-delete-empty-rows-spreadsheet.html)

Jim

How do i delete empty rows in a spreadsheet

Bob I

How do i delete empty rows in a spreadsheet

Select em, r-click em , and Delete em

Jim wrote:

Gord Dibben

How do i delete empty rows in a spreadsheet

If you have a column that contains all the blank rows.

Select that column and F5SpecialBlanksOK

EditDeleteEntire Row.

Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 13:12:07 -0700, Jim wrote:

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