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. Anonymous
    2021-03-25T08:45:37+00:00

    Hi Mia Zhoa ,

              It would be helpful if you could provide me an official page that describes the rules for the name manager , the above provided page has the rules for the table names which is not related . Thankyou.

    0 comments
  2. Anonymous
    2021-03-25T09:00:20+00:00

    Hi Keerthi,

    Sorry I haven't found the official reference related with name manager, Kindly submit your feedback in Excel to let related product team make improvements for clarifying that. 

    Best Regards,

    Mia

    0 comments