• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Entering and Editing Data > Referencing Formulas from Other Workshee...

Referencing Formulas from Other Worksheets and Workbooks

In addition to using absolute and relative cell addressing in your formulas, you can also reference cells or ranges from other worksheets and other workbook files. To refer to cells in other sheets, use the sheet name as part of the address. For example, to refer to cell C10 on Sheet4, enter the address Sheet4!C10 in your formula. Anytime you reference a sheet name, you must include an exclamation mark. If you've given the sheet a specific name, such as SALES, use the specific name and an exclamation mark (SALES!C10). If the sheet name includes spaces, such as SALES TOTALS, you must surround the name with single quotation marks ('SALES TOTALS'!C10).

Another way to enter a cell address from another sheet is to use the mouse. When you get to the point in the formula where you need to enter a cell reference from another sheet, click the sheet's tab and select the cell or range you want to use. Excel inserts the complete reference, including the sheet name, into the Formula Bar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint