 |
Identify the cell or range you want to reference. |
|
Determine the names of the first and last worksheets you want to reference. |
|
Select the cell in which you want to use the reference. |
|
Type = |
|
Type
a function Example: SUM |
|
Type
( |
|
Click the sheet tab of
the first worksheet you want to reference. |
|
Shift-click the sheet tab
of the last worksheet you want to reference. |
|
Select the cell or range to be referenced. |
|
Type ) |
|
Press the Enter key. |