up vote 2 down vote favorite
1
share [g+] share [fb]

When I cut and paste a row of data in Excel the data is moved but the empty row remains. Is there a shortcut key or option that lets me move the row without leave an empty row behind?

link|improve this question
I know what you mean, but just to make it clearer. cut and paste does a copy and paste. and you want to copy paste and delete the original row. Maybe some macro could speed it up I don't know – barlop Oct 14 '11 at 6:00
feedback

2 Answers

up vote 2 down vote

  1. Select the row that you want to cut. Press Ctrl + X. Marching ants (marquee) appear around the range.

    enter image description here

  2. Select the cell to which want to move the data.

    enter image description here

  3. Press Ctrl + Shift + + .

    enter image description here

    Note that this may only work if the source and destination ranges are along the same column.

link|improve this answer
Ctrl+Shift++ doesn't work for me, but right click "Inset Cuts Cells" does – chris neilsen Oct 15 '11 at 10:17
@chris Yep, that's another way to do it. – Kaze Oct 15 '11 at 14:37
feedback
up vote 1 down vote

You can use the contextual-menu.

  1. Select the row you want to copy
  2. Cut it (with shortcut CtrlX or menu Edit>Cut)
  3. Select the row where you want you data to be pasted
  4. Right-click and choose Insert copied cells (or anything that looks like, my Excel version is not in English)
link|improve this answer
1  
-1 You mean Ctrl+x (cut) and "Insert Cut Cells" – chris neilsen Oct 15 '11 at 10:19
this is what my answer meant and led to the right process... – JMax Oct 15 '11 at 11:22
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.