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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,680
Messages
6,103,250
Members
447,850
Latest member
thebuzzman15

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
Back
Top