automatic opening linked Excel cell Solved

Question

Hello,

I have an issue with Excel, I'm on a new computer and I can't find an old setting.

On the old one, when I double-clicked on a cell that linked to another sheet or file, I would directly access the cell from which the initial cell was derived, which is handy for quickly navigating through different files.

On the new one, double-clicking only allows me to edit the cell.

I remember there is a setting to change, but I can't find it anywhere.

Can someone help me???

Thanks!

(I'm interested in info for Excel 2003 and 2007)

Configuration: Windows XP Internet Explorer 7.0

pilas31 · Accepted Answer

Hello,

I think in Excel 2003 it's in the Tools/Options menu in the "Editing" tab where you need to uncheck the "Direct editing" box.

In Excel 2007, it's by clicking on the Office button then the Excel Options button.

See you soon
--
Best regards,

hich24 · Answer

you just need to insert a hyperlink in the cell insert menu > hyperlink > choose (another tab, another file, ...)

woutz · Answer

Mmm,

Thanks for the reply, but it doesn't really suit me. If I have to do this for every cell, it's super tedious...

I'm just looking for the option parameter that makes it so that if I double-click on a cell containing a reference to another sheet or another Excel file, the double-click opens the link and also takes me directly to the linked cell (the precedent, you know)

Any other ideas, please?

woutz · Answer

Up !!   Please!!!

nana · Answer

Option / advanced / uncheck "direct cell editing"

Automatic opening linked Excel cell

5 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.