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!


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

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

  1. maryrose says:

    is there any video on how to create dashboard on excel


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

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


Comments, suggestions, corrections are welcome.

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.