Page 26 - ThinkGPT_V2.1_C6_Flipbook
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 Premium Edition-VI

