Tame your computer - clever copying

There is a variety of ways to copy all data from one sheet to another. Perhaps you simply copy and paste everything? Or perhaps you right-click the sheet that contains all the data you want to copy and select “Move or Copy”?

Well, during this week’s Excel training session Yvonne reminded me of the quickest way… drag. (Thanks, Yvonne!)

Here's how:

1.       Open the workbook that contains the sheet you want to copy.

2.       Hold down the CTRL key while you drag the worksheet to its new location.

3.       When the small page (which moves with the pointer) appears, release the mouse button.

This also works if you want a copy of the worksheet in another workbook, as long as you arrange the two workbooks, say, side by side. Have a look at  http://www.roem.co.uk/tip_162.html for some additional information.

PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.


25 June 2013

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email  (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
_________________________________________________