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.

Things You'll Need

  • Excel Book
  • Microsoft Excel
Show More

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.

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

Related Searches:

Comments

You May Also Like

Related Ads

Featured