The name manager function of the table allows you to 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?
- The name cannot be empty: When creating a new name, an error reminder 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 reminder will be displayed.
- The name cannot start with a number: When creating a new name, if the name starts with a number, an error message will be displayed.
- Non-specified characters cannot be used in the name: 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 is displayed.
- Logical values cannot be used in names: When creating a new name, if logical values are 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.
- The 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.
- Names cannot be repeated: When creating a new name, if a duplicate name appears in this worksheet, an error reminder will be displayed.
When creating a new name, we can avoid these wrong creation methods and
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/ming-cheng-guan-li-qi-cuo-wu-ru-he-xiu-fu-tian-xie-bu-he-fa-de-wen-ti.html
评论列表(196条)
测试