Excel named range - How to define and use names in Excel

Excel named range - How to define and use names in Excel

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.

Topics include:

  • 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.