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…
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… To perform the task above, I used to use Cut and Insert Cut Cells…
- Select the target cells
- CTRL X (to cut the cells); or right click –> Cut
- Select the destination cells
- 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:
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!
is there any video on how to create dashboard on excel
Pingback: Mouse Tip – Move cell with Shift Key | wmfexcel
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.