Jumping to a cell by clicking in one

  • Thread starter Thread starter Josh
  • Start date Start date
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.
 
Josh

Tools>Options>Edit.

Uncheck "Edit directly in cell".

Gord Dibben Excel MVP
 
Thank you much

Josh

-----Original Message-----
Maybe:

tools|options|edit tab
uncheck "edit directly in cell"


--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink via indirect cell reference 8
SUMIF function and cell /sheet reference 3
Code to format cells on several worksheets 2
How do I double click a cell and jump to cell's referenced cell 2
A formula that autofills by trend rather than linear 1
alter code to apply to range (links cells w/ row insertions) 1
jump to cell in sheet2 when values in sheet1 is true 3
Cell linkage ... 2

Back
Top