Excel 3D References - AdvantEdge Training & Consulting

Excel 3D References

With an Excel 3D reference, a cell in a worksheet may link to a cell in another spreadsheet or an entirely new workbook. To create them simply, select the cell you want to receive the data, enter an = sign, and then click on the cell that will send the data.
Too many 3D references can make Excel spreadsheets slow to load, complex to maintain, and apt to crash. If you find that you need a lot of these types of references you may want to upgrade to Access.
In the Inquire tab, Excel has several options for viewing the relationships between cells, worksheets, and workbooks. Click on whatever option is appropriate for your type of references, and Excel will create a simple chart.


Become a Master of the Spreadsheet with Excel 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