Forum Discussion
Excel
In my assignment it says I highlight the range A2:b6 on the formula ribbon,Defined Names section click on Create from Section.Make sure Left Column is checked. I dont have a Create Names option in my...
Hello,
The Create from Selection is located in the Defined Names of the Formulas tab as seen below
The shortcut to apply Create from selection is CTRL + SHIFT +F3.
So, just select the range A2:B6 and apply the short cut above or click on Create from selection
In the Create from Selection dialogue box, uncheck Left Column
Click OK
When you check the Name Manager or the Name box, you should see the named range.
Regards