Autoplay Next video from Max length

Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets

4,723 views · Published 19 July 2012 · 2:43 · Indexed 14 November 2026

Channel: excelisfun · 2012 · Education

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT947-948.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
When making calculations across many sheets that have the same demensions it can be useful to use a Defined Name 3-D Cell Reference:
1. Ctrl + F3 (open Name Manager)
2. Click New
3. Type Name
4. In Refer to: textbox, click first sheet
5. Select Range
6. Hold Shift
7. Click on last Sheet, Save Name

Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets

More from this channel