blocks|key|1365562|text|A2已经是相对引用，当您移动单元格或复制公式时，它将更改。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1365563|entityMap^0|0|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

<code>A2</code> is already a relative reference and will change when you move the cell or copy the formula.

blocks|key|1580709|text|你可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1580710|=CELL("width",+INDIRECT(ADDRESS(ROW(),+COLUMN())))|code-block|syntax|javascript|1580711|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could use

<pre><code>=CELL("width", INDIRECT(ADDRESS(ROW(), COLUMN())))
</code></pre>

blocks|key|1365645|text|在表格中，您可以使用[@]，它(不幸的是)会自动扩展为Table1[@]，但它确实可以工作。(我正在使用Excel+2010)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1365646|例如，当有两列[Change]和[Balance]时，将以下内容放在[Balance]列中：|1365647|=OFFSET([@],+-1,+0)+%2B+[Change]|code-block|syntax|javascript|1365648|当然请注意，这取决于行的顺序(就像大多数其他解决方案一样)，所以它有点脆弱。|1365649|entityMap^0|A|3|R|9|0|7|8|G|9|Y|9|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|P|$]]

Inside tables you can use <code>[@]</code> which (unfortunately) Excel automatically expands to <code>Table1[@]</code> but it does work. (I'm using Excel 2010)

For example when having two columns <code>[Change]</code> and <code>[Balance]</code>, putting this in the <code>[Balance]</code> column:

<pre><code>=OFFSET([@], -1, 0) + [Change]
</code></pre>

Note of course that this depends on the order of the rows (just like most any other solution), so it's a bit fragile.

blocks|key|1580829|text|我发现处理这个问题的最好方法(对我来说)是使用以下方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1580830|Dim+MyString+as+String
MyString+=+Application.ThisCell.Address
Range(MyString).Select|code-block|syntax|javascript|1580831|希望这能有所帮助。|1580832|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I found the best way to handle this (for me) is to use the following:

<pre><code>Dim MyString as String
MyString = Application.ThisCell.Address
Range(MyString).Select
</code></pre>

Hope this helps.

blocks|key|1365683|text|=ADDRESS(ROW(),COLUMN())
=ADDRESS(ROW(),COLUMN(),1)
=ADDRESS(ROW(),COLUMN(),2)
=ADDRESS(ROW(),COLUMN(),3)
=ADDRESS(ROW(),COLUMN(),4)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1365684|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>=ADDRESS(ROW(),COLUMN())
=ADDRESS(ROW(),COLUMN(),1)
=ADDRESS(ROW(),COLUMN(),2)
=ADDRESS(ROW(),COLUMN(),3)
=ADDRESS(ROW(),COLUMN(),4)
</code></pre>

blocks|key|1365751|text|有一种更好的方法，它更安全，也不会减慢你的应用程序。如何设置Excel，单元格可以有值，也可以有公式；公式不能引用它自己的单元格。您将以无限循环结束，因为新值将导致另一次计算...。使用帮助器列根据您在其他单元格中输入的内容来计算值。例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1365752|A列是真或假，B列包含货币值，C列包含以下公式：=B1|1365753|现在，为了计算列B将以条件格式突出显示为黄色，只有当列A为True且列B大于0时...|1365754|=AND(A1=True，C1>0)|1365755|然后，您可以选择隐藏C列|1365756|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

There is a better way that is safer and will not slow down your application. How Excel is set up, a cell can have either a value or a formula; the formula can not refer to its own cell. You end up with an infinite loop, since the new value would cause another calculation... . Use a helper column to calculate the value based on what you put in the other cell. For Example:

Column A is a True or False, Column B contains a monetary value, Column C contains the folowing formula: 
=B1

Now, to calculate that column B will be highlighted yellow in a conditional format only if Column A is True and Column B is greater than Zero...

=AND(A1=True,C1>0)

You can then choose to hide column C

blocks|key|1365853|text|不使用INDIRECT()：=CELL("width",+OFFSET($A$1,ROW()-1,COLUMN()-1)+)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1365854|entityMap^0|E|1C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Without INDIRECT(): <code>=CELL("width", OFFSET($A$1,ROW()-1,COLUMN()-1) )</code>

How do I obtain a reference to the current cell?

For example, if I want to display the width of column A, I could use the following:

<pre><code>=CELL("width", A2)
</code></pre>

However, I want the formula to be something like this:

<pre><code>=CELL("width", THIS_CELL)
</code></pre>

Excel Reference To Current Cell

如何获取对当前单元格的引用？例如，如果我想要显示列A的宽度，我可以使用以下命令：=CELL("width", A2)但是，我希望公式是这样的：=CELL("width", THIS_CELL)

问Excel对当前单元的引用
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel对当前单元的引用EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel对当前单元的引用
EN