How do I create a named cell in Microsoft Excel?
To create a named cell in Microsoft Excel select the cell you want to name and click the Name Box next to the Formula bar, as shown in the image to the right. This bar has the current cell location printed in it. For example, if you're in cell A1, it should currently say A1 in the Name Box. Once in the Name Box, type the name you want to name this cell and press Enter.
Once a cell has been named, you can refer to this cell in a formula, chart, or anything else that uses cell references. For example, lets assume you named a cell "profits", when creating a new formula you could type =sum(B10+profits) to add cell B10 plus the value in the profits cell.
Tip: When naming a cell or range it can only be one word, in other words no spaces.
Tip: In Excel use the shortcut key Ctrl+F3 to open the Name Manager. In the Name Manager, you can create, edit, and delete any Excel names. Once a name has been created you can use the shortcut key F3 to insert any name.
- See our Excel definition for further information and related links.