• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Spreadsheet Basics > Naming Ranges for Fast Access

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint