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! 🙂

Advertisements
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

    Like

  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!
    Cheers,

    Like

  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.

    Like

  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:

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