Hyper Link?

Okay I have a spreadsheet that has multiple tabs for multiple different companies. Each company tab has a T-chart on the tab with notes about that company. Eventually this spreadsheet will have well over 100+ names in it and I wanted to create a summary tab with all of the names listed and have it so that you can click on one of the names and it take you directly to that companies tab within the spreadsheet. Any help would be much appreciated.

Cheers

Hi Exce15

Click on the cell you require the text to be a hyperlink then right click - down then to hyperlink which should open up then select "Place in this document" you then get a list of your tabs so select accordingly and click OK.

Right click on the name that you want to create a Hyperlink from on Sheet named Tab Links. Click Hyperlink. Choose the option on the left that says " Place in this Document". Choose the tab you want it to go to. You can also choose which cell as well. You then can create an additional Hyperlink that will take you back to the Tab Links page and the Cell you clicked from. Hope this makes sense.