在Excel中检索单元格名称 [英] Retrieving Cell name in Excel
问题描述
有没有办法在另一个单元格中显示特定单元格的单元格名称?我想在相邻单元格中显示单元格名称,以便用户能够识别单元格名称而不点击它。
Is there a way of displaying the Cell name of a particular cell in another cell? I would like to display the cell name in the adjacent cell so that the user is able to identify the cell name without clicking it.
谢谢...
推荐答案
ADDRESS(ROW(),COLUMN())
将给你地址,例如$ A $ 1当前单元格。从行/列值(数字)中添加/减去引用您以后的单元格。
ADDRESS(ROW(),COLUMN())
will give you the address, e.g. $A$1 of the current cell. Add/subtract from the row/column values (numbers) to reference the cell you are after.
如果您不想要$,那么您可以找到并替换它使用 SUBSTITUTE(ADDRESS(ROW(),COLUMN()),$,)
,只得到A1,例如
If you don't want the $ then you can find and replace it with SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$","")
and get just A1 for example
这篇关于在Excel中检索单元格名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!