You can quickly create a named range by using a selection of cells in the worksheet.
Note
Named ranges that are created from selecting cells have a workbook-level scope.
- Select the range you want to name, including the row or column labels.
- Select Formulas > Defined Names > Create from Selection or use the keyboard shortcut Ctrl + Shift + F3.
- In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header. If you have only a header row at the top of the table, then just select Top row. Suppose you have a top row and left column header, then select Top row and Left column options, and so on.
- Select OK.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
See Also
Insert a named range into a formula in Excel