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.
0 votes
Loading...6 responses to “Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets”
Leave a Reply
Video Tutorials
Bringing you the best video tutorials for Photoshop, Illustrator, Fireworks, WordPress, CSS and others.
Video tutorial posted 24/07/12
Category: Uncategorized
Pages
Random Videos
Video Categories
- 3DS Max Tutorials (150)
- After Effects Tutorials (160)
- C# Tutorials (121)
- Colour (6)
- Crazy Effects (1)
- CSS Tutorials (120)
- Dreamweaver Tutorials (139)
- Excel Tutorials (127)
- Featured (10)
- Fireworks Tutorials (131)
- General Effects (9)
- HTML Tutorials (143)
- Illustration and Vector (1)
- Illustrator Tutorials (174)
- IMove Tutorials (119)
- Lightroom Tutorials (145)
- People and Faces (3)
- Photoshop Tutorials (169)
- Text Effects (7)
- Uncategorized (32)
- WordPress Tutorials (140)
Tags
VideoTutorials.co.uk
-
Videotutorials.co.uk offers the web's best Photoshop tutorials, Illustrator video guides, CSS and HTML tutorials and much more all in one place. With new videos being added every day, you can learn how to master software and code to give your images and website some great effects.
Our site has beginner, intermediate and advanced video tutorials of varying lengths so you can learn a new skill at your own speed and level. So whether you're a web designer, print designer or just wanting to edit some family photos, you can get to it quickly and easily using these free video guides. (more)
You are welcome!!
What a great way to use defined names! Thanks Mike!
I am glad that you like it!
Cool, didn’t know you could define a 3D name. Thanks Mike.
You are welcome! Thanks for the kind words!
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.