| 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 the cell or range you want to name. | -
| | Click the Name box on the formula bar. | -
Type a name for the range. A range name can include uppercase or lowercase letters , numbers , and punctuation. A range name cannot include spaces in the name. Try to use a simple name that reflects the information in the range, such as VendorNames. -
| | Press Enter. The Name box shows the name whenever you select the range. | Select a Named Cell or Range -
| | Click the Name box list arrow on the formula bar. | -
Click the name of the cell or range you want to use. The range name appears in the Name box, and all cells included in the range are highlighted on the worksheet. Did You Know? You can delete a named range . Click the Insert menu, point to Name, click Define, click the name you want to delete, click Delete, and then click OK. | |