Auto selecting alternate rows

  • Thread starter Thread starter Colin MacDougall
  • Start date Start date
C

Colin MacDougall

Hi,

Does anyone have a method for doing the following ? -

Using Excel I import external data from a text document.
The import works great but the way the text document is
formatted causes Excel to place the data on every second
row of the sheet. I can manually delete all the empty rows
but at 500 lines or so its a lot of work. Can Excel be made
to select every second row ( say rows 1,3,5,7,... ) so that I
can then just use the delete command ?

thanks,

Colin
 
Select any column (The whole column, or just the range you are interested in)
and do Edit / Go To Special / Blanks
 
Back
Top