
- UID
- 223373
- 帖子
- 243
- 主题
- 55
- 注册时间
- 2011-7-11
- 最后登录
- 2014-8-4
|
I would like another tip for cells that are linked to input cells:
1) I disable the direct editing of cells and edit them with F2. So when a cell is linked with another one I double click it and land on the input. What is the keybord equivalent of that double click ?
2) If you want to check a long formula which is linked to other cells in different sheets, what is the best way to doing this if you want to avoid the retarded following things (which I do):
- copy the formula in word
- memorise it
- always go back to the original formula during your check because you failed to memorise it
There has to be some function which brings the formula in a little window or something and even highlights the input cells, as you switch sheets ?
Txs alot in advance, it would really save me some time. |
|