Try it!
In Excel, you can name cells and cell ranges, and use those names in formulas. This is a useful feature that makes formulas easier to understand and maintain.
Name a cell
-
Select a cell.
-
In the Name Box, type a name.
-
Press Enter.
Define names from a selected range
-
Select the range you want to name, including the row or column labels.
-
Select Formulas > Create from Selection.
-
In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
-
Select OK.
Excel names the cells based on the labels in the range you designated.
Use names in formulas
-
Select a cell and enter a formula.
-
Place the cursor where you want to use the name in that formula.
-
Type the first letter of the name, and select the name from the list that appears.
Or, select Formulas > Use in Formula and select the name you want to use.
-
Press Enter.
Want more?
Define and use names in formulas