In the example, the formula in F6 is: where “sales” is the named range C4:C10. Other examples of formulas that use this same named range are: Note: named ranges are absolute references by default. 

How to create a named range

To quickly create a named range: Video: How to create a named range. More detailed information: Named ranges in Excel. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.