A formula in Microsoft Excel can contain a set of cells that are used for computations such as adding up numbers, calculating averages, and more.
For instance, you would write the words C2:C15 in the parenthesis of the formula if you wanted to include cells C2 through C15 in it.
The range of cells might also be given a name, which could subsequently be used in the formula as an alternative.
If the same set of cells is used in several formulae, using a predetermined name might make typing and remembering the formula easier.
Additionally, it can aid in preventing a formula’s modification when transferred between cells.
Name a group of cells
The procedures shown below can be used to give a range of cells in Microsoft Excel a name.
- Choose the required cell range in the Excel file.
- Select Define Name from the pop-up menu by performing a right-click on the chosen cells.
- Enter a name for the chosen cells in the Name box of the New Name window, then click Ok.