- Image and text skills
The name manager function of the table can customize the name to replace the cell reference.
When using the "Name Manager" function, I encountered an error pop-up window saying "the name is illegal" and "the formula entered is incorrect". What is the reason for this?
▪Name cannot be empty
When creating a new name, an error message will be displayed if the name is empty.
▪The reference position cannot be empty
When creating a new name, if the reference position is empty, an error message will be displayed.
▪Name cannot start with a number
When creating a new name, if the name starts with a number, an error message will be displayed.
▪Name cannot use non-standard characters
When creating a new name, the characters allowed in the name include letters, numbers, periods, question marks, and underscores. If non-specified characters are used, an error reminder will be displayed.
▪Logical values cannot be used in names
When creating a new name, when a logical value is used in the name, such as "TRUE", "FALSE", etc., an error reminder will be displayed.
▪Cell reference style cannot be used in the name
When creating a new name, if the name references a cell reference style, such as A1, R1C1, etc., an error reminder will be displayed.
▪Name cannot exceed 255 characters
When creating a new name, if the number of characters in the name exceeds 255 characters, an error reminder will be displayed.
▪Name cannot be repeated
When creating a new name, if there are duplicate names in this worksheet, an error reminder will be displayed.
When creating a new name, we can avoid these wrong creation methods and we can successfully create the name.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/chang-jian-cuo-wu-dan-chuang-yu-jie-jue-fang-fa-ming-cheng-guan-li-qi-tian-xie-bu-he-fa-zen-me-jie-jue.html
评论列表(196条)
测试