Excel: Show all tabs with worksheet names (use mul

Question

I have a workbook with quite a few worksheets. I would like to be able to see the tabs for all available worksheets at once, which will need more than one row of tabs at the bottom. From what I searched, this is not possible.

The closest I got is right clicking on the arrows for navigating the sheets (at the bottom left), and then "More Sheets..."

Is there anything that gives more visibility at once?

PS: I just reread the question, and added "the tabs for". It looked horrible before! (well deserved downvote).

Answer 1

You can create a Table of Contents worksheet. Each cell in this sheet would display a tab name and contain a hyperlink to that tab.

You can do this manually or with a macro