17 July 2017
This tutorial explains what an Excel name is and shows how to define a name for a cell, range, constant or formula. You will also learn how to edit, filter and delete defined names in Excel.
- Excel name - the basics.
- How to name a range in Excel.
- How to create a named constant.
- How to make a named formula.
- How to name columns and rows (create names from selection).
- How to create a dynamic named range in Excel.
- Excel name rules.
- Scope of Excel names.
- Excel Name Manager.
- Top 5 benefits of using names in Excel.
- Excel named range - tips and tricks.