Page 179 - IT 402 v2.0 class 10
P. 179
Creating Cell Reference to other Worksheets
o create a reference for a cell or range of cells to another worksheet in the same workbook write the name
of worksheet followed by a dot mark . before the cell address. In other words for creating cell reference to
another worksheet following format can be used:
Reference to an Individual Cell
Syntax: Sheet name. ell address
Example: To refer to cell A1 in Sheet2, type ‘Sheet2.A1’
Reference to a Range of Cells
Syntax: Sheet name.First cell: ast cell
Example: o refer to cells : in Sheet type Sheet . :
In the following example the worksheet function named calculates the average value for the range
: created on the worksheet named Marketing in the same workbook.
1 2
=AVERAGE(Marketing.B1:B10)
3
efers to the worksheet named Marketing .
ange of cells between to inclusively.
Separates the worksheet reference from the cell range reference.
N ot e s
non-alphabetical
or
name
includes
spaces
it
in
single
enclose
characters
you
must
worksheet
If the worksheet name includes spaces or non-alphabetical characters you must enclose it in single
If If the worksheet name includes spaces or non-alphabetical characters you must enclose it in single
the
in
cell
marks.
anuary
Sales
named
a
worksheet
to
example
For
uotation marks. For example a cell reference to cell in a worksheet named anuary Sales
a
reference
uotation marks. For example a cell reference to cell in a worksheet named anuary Sales
cell
uotation
should be written in this format: anuary Sales
should be written in this format: anuary Sales
Ways to create cell referencing to other sheets
here are two ways to create cell reference to other sheets:
y entering the formula directly using the keyboard
By using the mouse
etails about Sales of Stationery Items for the months of anuary February and March are maintained in
different worksheets.
Sales in January Month
Advanced Features of Spreadsheet 177

