Every Other Cell/Row


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

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!
 
Ad

Advertisements

T

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
 
Ad

Advertisements

M

Mandy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top