Create a named range in a worksheet by selecting cells.
Choose the range to name, including the row or column labels.
Select Formulas > Create from Selection from the menu.
Select the checkbox (es) depending on the location of your row/column header in the Create Names from Selection dialogue box.
Select OK.