Links from sheet 1 to other sheets

andrewca

New Member
Joined
Nov 30, 2005
Messages
2
I have a workbook set up with multiple sheets which link to 'sheet 1', which is my 'cover sheet'

Can I install a 'button' or 'reference' point in sheet 1 that will take me straight to the specific sheet without having to scroll manually and open it??

Cheers

Andrew
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Andrew

Some options:
1) have a hyperlink
2) Formula reference to the child sheet then double click the cell.
3) Button (or some other control / icon) that can be coded to take you to a specific sheet / cell.


HTH

Tony
 

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395
Hyperlinks are a great way to go. Here is a trick you may not know though. To the left of your sheet tabs you will see four small arrows. Try right clicking on them. Neat huh! Great if you have a large amount of sheets in a workbook.
 

andrewca

New Member
Joined
Nov 30, 2005
Messages
2
Thanks folks. Didn't know about the right mouse click so that will do the trick for me. Have not tried using hyperlinks so may experiment with that for future problems. Any tips on hyperlinks welcomed.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,835
Messages
5,855,910
Members
431,772
Latest member
dannyboi1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top