Excel 2007 [英] Excel 2007
问题描述
您好:
如何让两个单元格具有相同的值?因此,当我编辑一个单元格时,它会更改另一个单元格,反之亦然。
How do I make two cells to have the same value? So when I edit one cell it would change the other cell and vice versa.
谢谢
推荐答案
首先我要告诉你这个论坛涵盖了Small Basic( http://smallbasic.com )。在Microsoft Answers上更好地询问您的办公室问题:
http://answers.microsoft.com/en-us (有办公区!)
first I have to tell you that this forum covers Small Basic (http://smallbasic.com). Your office questions are better asked on Microsoft Answers: http://answers.microsoft.com/en-us (There is an office area!)
我知道的一个解决方案是:
One solution that I know of is:
你可以在单元格中输入一个=然后使用光标键移动到要在其他值内查看的值的单元格。一旦进入正确的单元格,只需按Enter键。
You could simply type a = in the cell and then use the cursor keys to move to the cell which value you want to see inside the other value. Once on the correct cell, just press enter.
单元格的内容将类似于"= A1"。 (没有引号)。
The content of the cell will be something like "=A1" (Without the quote signs).
但是这样只将一个单元格的内容放入另一个单元格中。当您在第二个单元格内键入时,公式将被覆盖:(
But that way only the content of one cell will be placed into the other cell. When you type inside the 2nd cell, the formula will be overriden :(
但我很确定Microsoft Answers中的Office专家会知道更好的解决方案,如果它存在。
But I am quite sure that the Office Experts in Microsoft Answers will know a better solution if it exists.
致以亲切的问候,
Konrad
这篇关于Excel 2007的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!