Create tab hyperlinks between sheets on Excel

Question

I'm trying to insert tabs like the ones in the screenshot below. I downloaded a template with them on but cannot seem to recreate them! 

As you can see, these are like tabs on google chrome which take you from sheet 1 to sheet 2 etc via hyperlink. Except I don't know how to create them as they seem to work so effectively just like as if you were on google chrome. 

Please help!

***Subject edited for clarity by the moderator.***

Answer 1

Hello,

the "tabs" in your screenshots look like graphics inserted into the sheet. They are not really tabs at all, but images that look like tabs with text boxes that link to another sheet. 

You can create this in Excel, too. If you want to go down the "tab" look and feel, you will need to find appropriate graphic files. Insert them into the sheet, then place a rectangular shape with the desired "tab" text on top. Select the shape and insert a link that links to another sheet in the same workbook.

On that other sheet, you will need a similar setup, just with another "tab" graphic that has the correct "tab" in the foreground. This clever setup requires a bit of work.

If you want to make do without the "tab" look and feel, you can enter the words directly into Excel cells and insert a hyperlink to another sheet. Or use shapes with text, because these are independent of cell widths.

Answer 2

Hi,

Excel provides several options of creating hyperlinks in another file or another web page. For us to provide you with the accurate steps in recreating the tab hyperlinks between sheets, may we know which Excel version are you using?

We will be waiting for your reply so we can move forward to resolving your concern.