Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|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
  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.

share|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

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)
share|improve this answer
-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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .