Wednesday, 1 May 2013

Multiple Sheet Referencing in Microsoft Excel:

We can use (refer) cell of one sheet in any calculation on another sheet. For this we just have to use following syntax:

Sheet_name!cell_name
If we have changed the sheet name (sheet rename) then we must use that name. The picture is showing total of A1 cell of sheet1(value:10), Sheet2(value:20), Sheet3(value:30) on 4th Sheet.

No comments:

Post a comment