Page 180 - IT_V1.0_Class10
P. 180
Creating Cell Reference to other Sheets
To create a reference for a cell or range of cells to another sheet in the same spreadsheet, write the name of
sheet followed by a dot mark (.) before the cell address.
In other words, for creating cell reference to another sheet, following format can be used:
Reference to an Individual Cell
Syntax: $Sheet_name.Cell_address
Example: To refer to cell A1 in Sheet2, type $Sheet2.A1
Reference to a Range of Cells
Syntax: $Sheet_name.First_cell:Last_cell
Example: To refer to cells A1:A10 in Sheet2, type $Sheet2.A1:A10
For example, the sheet function named AVERAGE calculates the average value for the range B1:B10 created
on the sheet named Marketing in the same spreadsheet.
1 2
=AVERAGE($Marketing.B1:B10)
3
Here,
1. Sheet name is Marketing
2. Range of cells between B1 to B10, inclusive of ends.
3. Dot(.) Separates the sheet reference from the cell range reference.
Notes
If the sheet name includes spaces or non-alphabetical characters, it must be enclosed in single quotation
marks. For example, a cell reference to cell A1 in a sheet named January Sales should be written in this
format: $’January Sales’.A1
Ways to Create Cell Referencing to Other Sheets
There are two ways to create cell reference to other sheets:
By entering the formula directly using the keyboard
By using the mouse
Details about Sales of Stationery Items for the months of January, February and March are maintained in
different sheets.
Sales in January Month Sales in February Month Sales in March Month
A new sheet is inserted and renamed as Quarter Sales to store the Total Sales of each item.
178 Information Technology Play (Ver 1.0)-X

