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.

Difficulty: Easy

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

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.

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