Getting rid of empty cells

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

Guest

I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting
and pasting. I have a lot of values and empty cells so if there is a formula
that would be a lot quicker than cutting and pasting. Thanks.
 
If the rest of the row is empty, why not just sort by blanks and delete en
masse?
 
Jam

Select A4, 5 and 6 then Edit>Delete>Shift Up.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

how to copy the contents from last cell 2
repeat a group of cells 3
How to use cell reference? 9
Alpha sorting (with a twist...?) 3
how to find the 2nd last value of a column 2
Calculating duplicates 2
Calc duplicates 3
Can this be done? 4

Back
Top