Deleting Blank Rows.

G

GEM

I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is there
any way to delete all the blank rows???
 
F

Francis

try this

Select a column then F5>Special>Blanks>OK
Edit>Delete>Entire Row
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Sorting Multiple Tables 1
Publisher adding blank page when printing my booklet... 2
Blank pages 0
Deleting blank rows 5
Can't seem to delete all images from a Word Doc 2
Need Help with a VBA subroutine 0
how to insert serial numbers to rows? 3

Top