Absolute and relative cell address

Each cell in the table has an address that consists of the name of the row and column in the cross section of which it is located. However, sometimes it is necessary to indicate both a worksheet or a workbook (document), it belongs so that we could use it as an operand in some form. Below it will be the address of the cell address that uniquely determines where it is located.

The cell address A1 is something that, by itself, is clear; this is the cell located in column A and in the first row. However, if we have multiple worksheets called, for example, Sheet1, Sheet2, and Sheet3 we need to know how to differentiate cell A1 in the three mentioned worksheets. This is done by first listing the worksheet name in the cell and then, after the exclamation mark (!), The address of the specific cell is also indicated. Respectively, cell A1 in the three worksheets would be called Sheet1! A1, Sheet2! A1 and Sheet3! A1.

The address in which we see only the name of the row and the column to which the cell belongs is called the relative cell address (relative to the worksheet we are currently in), and the address in which we see the workbook tag to which the cell’s absolute address belongs worksheet).

And is the absolute cell address really absolute? It is not. The absolute cell address can also be upgraded to the workbook volume (document) to which the workbook belongs to where the cell is. An absolute address update is done by putting the name of the workbook in parentheses in front of the name of the worksheet. For example, if cell A1 is in Sheet1 workbooks Book1, its absolute address would be [Book1] Sheet1! A1.

Sometimes the workbook name consists of several words. In this case, the worksheet name should be covered by single sign (‘). The same rule can also be applied at workbook names, and in this case the physical paths on the disk where the workbook is located can also be mentioned. In this way, the cell address A1 could look like this: ‘D: \ [Book1.xlsx] Sheet1! A1’.