linked cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Penka - 23 Sep 2006 18:12 GMT

Hi,

On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and
Paste Link). With about 20 sheets in a workbook, it gets difficult to go
between Sheet1 and the rest of the sheets.
Is there a way, e.g. double click on a linked cell on Sheet1 to activate the
sheet (Sheet2, Sheet3 ...) with the source cell on it?

Thanks,

Reply to this Message

Tom Ogilvy - 23 Sep 2006 18:36 GMT

If you go to Tools=>Options=>Edit tab and uncheck "Edit Directly in Cell",
then you can double click on it an be taken to the link.

Signature

Regards,
Tom Ogilvy

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks,

Reply to this Message