Home / MS-Excel / Functions and Formula

Using Ranges names for formulas

Range names are extremely useful not only for documenting the function of the formulas in your worksheet, but also for finding and selecting cell ranges quickly and easily. This is especially helpful in a large worksheet that you are not very familiar with or only use intermittently.

Following these sections:

  • Advantages to Naming Cells and Ranges

  • Introducing Ranges Names

  • Defining Range Name

  • Editing Ranges Names

  • Managing Range Names

  • Creating a Name from a Selection

  • Creating a Dynamic Range

  • Working with Range and Cell Names

  • Using Names in Formulas

  • Intersection Operators with Names

  • Applying Names to Existing Formula

  • Naming Constants and Formulas

  • Excel Maintains Cell and Range Names and More from MS-Excel

In this tutorial:

  1. Advantages to Naming Cells and Ranges
  2. Introducing Ranges Names
  3. Defining Range Name
  4. Editing Ranges Names
  5. Managing Range Names
  6. Creating a Name from a Selection
  7. Creating a Dynamic Range
  8. Working with Range and Cell Names
  9. Using Names in Formulas
  10. Intersection Operators with Names
  11. Applying Names to Existing Formula
  12. Naming Constants and Formulas
  13. Excel Maintains Cell and Range Names