Naming Ranges for Fast Access

After you enter some or all of a worksheet's content, you might find it easier to refer to cells and blocks of selected cells by name rather than cell address. Just as it's easier to find an employee by asking the receptionist for him by name than to comb the building on foot, looking in each cube or office, so finding cells and ranges by name is faster and easier than trying to find and remember cell addresses. Excel enables you to name individual cells or cell ranges so that you can find data by a logical name and refer to the cell ranges in formulas. You also can use named ranges in formulas, printing, and as a navigational tool for charting and filtering.

To name a cell or range of cells, follow these steps: