How do i delete empty rows in a spreadsheet

G

Gord Dibben

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

Select that column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 13:12:07 -0700, Jim <[email protected]> wrote:
 
Top