Jumping to a cell by clicking in one

J

Josh

If the content of a cell (say Sheet1, A1) was a formula
that was linked to another cell (say A1 on sheet2), I used
to be able to double click A1, sheet1 and jump to cell A1
Sheet 2. After I changed my laptop, Excel doesn't do that
anymore. Anyone knows what settings I have to reset please?

Thanks.
 
G

Gord Dibben

Josh

Tools>Options>Edit.

Uncheck "Edit directly in cell".

Gord Dibben Excel MVP
 
Top