In excel, I want to link 2 separate cells, in different worksheets to have exactly the same formatting. I also need the second cell to automatically update if the 1st cell is changed.
在excel中，我要链接两个独立的单元格，它们位于不同的工作表中，以便具有完全相同的格式。如果第一个单元格改变了，我还需要第二个单元格自动更新。
Is this possible?
这是可能的吗?
Many thanks.
多谢。
1 个解决方案
#1
0
Try using =sheetname!Cellref so e.g if you need your cell to be the same as cell g4 in Prices you'd say =Prices!G4
试着用= sheetname !Cellref所以e。如果你需要你的手机和g4一样的价格，你会说=价格
Or, if that doesn't work, open both sheets, type = in the cell that is doing the copying and then flick to the other book and click the cell you wish it to copy =]
或者，如果不行，在进行复制的单元格中打开两个表，type =，然后切换到另一本书并单击要复制的单元格=]
#1
0
Try using =sheetname!Cellref so e.g if you need your cell to be the same as cell g4 in Prices you'd say =Prices!G4
试着用= sheetname !Cellref所以e。如果你需要你的手机和g4一样的价格，你会说=价格
Or, if that doesn't work, open both sheets, type = in the cell that is doing the copying and then flick to the other book and click the cell you wish it to copy =]
或者，如果不行，在进行复制的单元格中打开两个表，type =，然后切换到另一本书并单击要复制的单元格=]