Every Other Cell/Row

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

 

[Guest]

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!

 

[Trevor Shuttleworth]

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

 

[Mandy]

As long as you highlight all of the columns and rows the
sort should not mess up.