In a worksheet, pick the cells you want to be in a designated range.
In addition to the row or column labels, choose the range you want to designate.
Go to Formulas > Create from Selection by clicking.
Select the appropriate checkbox in the Create Names from Selection dialogue box based on where your row/column header is located.
Choose OK.