Mouse Tip – Move cell with Shift Key

Excel Tips - Move cells with Shift Drag

If you have read my post about Move Cells with Right Click, you should know it is possible. However for continuous improvement, we often look for faster way to achieve the same thing.  With a simple trick, you may move cells and shift surrounding cells down or right easily:

Excel Tips - Move cells with Shift Drag 1

Please try and see if you like it!  I like it a lot! 🙂

Prefer a video? Here you go:


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.

6 Responses to Mouse Tip – Move cell with Shift Key

  1. Faizan Shahid says:

    You can do the same by doing the following:
    Select Cells by Shift + Arrows
    Cut the selected Cells by Ctrl + X
    Move to destination Cell
    Insert by Ctrl + Shift + “=” Key


  2. MF says:

    Not to my surprise, many people (around me) are not aware of this trick… 🙂
    Have you experimented that on your own? If you did, did you try that with Ctrl Shift too? Let’s experiment it and have fun!


  3. Pingback: Quick Tipp: Wie man eine Liste per Mausklick ergänzt | ExcelNova

  4. Lukas says:

    Nice! Didn’t know that one. I’ll be sharing it with my community.


  5. Pingback: Move cells by Right-click Drag and Drop | wmfexcel

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 )

Twitter picture

You are commenting using your Twitter 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.