3D Formulas in Excel – change multiple sheets
at the same time
An Excel tutorial by Peter Kalmstrom
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
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.
Peter also creates a new worksheet for the whole company.
Using 3D references he can vey quickly get them sums
for all the departments into it.
Peter uses Excel 2013 for his demo, but 3D references
works for earlier versions of Excel too.