We create Range Names in Excel for cells that we might like to either:
Quickly Navigate to , or to use in functions like Vlookup.
If you select a range of cells and include the heading labels, however if the heading label starts with a number ie: 2017 Budget Excel will add the underscore.
- Select the cells – include the heading
- Formulas tab, Define Names Group
- Select Create from Selection
- This will Automatically detect the heading name and use it for its range name. However generally you can not start a range name with a number so Excel will compensate by adding an underscore at the beginning. ie:_2017_Budget.