REMOVING A HUGE AMOUNT OF BLANKS ROWS

M

mePenny

I tried to use "F5, Special, Blank, okay, Edit, Delete, Entire Row" but it
tells me " Selection to large" and stops.

With the blank rows going every other one, the file is 15850 rows long, only
3 columns wide.

Is there a formula that will handle such a large amount of rows?

mePenny
 
S

Sean Timmons

Seems easiest to just highlight the workbook and sort by a column. Then,
blank rows would be at bottom and you can delete in one fell swoop. Is that
an optin for you?
 
S

Sean Timmons

Seems easiest to just highlight the workbook and sort by a column. Then,
blank rows would be at bottom and you can delete in one fell swoop. Is that
an optin for you?
 
M

mePenny

Sean,

You've made my afternoon, thank you kindly..
I've gone from 15850 to 2746.

mePenny
 
M

mePenny

Sean,

You've made my afternoon, thank you kindly..
I've gone from 15850 to 2746.

mePenny
 

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/removing unused rows in a worksheet 3
Excel 2002: Need to increase capacity of selecting / deleting blan 2
How can I remove multiple (hundreds) of blank rows in one step? 2
Summary sheet missing blanks rows 1
Delete multiple rows where a blank cell is located 2
cell returning totals of 2 cols+ sending this value to another col 5
Logic of xlCellTypeBlanks i.e. "Blanks" period or "Blanks" in used range? 8
How do I get the a large amount of text to show in merged cell? 2

Top