Excel:使用工作表名称显示所有选项卡(如果需要,请使用多行或替代) [英] Excel: Show all tabs with worksheet names (use multiple rows, or alternative, if needed)
问题描述
我最接近的是右键单击箭头以导航床单(左下角),然后更多有没有什么可以一次性提供更多的可见性?
PS:我只是重新读取的问题,并添加了选项卡。之前看起来很可怕(应得的downvote)。
您可以创建目录工作表。此工作表中的每个单元格将显示选项卡名称,并包含该选项卡的超链接。
您可以手动或使用宏
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).
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
这篇关于Excel:使用工作表名称显示所有选项卡(如果需要,请使用多行或替代)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!