Moving with Choices
We all know that if we click, hold and drag the outline around a selected MS Excel cell (that is, when you have the four direction arrow), we can then drag the contents around the worksheet and move them to a new location.
Very nice. Quick and easy.
But would you like some choices added to this maneuver?
Instead of a left click, hold and drag, try a right click, hold and drag the next time.
When you release the right mouse button, you’ll find that a menu of options will open up, giving you more power with one movement.
Use your mouse to select an option and instantly, the data is where you want it, how you want it. Oh yeah!