Weekly Computer Tip # 397
22 June 2013

Copy the content of a worksheet (Excel 2003-2013)

There is a variety of ways to copy all data from one sheet to another. Perhaps you insert 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 tip 162 for some additional information.