Home >Tips >Excel 3d Formulas kalmstrom.com site map icon Site map  

3D Formulas in Excel – change multiple sheets at the same time

An Excel tutorial by Peter Kalmstrom

Excel iconThe possibility to tell Excel to calculate is a crucial feature and the most important reason to use it. In the demo below Peter Kalmstrom explains how you can manipulate several worksheets simultaneously.

A 3-D reference refers to the same cell or range on multiple Excel sheets. It is useful when you work with several sheets that follow the same pattern and when cells on each sheet contain the same type of data.

In this tutorial Peter uses budget data from different departments of an organization. Each department has its own tab in the Excel workbook, but by using 3D references he can set auto-sums for all sheets in one process.


Excel sheet



Peter also creates a new worksheet for the whole company. Using 3D referencens he can vey quickly get them sums for all the departments into it.


Excel sheet


Peter uses Excel 2013 for his demo, but  3D references works for earlier versions of Excel too.