Microsoft Office Tutorials and References
In Depth Information
To Copy the Contents of a Worksheet to Other Worksheets in a Workbook
With four worksheets in the workbook, the next step is to copy the contents of Sheet1 to Sheet4, Sheet2, and
Sheet3. Sheet1 eventually will be used as the Company worksheet with the consolidated data. Sheet4, Sheet2, and
Sheet3 will be used for the three region worksheets.
• Click the Sheet1 tab.
• Click the Select All button and
then click the Copy button on the
Ribbon (Figure 6–35).