单元格引用之前的感叹号是什么意思? [英] 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.

例如，创建引用=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格式是相对，因此当=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屋！