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

Deleting blank rows 4
Filling an empty row with the data in row above it 2
Deleting/removing unused rows in a worksheet 3
Force a filter beyond blank rows 1
deleting rows with blank cells after a specified column? 3
Deleting blank rows with formulas in them 7
Deleting Multiple Blank Rows 6
Delete Blank Rows 9

Top