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! 🙂
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.
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
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!
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.
Glad that you like it! 🙂
Pingback: Move cells by Right-click Drag and Drop | wmfexcel