Creating Multiple Woorbook tabs on one screen

Occasional Visitor

How can I create multiple workbook(not worksheet) tabs on the top of my spreadsheet? For example the top of the screen would display Month Tabs and when you select a month it opens with the different days as worksheets. I saw one video on youtube, but never explained how they popped up. Thank you!

1 Reply


Excel 2010 and older versions displayed all workbooks in a single application window. It was possible to arrange all open workbooks in different ways.

Excel 2013 and later versions display each workbook in its own application window. There is no built-in feature to display workbook tabs.

It can be done using an add-in, for example Office Tab from ExtendOffice. This is a commercial product, but you can try it out for free for 30 days.