This is a discussion on How to keep a mirror image of a cell in another cell within the Excel Questions forums, part of the Question Forums category; Hi, I want to know if it is possible to keep a mirror copy of one cell in another cell. ...
I want to know if it is possible to keep a mirror copy of one cell in another cell. Assume I have cell A1, and I want a exact copy of it in cell A2 (font, color, etc.), and everytime I change anything in cell A1, it should refresh the contents, fonts etc. in cell A2.
Any assistance will be appreciated. Thanks.
see if the camera does what you want:
right click on a tool bar, go to customise. select the 'commands' tab & select 'tools' - scrol down & find the camera option. drag it to a menu bar. then select a cell, click the camera icon & select a destination for the 'picture' of the cell...change the formatting etc on the source cell to see what you get.