Question

How to define a name to a cell range in a worksheet in theory?

Answer 1

Answer:

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.