Move cells by Right-click Drag and Drop

How to swap adjacent cell quickly? How to insert new items in the middle of a table? How to move cells more efficiently?… by using mouse…

Excel Tips - Move Cell by Right Click

Last week, I learned from Debra Dalgleish to convert formula into value by using mouse.  What a simple and handy trick!  Honestly, I have never seen that before even though I knew the same trick for Fill.   After watching her demo, I experienced that on my own and realized that it works for moving cells too.  To me, it’s like a discovery of new land. 🙂 Why? Because that’s a handy alternative to Cut and Insert Cut Cells… Excel Tips - Move Cell by Right Click 1 To perform the task above, I used to use Cut and Insert Cut Cells…

  1. Select the target cells
  2. CTRL X (to cut the cells); or right click –> Cut
  3. Select the destination cells
  4. Right Click –> Insert Cut Cells…

p.s. I observed some users tend to Cut the row/column and then insert the cut row/column, by doing so you move everything else outside the intended range and that can be very dangerous move… be caution if you have this habit too.

With Right-Click Drag and Drop, it can be done in just two clicks:

Excel Tips - Move Cell by Right Click 2 Isn’t it quicker?  Let’s try and experience it on your own.

Reminder: To move cell, you need to move your cursor to an edge of the selection range (the thick border), where the cursor changes to “hand” or “cross with arrow heads”.

What? Two clicks is too much?  um… Please read Mouse Tip – Move Cell with Shift Key!

Advertisements
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

2 Responses to Move cells by Right-click Drag and Drop

  1. Pingback: Mouse Tip – Move cell with Shift Key | wmfexcel

  2. MF says:

    Have you ever tried this trick? If you have tried it on a new workbook, you may find that the “Create Hyperlink Here” does not work. Forgot to mention, this “Create Hyperlink Here” works only on saved workbook. Please save your workbook before you try that.

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s