如何在工作表中创建链接文本框？(How to create Linked textbox in worksheet?)

如何在工作表中创建链接文本框？(How to create Linked textbox in worksheet?)

我想在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.