单元格引用前的感叹号是什么意思? [英] What does an exclamation mark before a cell reference mean?
问题描述
在有关 Excel 的文本中,我阅读了以下内容:
In a text about Excel I have read the following:
=SUM(!B1:!K1)
为单元格定义名称时,将其输入到 Refers To
字段中.
when defining a name for a cell and this was entered into the Refers To
field.
这是什么意思?
推荐答案
当作为 Named range
的引用输入时,它指的是使用命名范围的工作表上的范围.
When entered as the reference of a Named range
, it refers to range on the sheet the named range is used on.
>
例如,创建一个命名范围 MyName
引用 =SUM(!B1:!K1)
在 Sheet1
=MyName
上放置一个公式.这将求和 Sheet1!B1:K1
Place a formula on Sheet1
=MyName
. This will sum Sheet1!B1:K1
现在将相同的公式 (=MyName
) 放在 Sheet2
上.该公式将求和 Sheet2!B1:K1
Now place the same formula (=MyName
) on Sheet2
. That formula will sum Sheet2!B1:K1
注意:(正如 pnuts 评论的那样)这个和常规的 SheetName!B1:K1
格式是 relative,所以引用不同的单元格作为 =MyName代码> 公式被输入到不同的单元格中.
Note: (as pnuts commented) this and the regular SheetName!B1:K1
format are relative, so reference different cells as the =MyName
formula is entered into different cells.
这篇关于单元格引用前的感叹号是什么意思?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!