A 3-D reference is one that refers to the same cell or range on multiple sheets. In Excel, a 3D reference refers to the same cell or set of cells across numerous worksheets. It’s a quick and easy way to calculate data across multiple worksheets with the same structure, and it could be a viable substitute for Excel’s Consolidate feature.