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

Troubleshooting

Range Naming Errors

When I type the range name I want to create in the Name box, Excel displays the messageYou must enter a valid reference you want to go to, or type a valid name for the selection.

You're probably attempting to use a space in the range name, or begin the range name with a number. Unfortunately, names such as 1999 Disbursements are not allowed unless started by an underscore. For this type of name, put the year at the end, and replace the space with an underscore: Disbursements_1999.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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