excel关联规则算法
As Juliet famously said to Romeo, "What's in a name?" And she was talking about rows (misspelled as "rose"), so maybe Juliet was using a spreadsheet at the time. There are special rules for Excel names, but you might be surprised to see what is allowed.
正如朱丽叶(Juliet)对罗密欧(Romeo)所说的那样:“名字叫什么?” 她正在谈论行 (拼写为“ rose”),所以也许朱丽叶当时正在使用电子表格。 Excel名称有特殊的规则,但是您可能会惊讶地看到允许使用的名称。
Excel中的名称 (Names in Excel)
In Excel, you can create names that refer to cells, or to a constant value, or a formula. After you create Excel names, you can use them in formulas, or quickly go to a named range.
在Excel中,您可以创建引用单元格,常量值或公式的名称。 创建Excel名称后 ,可以在公式中使用它们,也可以快速转到指定的范围。
There are rules for Excel Names, and here's what Microsoft says is allowed. It seems clear, but a few of the rules aren't as ironclad as they look:
Excel名称有规则,这是Microsoft所说的被允许的 。 看起来似乎很清楚,但是其中一些规则并不像看起来那么铁定: