excel显示所有工作表
It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I'm making a big file for a client, I'll often colour groups of sheet tabs, to they're easier to find. Then, if you want the admin lists sheets, look for the red group.
如果Excel文件中包含大量工作表,那么找到特定工作表可能会非常痛苦。 如果我要为客户制作一个大文件,我通常会为工作表标签组添加颜色,以使它们更容易找到。 然后,如果您希望管理员列出工作表,请查找红色组。
补鞋匠综合症 (Cobbler's Syndrome)
For my own workbooks, I usually don't bother, and then end up wasting time, scrolling back and forth, looking for the sheet that I need. It's like the old saying – "The shoemaker's children go barefoot." Apparently I'm not the only one who does stuff like that – it's called Cobbler's Child Syndrome! Are you guilty too?
对于我自己的工作簿,我通常不打扰,然后浪费时间,来回滚动,寻找我需要的工作表。 就像古老的谚语所说:“鞋匠的孩子赤脚走路。” 显然,我不是唯一一个做过这样的事情的人–它被称为补鞋匠儿童综合症 ! 你也有罪吗?
Apparently AlexJ doesn't suffer from that syndrome, because he sent me a worksheet navigation tip this week, and he uses it in his own files. In addition to creating coloured tab groups, AlexJ puts spacer tabs between the groups, to add some visual separation.
显然,AlexJ并没有患上这种综合征,因为他本周向我发送了一个工作表导航提示,并在自己的文件中使用了该提示。 除了创建彩色标签组之外,AlexJ还在组之间放置间隔标签,以增加视觉效果。
垫片选项卡的好处和提示 (Spacer Tab Benefits and Tips)
I played with this idea in one of my Excel sample files, and additional benefits. For example, it adds spaces in the sheet list that appears when you right-click the Navigation Arrows.
我在一个Excel示例文件中使用了这个想法,并获得了其他好处。 例如,在右键单击“导航箭头”时出现的工作表列表中添加空格。
Don't use too many spacer tabs though, because each one will be a little wider than the previous one, due to creating unique names with space characters.
不过,不要使用太多的分隔符制表符,因为每个制表符都会比前一个制表符宽一些,这是因为创建了带有空格字符的唯一名称。
你会尝试吗? (Will You Try This?)
To see the details on how AlexJ creates his spacer tabs, and a few additional tips, check out the Excel Worksheet Tips page on my Contextures website.
要查看有关AlexJ如何创建其分隔符选项卡的详细信息以及一些其他提示, 请查看 Contextures网站上的Excel Worksheet Tips页面 。
What do you think about AlexJ's tip?
您如何看待AlexJ的小费?
- Have you tried something similar in your big Excel files? 您是否在大型Excel文件中尝试过类似的操作?
- If not, does this technique look like something you'd be willing to try? 如果没有,这种技术看起来像您愿意尝试的东西吗?
视频:Excel导航提示 (Video: Excel Navigation Tips)
This video shows AlexJ's spacer tabs, and a few other tips to make it easier to find a specific sheet in a large workbook.
该视频显示了AlexJ的间隔标签和其他一些技巧,这些技巧使您可以轻松地在大型工作簿中查找特定的工作表。
The sample file that I used in this video is this one: Select Multiple Items from Data Validation Drop Down
我在此视频中使用的示例文件是以下文件: 从数据验证中选择多个项目
翻译自: https://contexturesblog.com/archives/2015/08/27/excel-worksheet-navigation-tips/
excel显示所有工作表