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

Chapter 5. Working with Formulas and Val... > Referencing Cells on Other Sheets an...

Referencing Cells on Other Sheets and Spreadsheets

Before we leave the subject of creating formulas and referencing cells, we should discuss how you reference cells on other sheets of your spreadsheet or on sheets in another spreadsheet file when you create your formulas. Referencing cells on another sheet or spreadsheet can be done by typing the information into the formula or by actually clicking on the cell that you are referring to as you create the formula.

If you wish to reference a cell on another sheet in the same spreadsheet, the syntax is sheet name.cell address. For example, if a formula included cell A3 on a sheet named Quarter 1, the cell would be referenced in the formula by Quarter 1.A3, where the sheet name is separated from the cell address by a period. In cases where a cell range is referenced, the syntax is sheet name, cell range. For example, the range A3:A6 on the Quarter 1 sheet would be referenced as Quarter 1,A3:16.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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