Cell address in MS Excel
Before moving forward, it is important to understand the concept of the cell address. There are more than 17 billion cells in a single worksheet. How will we differentiate between two cells? For this, we assign an address to every cell. A cell address is nothing but the intersection of the row and column where the cell is located. For example, a cell in column D and row 4 has the cell address as D4.
It is very important to understand the concept of cell address because while using formulas, Excel saves the formulas using the cell address and not cell contents. It helps us to change the contents of a cell. Excel automatically changes the contents of the formula cell on the basis of the new data. That is, if the digits of the cell are changed, the formula will now give the result on the basis of new digits entered in the cell. Thus, it saves a lot of time of the user.