3D Cell Reference in Excel

3D Cell Reference in Excel-

This referencing methodology refers to the same cell or to the same range of cells in multiple worksheets.

In given below figures we have two different sheet data in same cell reference. We wants to find the total amount of both month in new worksheet. To do this we use 3D referencing to add all the cell references of the both sheets in new worksheet.


To refer to the cell references of two sheets, we need to click Jan Worksheet tab, hold the Shift key, and the click Feb Worksheet tab 


The following figure show the 3D cell referencing formula.



Post a Comment

0 Comments