我想在Excel工作表中有一个文本框或标题,它显示此工作表中某个单元格的值。 可能吗?
I want to have a textbox or a caption in an excel worksheet, that displays the value of some cell from this worksheet. Is it possible?
最满意答案
您可以使用文本框控件,正如兰斯建议的那样,但还有其他更好的方法:
如果您创建自动形状文本框(插入 - >图片 - >自选图形),您可以通过选择它将其链接到单个单元格,然后在公式栏中键入(例如)“= A1”。 然后,您可以根据需要对其进行格式化和定位。
这很酷,但不是很酷:如果你复制一系列单元格,然后在选择编辑菜单时按住shift键,你会看到一个选项“粘贴图片链接”。 如果这样做,它会粘贴单元格的图片,这些单元格在单元格值更改时会更新。 正如迈克尔凯恩从未说过的那样,“并不是很多人都知道这一点”。
注意:我在这里谈论的是Excel 2003.我认为它仍然适用于2007年,尽管各种命令的位置等都会发生变化。
You can use a textbox control as Lance suggests, but there are other, perhaps better ways:
If you create an autoshape textbox (Insert->Picture->AutoShapes) you can link it to a single cell by selecting it, then type (for example) "=A1" into the formula bar. You can then format and position it as you like.
That's pretty cool, but not as cool as this: if you copy a range of cells, and then hold down the shift key as you choose the Edit menu, you'll see an option "Paste picture link". If you do this, it pastes a picture of the cells which gets updated when the cell values change. As Michael Caine never said, "not a lot of people know that".
Note: I'm talking here about Excel 2003. I assume it still works in 2007, though the location of the various commands, etc. will have changed.
更多推荐
发布评论