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.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
