View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default How to delete alternating BLANK rows in .xls file all @ once?

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.?