Page 26 - CG_v2.1_flipBooks_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
Formulas tab.
3 Click on the Define
Name button.
1 Select the range of cells to which
you want to assign a name.
The New Name dialog box appears on the screen.
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 Computer Genius (V2.1)-VI

