Create a named range from selected cells in an Excel worksheet

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

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 > 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.
Select OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.