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.
In this tutorial:
- 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
More from MS-Excel