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

Part 5. Working with Formulas and Functi... > Assigning Names to a Cell or Range

Assigning Names to a Cell or Range

Select the cell or range you want to name.

Open the Insert menu, choose Name, and select Define to open the Define Name dialog box, which displays the range coordinates and suggests a name.

If you do not like the name Excel suggests, type a new name. When you are satisfied with the name, click OK.

Excel names the range. When the range is selected, the name appears in the Name box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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