Page 29 - CG_v2.1_flipBooks_class_6
P. 29
The exclamation point separates the worksheet portion of the reference from the cell portion.
Other Workbook References
You can use cell references to access cells in other workbooks in a similar manner as you would refer
to cells in different worksheets within the same workbook. These references are called external
references.
For example, to enter a reference to Book2 in Book1, follow the given steps:
Step 1 Create two workbooks named Book1 and Book2.
Step 2 Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.
Step 3 Switch to Book2 by pressing the Alt+Tab keys on the keyboard. Click to select
cell A2.
Step 4 Press the Enter key.
After you press the Enter key, your formula in Book1, Cell A1, should be
= [Book2] Sheet1! $A$2.
This reference has 3 parts:
1. The workbook Book2 in square brackets.
2. The worksheet Sheet1 followed by ! sign.
3. The cell having absolute reference.
Hence, referencing cells in the external workbooks is done by selecting the workbook, then the
worksheet, and then the cell you want to link reference to.
Customise Worksheet Tab
To customise the worksheet tab, follow the given steps:
2 Click on the Rename to
rename the sheet, or Tab
Color to select a tab colour.
3 Type in the name or
select a colour you would
like for your sheet.
1 Right-click
the sheet tab
that you want
to customise.
The name or colour of the sheet will be changed.
You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
and move or copy a sheet, respectively.
Formulas and Functions in Excel 27

