How to Insert Identical Information Into Several Excel Worksheets

Microsoft Excel organizes its spreadsheets into tabbed workbooks, with each tabbed page an individual spreadsheet. Occasionally, you'll want to insert information from one worksheet into another, such as when you have several worksheets handling preliminary calculations and the last displaying a grand total. Read on to learn how to insert identical information into several Excel worksheets.

Instructions

Difficulty: Moderate

Setting Up the Workbook

1. Create a new workbook by selecting "New" from the "File" menu or clicking the New button on the main toolbar.
2. Insert as many additional pages into the workbook as you need by selecting "Worksheet" from the "Insert" menu or right-clicking on a tab and selecting "Insert" from the pop-up menu.
3. Rename each page to something more meaningful by double-clicking on the tab to highlight the name and typing in the new name or right-clicking and selecting "Rename" from the pop-up menu.
4. Format each page with titles and column labels as necessary. Use the Copy feature to copy static information from one worksheet to another.
5. Enter the numeric data you need on each worksheet and set up any preliminary calculations for that worksheet.

Inserting the Information

6. Jot down the name of the worksheet and the cell address for each piece of dynamic information you wish to carry from one spreadsheet to another. (If you have only a few cells you wish to carry over, don't bother writing their addresses down first.)
7. Click on the cell in the new worksheet to which you wish to carry the information.
8. Refer to the cell whose contents you wish to copy by entering "=SheetName!An," replacing "SheetName" with the actual name of the worksheet you are copying from "A" with the column letter and "n" with the row number of its cell. (If the name of the reference worksheet includes spaces, you must enclose the worksheet name in parentheses.)
9. Repeat Step 3 for each cell whose contents you wish to copy into another worksheet. If you are copying the same cell's information into multiple worksheets, use the Copy feature to copy the reference formula into the other worksheets.

Tips & Warnings

• When renaming worksheets, enter a name without spaces. This will reduce the possibility of errors.
• While it is possible to display individual numbers on one worksheet and calculations on another, e.g. "=SheetName!(SUM(A1:A10))," it is usually best to display a subtotal on the original worksheet and copy that cell into another worksheet to keep formulas as simple as possible.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.