moving and copying data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Moving and copying data

Moving and copying data

resolvedResolved · Low Priority · Version 2003

Clare has attended:
Excel Introduction course
Word Introduction course

Moving and copying data

how to move and copy data most quickly

RE: 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


 

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Server loaded in 0.12 secs.