Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011.
Labelling formulas helps make them much simpler to understand and sustain. A name can be defined for a range of cells, function, constant, or table. After adopting the practice of applying names in your workbook, it is easy for you to update, audit, and organise these names.
Name a cell
- Choose a cell.
- In the Name Box, enter a name.
- Hit Enter.
Define names from a selected range
- Choose the desired range to name alongside the row or column labels.
- Click Formulas > Create from Selection.
- In the Create Names from Selection dialogue box, format the location that includes the labels by clicking the Top row,Left column, Bottom row, or Right column check box.
- Press OK. Excel defines the cells based on the labels in the range you specified.
Use names in formulas
- Choose a cell and type a formula.
- Locate the cursor for the area that you want to use the name in that formula.
- Enter the first letter of the name, and choose the name from the list that appears. Or, click Formulas > Use in Formula and press the name you want to use.
- Hit Enter.
Manage names in your workbook with Name Manager
- On the Ribbon, go to Formulas > Defined Names > Name Manager. You can subsequently create, edit, delete, and locate all the names used in the workbook.