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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Desperate" wrote:

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

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

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

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Desperate" wrote:

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