Moving and copying data

Dear Clare

Thank you for attending Excel Introduction!! I hope you enjoyed the course and benefited from it.

Although there are several ways of Cuting and pasting (moving data) and some examples are as follows:

Select cells > Right-click on the selection > choose cut > choose the first cell where the data needs to be pasted > Right-click on it and choose Paste.

You cut and paste using the scissors and the clipboard button on the standard toolbar

The menu bar (Edit > Cut and Paste) can also be used for cutting and pasting

Shortcut keys (CTRL + X and CTRL + V) can also be used.

But my personal favourite and the one I think is the quickest is the following:

Select the cells which need to be moved.

Once the cells are selected move your mouse on the edge of the slection (the dark line) until the mouse pointer changes to an arrow and has a small arrow pointing four directions.

Drag your white arrow to the new location and the existing data will be moved to the new location!!


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007