Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

  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. –  Ellesa 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  
-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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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