Question

Mention the steps to name a range​

Answer 1

Another way to make a named range in Excel is this:

Select the cell(s).

On the Formulas tab, in the Define Names group, click the Define Name button.

In the New Name dialog box, specify three things: In the Name box, type the range name. ...

Click OK to save the changes and close the dialog box.