Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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,203 ✭✭✭✭

Join Date: September 2007

Posts: 14920

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,522 ✭✭✭

Join Date: April 2003

Posts: 9352

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