If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel - Link Cell in 'Master Sheet' to 'Sheet B' etc

callaway92 · 2019-07-10 09:15:55

Hi folks For the below - How do I go about (if it is possible) linking a cell to a sheet. Example below - I want to double-click the Client name (Column A) and make it bring me to their sheet. I'm already after turning off the 'Double-Click to edit' thing in Options. Thank you

10-07-2019 10:15AM

#1

callaway92

Registered Users, Registered Users 2 Posts: 15,100 ✭✭✭✭

Join Date: September 2007

Posts: 14817

Hi folks

For the below - How do I go about (if it is possible) linking a cell to a sheet.

Example below - I want to double-click the Client name (Column A) and make it bring me to their sheet.

I'm already after turning off the 'Double-Click to edit' thing in Options.

Thank you

0

Comments

#2 10-07-2019 10:17AM

runawaybishop

Registered Users, Registered Users 2 Posts: 9,523 ✭✭✭

Join Date: April 2003

Posts: 9353

callaway92 wrote: »

Hi folks

For the below - How do I go about (if it is possible) linking a cell to a sheet.

Example below - I want to double-click the Client name (Column A) and make it bring me to their sheet.

I'm already after turning off the 'Double-Click to edit' thing in Options.

Thank you

Right-click the cell, choose hyperlink, choose place in this document.

0