3

In any editor I move lines around with the keyboard frequently. Using the mouse/trackpad is distracting and slow. Can the same be accomplished in Excel and I just missed it?

2
  • What do you mean by "move lines around" in Excel? – Alper Mar 6 '20 at 4:18
  • 1
    Move row 1 to row 3. The "before" rows 2 and 3 become the "after" rows 1 and 2. This is trivial in editors. After many perusals of keyboard shortcuts for excel I have never seen how to do this. – StephenBoesch Mar 6 '20 at 4:41
3
  1. Press Shift ⇧+Space ␣ while on the row you want to move (row 1 in your example in the comments above). This should highlight all of the row.

  2. Press Command ⌘+x to cut the highlighted row.

  3. Using the arrow keys on your keyboard, go to the row you want to insert the cut row before (row 4 if we continue the example).

  4. Press Control ⌃++.

3
  • Thx for jumping in! great stuff! Where/how did you find this? Any other gold nuggets of shortcuts up your sleeve? – StephenBoesch Mar 6 '20 at 5:24
  • Sorry but I don't remember how I found them all, especially the fourth step, probably trial & error. I just have been a heavy user of Excel (on the Windows side) for too many years until recently. – Alper Mar 6 '20 at 5:46
  • btw This also works for columns only that column is selected by Ctrl-space instead of Shift-space – StephenBoesch Mar 6 '20 at 8:26

You must log in to answer this question.

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