Create a named range from selected cells in a worksheet

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less

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.
Click Formulas > Create from Selection.
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.
Click OK.