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.