Now I can easily refer to that name in a formula. Simply select the cells you want to name, and type the name in the box.įor example, to give the data in this table a name, first select the cells that include the data, then enter a name in the name box. The simplest way to create a named range is to use the name box, which sits to the left of the formula bar. Let's take a look at a few ways to create named ranges.
They make your formulas much easier to read and understand they automatically give you absolute references, and they reduce errors. Named ranges are one of the most useful features in Excel.
