Awesome Excel tip #5

Moving columns and rows

Moving data in Excel can happen in various ways. Sometimes we copy/cut and paste. Sometimes we move entire columns. Other times we just need to move a range of cells. The problem comes in when data already exists in the area we are moving the selected data to.

This cool method shows how you can move a range anywhere quickly without overwriting any other data or having to make space for it first.

Step 1 : Select the data you want to move
Step 2 : Hold down your SHIFT key
Step 3 : Move your pointer to the edge of the selection so you see the 4-arrow (move) icon
Step 4 : While holding SHIFT, click and drag the selection anywhere and then release

Demonstration