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

Chapter 8. Working with Larger Workbooks > Creating a Reference to Another Work...

Creating a Reference to Another Worksheet

Sometimes you need to refer to information stored in another worksheet. For example, if you have a workbook with sheets for each month’s sales information, along with a worksheet that totals the monthly worksheets, you can create a reference in the Totals worksheet that instructs Excel to reference the data in the various monthly worksheets. When you create a reference to a different sheet, Excel will use the name of the sheet first, then the cell location.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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