Excel 2003 and deleting rows

Posted by Anonymous PM | on Mon, 22/03/2010 - 17:53 2934 11 comments | report

Is their an easy way to delete unwanted rows in an Excel spreadsheet?

I have copied and pasted a sheet and it now has a lot of blank lines. I can go through and delete them manually but wondered if I can use a formula to say if its blank delete it?

Comments

There are 11 comments. Login or register to view them.

VBA

paulwakefield1 | Mon, 22/03/2010 - 18:21

A link

paulwakefield1 | Mon, 22/03/2010 - 18:28

If it's a table

ACDWebb | Mon, 22/03/2010 - 18:31

Deleting empty rows

fisch4billf | Mon, 22/03/2010 - 19:08

Deleting empty rows or rows containing zeros

gforce1059 | Mon, 22/03/2010 - 23:12

Much easier than these

Richard Willis | Tue, 23/03/2010 - 08:44

Go to special

Anonymous | Tue, 23/03/2010 - 09:29

Care

paulwakefield1 | Tue, 23/03/2010 - 15:10

Bill's code has a flaw

mohan1 | Thu, 01/04/2010 - 09:50

Excel Excess Format Cleaner

PaulFeagan | Thu, 01/04/2010 - 10:24

A simple formula.................

mptaylor1 | Wed, 07/04/2010 - 17:19