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

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

Download workbook: people.highline.edu 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

Don’t forget to check out our other video tutorials or share this video with a friend.

1 Star2 Stars3 Stars4 Stars5 Stars 0 votes
Loading... 1,949 views





6 responses to “Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets”

  1. ExcelIsFun says:

    You are welcome!!

  2. Ticky66MN says:

    What a great way to use defined names! Thanks Mike!

  3. ExcelIsFun says:

    I am glad that you like it!

  4. krn14242 says:

    Cool, didn’t know you could define a 3D name. Thanks Mike.

  5. ExcelIsFun says:

    You are welcome! Thanks for the kind words!

  6. Andre Boltze says:

    Amazing, awesome. Do you often use, when a formula works. BUT I think your apparent ease to every time come up with new examples, and not only that but the tremendous clarity of explaining, exceptional! The quality is really great. Keep it up, I appreciate it.

Leave a Reply

Your email address will not be published. Required fields are marked *