Share via

The syntax of the name isn't correct when naming an excel named range in name manager

Anonymous
2021-03-23T07:43:27+00:00

I was trying to create a named range with the name that includes '&' character in it , excel doesn't allow me to create one and pops up a waring box indicating the syntax isn't correct along with 3 rules to verify the name specifying not to include spaces or characters that isn't allowed . I could not find any page by microsoft that specifies that characters that are not allowed while naming a named manager . I kindly request the microsoft community to specify the rules for naming the named ranges in excel.

Thankyou.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2021-03-23T08:09:27+00:00

    Use characters A to Z and _ in names and your are on the safe side.

    You can use numbers 0 to 9 also, but you can not define a name that is equal to a cell reference in absolute and R1C1 reference style.

    Andreas.

    2 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2021-03-23T08:41:24+00:00

    Hi Keerthi,

    Sorry for all the inconvenience it may has caused on your side.

    Hope the clarification in this official article could offer some help on your concern, kindly check: Using structured references with Excel tables - Office Support (microsoft.com).

     

    Also, kindly submit you feedback in Excel if it is convenient so that related product team can notice that they could do something better to avoid any inconvenience on customers' sides with a well-defined rule in the Name Manager feature. Also, I will submit this suggestion from our side.

    Appreciate your prompting and any suggestions or ideas to promote a better experience with Microsoft applications are highly valued. Hope you have a nice day and stay safe.

    Best Regards,

    Mia

    0 comments
  3. Anonymous
    2021-03-23T09:07:13+00:00

    Thankyou , this official page specified is helpful in understanding the rules , but this page is not specific to named ranges in names manager . This would have been more convenient for the users if it specified as rules for name manager . As a suggestion it would be great if these rules are specified in the warning box that pops up if the syntax in naming isn't correct in excel.

    0 comments