Page 26 - Digicode_AI_class_6
P. 26
Naming a Cell Range
Excel allows us to assign a name to a cell range. This name can be used in place of cell address in
formulas. To assign a name to a cell range, follow the given steps:
2 Click on the 3 Click on the Define
Formulas tab. Name command.
1 Select the range of cells to which
you want to assign a name.
4 Type the name.
5 Click on the OK button.
Now, we can use this name in place of the cell address in formulas.
24 DigiCode AI-VI

