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:
Please try and see if you like it! I like it a lot! 🙂
Prefer a video? Here you go:
New Generation Finance - Accounting - Controlling using Microsoft BI stack
A Power BI Creator Blog
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Helping lawyers make the most of Microsoft Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Peltier Technical Services - Excel Charts and Programming
Turn your data into opportunity
Q&A about Excel
Doug Glancy's Excel Site
wmfexcel 
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
LikeLike
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,
LikeLike
Pingback: Quick Tipp: Wie man eine Liste per Mausklick ergänzt | ExcelNova
Nice! Didn’t know that one. I’ll be sharing it with my community.
LikeLike
Glad that you like it! 🙂
LikeLike
Pingback: Move cells by Right-click Drag and Drop | wmfexcel