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

Hour 14. Working Smarter > Working with Formulas That Reference Other Workbooks...

Working with Formulas That Reference Other Workbooks and Worksheets

Because a workbook can contain multiple worksheets, you might need to reference a cell in another worksheet or even another workbook file. No problem! As long as you follow the proper syntax, you can type a formula that contains a reference to any file.

If the cell is contained in another worksheet in the current workbook, you need to include the sheet name followed by an exclamation point (!) and then the actual address of the cell. Blank spaces are not allowed. For example, Sheet4!A75, points to cell A75 on Sheet 4 of the current workbook. Anytime you reference another worksheet in the workbook, you must include the exclamation point. If you've renamed a worksheet from its default sheet name, use the sheet name and an exclamation point.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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