How to delete alternating BLANK rows in .xls file all @ once?

D

Desperate

How to delete alternating BLANK rows in .xls file all at one time? Is there a
formula, find and replace, etc.?
 
L

Luke M

Assuming you have data in between those blank rows:

Select a column. Press Ctrl+G to bring up the goto dialogue. Click
'Special', then select blanks. Ok out.

Now, with those cells selected, press Ctrl+minus sybol. Select the option to
delete entire row. Ok out.
 
P

Per Jessen

Hi

Select a row with the blank rows to delete, goto Edit > Go To > Special >
Blanks > OK

Now right click one of the cells which has been seelcted > Delete > Entire
row.

Hopes this helps.
....
Per
 
S

Sean Timmons

Of course, you can also highlight the spreadsheet and selest Data > sort and
sort by any column...
 

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

Inserting a bunch of rows at once. 8
conditional formatting to group rows with repeating entries 3
How do I alternate shading of rows, Excel 2007, no new tabs. 1
Alternating colors for rows 1
Problem with alternating table rows 2
Filterable alternating row colour formula skewed when rows deleted. 8
Removing BLANK rows in Excel 2
Alternating cell shading colors for every other merged cell 1

Top