Tame your computer – clever copying

25 Jun

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 last 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: