Page 23 - iPro_trackGPT_V5_Class8
P. 23
For example, in the reference $A1, the column A is fixed, but the row can change. In A$1, the row
1 is fixed, but the column can change.
References to Other Worksheets
You can link to cells in different worksheets within the same workbook just as simply as linking
to cells in the current worksheet.
For instance, to add a reference to cell A2 in Sheet2 into cell A1 in Sheet1, follow these steps:
Step 1: Click on cell A1 in Sheet1 and type an equal (=) sign.
Step 2: Click on the Sheet2 tab.
Step 3: Click on cell A2, and then press Enter. You will return to Sheet1.
Step 4: Click on cell A1, and you will see the formula in the formula bar =Sheet2!A2.
The exclamation mark divides the worksheet name from the cell reference.
Other Workbook References
You can link to cells in worksheets from other workbooks in the same way you link to cells in
different worksheets within the same workbook. These links are called external references.
For example, to create a reference to cell A2 of Sheet1 in Book2 from cell A1 of Sheet1 in
Book1, follow these steps:
Step 1: Open both workbooks and name them Book1 and Book2.
Step 2: Click on cell A1 in Sheet1 in Book1 and type an equal (=) sign.
Step 3: Press the Alt+Tab shortcut key to switch to Book2 and click on cell A2.
Step 4: Press the Enter key.
After pressing the Enter key, the formula in cell A1 of Book1 will be =[Book2]Sheet1!$A$2.
This reference has three parts:
The workbook name, Book2, enclosed in square brackets.
The worksheet name, Sheet1, followed by an exclamation mark (!).
The cell reference with absolute address.
So, when you reference cells in an external workbook, you first select the workbook, then the
worksheet, and finally the cell you want to link to.
CUSTOMISE WORKSHEET TAB
Customising worksheet tabs in spreadsheet make your worksheet more efficient and visually
appealing. You can customise worksheet tabs by perform various tasks, such as renaming a
worksheet tab, changing tab colour, changing the tab position, etc.
Renaming a Worksheet Tab
By default, the name of a worksheet is sheet1, sheet2, sheet3, and so on. By renaming worksheets
with descriptive titles, we can easily to identify the contents of it at a glance.
Spreadsheet—Functions and Charts 21

