Tricky secret to move cells in Excel

Move cells and columns with your mouse

If you want to copy cells or columns to a nearby location, simply select the cells and then hold the mouse over the border. In this case, the 4-way arrow is displayed, which means that you can move the cells. Simply move them with the mouse (drag-and-drop).

move cells easilyIf you also press Ctrl, the arrow changes to +.

If you are moving the range this way, the original cells will be preserved and there will be a copy on the other place, too.

Always pay attention to the shape of the mouse as it indicates that you are moving or copying the selection.

Changing columns, or move columns within the table

move cells simplyIf you press the Shift button while moving the cells, you can move the column (or cells) so that it insert additional cells – and doesn’t overwrite the original data.

In this case, a gray “strip” shows where the data is transferred. (In the small gray window, the exact cell range is displayed.) As you release the mouse (still hold down the Shift key), the cells will slip right, and the cell or column exchange is ready.

More Excel secrets

Come and learn with us, take Privat Excel Lessons through Skype.

Vélemény, hozzászólás?

Az email címet nem tesszük közzé. A kötelező mezőket * karakterrel jelöltük