Excel: Creating ‘3D’ references - AdvantEdge Training & Consulting

Excel: Creating ‘3D’ references

A 3D reference is when the information from a cell in a different worksheet is pulled to a worksheet needing the information.
Example: If your separated worksheets are laid out with information from each quarter (ie: Q1, Q2, Q3, Q4 worksheets), and you need to see overall totals in each worksheet, you can use a 3D reference to pull information into the current quarter, from a prior quarter.
3D references
Notice the formula (SUM Function) in the Formula Bar includes a 3D reference from the Q1 worksheet, cell F4 (‘Q1’!F4). Keep in mind that 3D references cannot be typed in directly, so they must be selected by clicking the worksheet tab, then the cell you want included in the formula. When you are done creating the formula, hit enter like usual and your formula will be completed.

Power up your Excel skills with training from AETC!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top