Excel 3D References - AdvantEdge Training & Consulting
Your business training experts!​

# Excel 3D References

Excel allows you to reference or display values from other worksheets within a workbook. This is called a 3D reference. In the example below, we are going to pull the quarterly total from Sheet 1 to the Total Sales Sheet.

• Position the cursor in the cell where you want to display the number and press the equals sign (=). In our example the cursor is in cell B6 of the Total Sales worksheet.
• Excel 3d references
• Click on the sheet tab that has the number you want to display. (the Qtr 1 tab)
• Select the cell you want to display.
• Press Enter. This will move the cursor back to the original worksheet. Note: The formula bar will display the name of the sheet and the cell number. =’Qtr 1′!B6
• Use the reference ‘Qtr 1′!B6 as you would any cell reference in a formula, so adding it would be =’Qtr 1’!B6 + b7.

#### For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

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

# We can help!

Business Training Classes

#### Copyright AdvantEdge Training & Consulting

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

Scroll to Top