When you’ve finished adding data to a worksheet—such as at the end of a calendar month, when you create a new worksheet to store data for the next month—you might want to include the entire worksheet as part of a monthly overview to your general manager. Rather than keep all of the worksheets in their original workbooks and flip from document to document when you create your presentation, you can copy the worksheet from the current workbook (and any other worksheets with data you want to include) to a central document. Going from worksheet to worksheet is much easier than going from workbook to workbook!

Copy Worksheets within the Workbook

Hold the down Ctrl key and drag the worksheet you want to copy to the new location.

Caution

If you don’t hold down the Ctrl key while you drag the sheet tab of the worksheet you want to copy, you will just move the worksheet to a new location in the workbook.