Every Other Cell/Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had to copy/paste some data into a worksheet. Unfortunately the data placed
a cell in between each/every cell. For example, A1, A3, A5 all have data. A2,
A4, A6 all have nothing in them.

I want to remove the extra cells/rows WITHOUT having to highlight each
cell/row and delete. And using the alphabet search doesnt do me any good as
it messes up my order for the data. Any ideas?
 
With range A1:A6 selected (assuming 6 rows) . On the Edit menu, click Go To.
Click the Special button. In the Go To Special dialog box, click Blanks.
Next, on
the Edit menu, click Delete. Select the Delete Option you want (ie. Shift
cells up, Entire Row, etc.). Hope this helps!
 
Ben

Select column A;
press F5 (GoTo) | select Special... | select Blanks;
select Edit | Delete... | select Entire row

I suggest you practise on a copy of the data but that should do what you
want.

Regards

Trevor
 
Back
Top