By introducing a variable name that replaces one to n cells of the table, Microsoft has made it possible, when using formulas, not to worry more about absolute and relative addresses when copying formulas.
We’ve used the name and what cell of the table that it covers, and we can see it on the Formulas / Name Manager.
esu. This address represents a combination of the number of columns and columns. For example, A1 is the first cell, followed by B1, etc.
By combining multiple addresses, we get a unique address for multiple cells. For example, A1: A10 are all cells from column A with numbers 1 to 10.
We need adresses for working with formulas. The cells that represent the arguments of the formula must be precisely selected. However, instead of abstract addresses that are hard to remember, we can give a name to each cell or group of cells. In this way, when we write a formula later, we use its name instead of cell address. We’ll show you how it works.
Give a name to an individual cell
Giving a name to an individual cell can be done in several ways. The first way is by right-clicking the mouse, and then selecting the Define Name option. You are now typing the name you want to use.
The second direct way is to select a cell and then just type the new name in the name field. You can do this with any cell.
Later when you make a formula, instead of the address containing the cell number, you can use its name.
The name is easy to remember and you can use it anywhere throughout the document, regardless of the sheet you are in.
Name the cell group
We do not have to give a name to an individual cell alone. A name can also be given to a group of cells that have some common property.
We only need to select this group of cells, so we type the name as in the previous way.
Now we can refer to a group of cells in the formula, similar to the one in the previous example.