![]() Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line.Īutomatic Worksheet/Tabs List In Excel 10 March 2019Īn automatically updated list of all worksheets or tabs in Excel but there are ‘gotchas’ which aren’t often mentioned. Make Excel tabs list in a worksheet 8 March 2019 Got a workbook with a lot of worksheets in it? Here are some handy ways to jump to the worksheet you want, alphabetically. ![]() There are actually a couple of ways to do this, and a couple of ways for it to look. If by "separate items" you mean 50 tabs, there is a way to create a "hyperlinked TOC" (Table of Contents) that will jump you to the desired tab.
0 Comments
Leave a Reply. |