A named range is just a range (either a single cell, or a range of cells) to which you assign a name. You can then use that name in place of normal cell references in formulas, in macros, and for defining the source for graphs or data validation.
Apr 26, 2017 · Another way to create a named range is to use the new name dialog box. To do that, go to the Formulas tab of the ribbon. And then in the Defined Names group, click the Define Name button. How To Create A Named Range In Excel – And Save Tons Of Time! Written by co-founder Kasper Langmann, Microsoft Office Specialist. Most of the time, we use cell references in our formulas. And most of the time, that works well. But Excel’s ability to name cells and ranges can save you huge amounts of time when you’re entering formulas.