98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Moving and copying data
Moving and copying data
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome 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. |