返回列表 发帖
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.

TOP

返回列表