How to Copy an Excel Worksheet
You can copy a worksheet, along with the formulas it includes, so you can base other worksheets on it. These steps work with Microsoft Excel 97.
Instructions
-
-
1
Open Microsoft Excel and the file you want to change.
-
2
Open the Edit menu and select Move or Copy Worksheet.
-
-
3
Click the Create a Copy option in the dialog box.
-
4
Select OK to create a copy.
-
5
Rename your newly copied worksheet by double-clicking its tab at the bottom of the Excel window.
-
1
Tips & Warnings
You can also use the Move or Copy Worksheet command to rearrange your worksheets.
If you think you'll use this worksheet over and over again, save it as a template (use the Save As command in the File menu).