Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
161 views
in Technique[技术] by (71.8m points)

excel - Show all tabs with worksheet names (use multiple rows, or alternative, if needed)

I have a workbook with many worksheets. I would like 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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...