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

Naming a Range

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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