To make working with ranges easier, Excel allows you to name them. The name Sales, for example, is easier to remember than the coordinates B4:D10. You can use named ranges in formulas the same way you use cell references and range addresses. Named ranges can be helpful when navigating larger worksheets. Name a Cell or Range
Select a Named Cell or Range
|