Google 电子表格范围名称
在 Google 文档电子表格中，可以使用 范围名称在单元格范围上放置标签以使公式更清晰。 在大多数公式中，可以使用范围 C:C 来表示整个 C 列，使用 C2:C 来表示 C2 之后（包括 C2）的整个 C 列。
有没有办法创建相同性质的范围名称？ 当我尝试 C:C 或 C2:C 或 Sheet!C:C 或 'Sheet'!C:CI 时，总是收到错误“您指定的范围不是有效的范围格式”。 当我的表单向电子表格添加行时，我希望范围名称能够扩展。 谢谢。
In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more legible. In most formulas, one can use the range C:C to denote the entire C column, and C2:C to denote the entire C column after and including C2.
Is there a way to create range names of the same nature? When I try C:C or C2:C or Sheet!C:C or 'Sheet'!C:C I always get the error "The range you specified is not in a valid range format." I would like the range name to expand as my form adds rows to my spreadsheet. Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
我刚刚发现如果您使用“-”运算符，它会从底行开始。 所以，
从最后一行开始一直到 D12！
I just discovered the if you use the '-' operator, it starts from the bottom row. So,
starts from the last row and works it's way up to D12!
我有类似的问题。 尽管我不知道如何准确执行您所要求的操作，但您可以通过引用尚未创建的单元格来执行基本相同的操作。
例如：
C 列当前有 100 个单元格（工作表中有 100 行）
不要使用 C:C 引用它，而是使用 C1:C999
如果您将行引用设置得足够高，那么您就可以考虑将来将创建的行。 希望能帮助到你。
I had a similar problem. Although I do not know how to do exactly what you are asking, you can do essentially the same thing by referencing cells that are not yet created.
For example:
Column C currently has 100 cells (100 rows in the sheet)
Instead of referencing it with C:C, use C1:C999
If you make the row reference high enough, then you can account for future rows that you will create. Hope it helps.
我不这么认为......即使您在范围名称选择器中手动选择列，它也会抱怨。 这将是一个很好的功能，而且很有意义，因为它们已经支持公式的列范围。
I don't think so... even if you select a column manually while in the Range Name selector, it complains. That would be a nice feature and it would make sense since they support column ranges for formulas already.
我相信这现在确实有效。 我的范围名称为“Sheet1!A10:AW10”，没有任何问题。
如果您尝试执行整个列，我认为它只会占用当时列中的所有可用单元格。 即，如果稍后创建更多单元格，则需要手动添加到范围名称。
I believe this does work now. I have a range name of "Sheet1!A10:AW10" with no problems.
If you try to do a whole column, I think it will just take all the available cells in the column at that time. i.e. if you make more cells later, you need to manually add to the range name.
我对
A3:A这样的范围也有同样的问题，它通常在其他地方工作，例如ARRAYFORMULA()，但解决方法是不指定起始行，例如如A:A。 如果出现问题，您可以使用ARRAYFORUMULA(A25:A)作为公式，通过另一列代理数据。更新：显然我没有正确阅读问题。 我看到OP尝试省略行号，所以也许当时它不起作用，但现在可以了。 注释仍然不起作用。
Update2：我没有注意到谷歌电子表格将
A:A等范围替换为A1:A50，因此稍后添加的新行仍然不会被包含在内。 我认为这就是@Dean 在他的回答中试图表达的内容。I had the same problem with ranges such as
A3:Awhich normally work in other places such asARRAYFORMULA(), but the workaround is to not specify the starting row, such asA:A. In cases when this would be a problem, you can proxy the data through another column using something likeARRAYFORUMULA(A25:A)as the formula.Update: Apparently I haven't read the question properly. I see that the OP had tried leaving out the row number, so perhaps it wasn't working at that time, but it does now. The notations still don't work.
Update2: I didn't notice that google spreadsheet replaces ranges like
A:AtoA1:A50, so new rows added later on do not still get included. That I think is what @Dean is trying to say in his answer.我认为使用 Insert -> 这是一个有用的工具。 定义新范围以使向导出现并使语法正确。 呵呵
我在其他主题中的回复
I think it's a helpful tool to use Insert -> Define new range to make a wizard appear and make the syntax correct. Hehe
My response in other topic