Cell linkage ...
I have a problem about excel , hopefully you can help !
Normally , if one cell involved link with another cell , when i double-click this cell ,it will jump to the related linked cell (i.e. set formula "=A2" into A1 cell, if i double-click A1 cell, it will automatic jump to A2), however, my excel loss this function, would you please advised some method or setting to let it enable. |
Cell linkage ...
Hi,
Try entering =A2 into cell A1 and double click. Note I've removed the quotes. Mike "Venus" wrote: I have a problem about excel , hopefully you can help ! Normally , if one cell involved link with another cell , when i double-click this cell ,it will jump to the related linked cell (i.e. set formula "=A2" into A1 cell, if i double-click A1 cell, it will automatic jump to A2), however, my excel loss this function, would you please advised some method or setting to let it enable. |
Cell linkage ...
ToolsOptionsEdit.
Uncheck "edit directly in cell" Gord Dibben MS Excel MVP On Wed, 17 Sep 2008 03:03:03 -0700, Venus wrote: I have a problem about excel , hopefully you can help ! Normally , if one cell involved link with another cell , when i double-click this cell ,it will jump to the related linked cell (i.e. set formula "=A2" into A1 cell, if i double-click A1 cell, it will automatic jump to A2), however, my excel loss this function, would you please advised some method or setting to let it enable. |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com