How to Create Workbook Tabs

Question

Hi,

I have a workbook with a lot of tabs all relating to a specific month. I didn't want to continue making tabs in the same workbook for different months unless there was a way to consolidate, by either having sub or super tabs containing everything related to that month's worth of information and graphs. I know I can or should have multiple workbooks, but there isn't really a good way to easily move from one to the next if you are trying to look at a whole years worth of information. I looked around on the web for a way to do sub or super tabs for excel 2016 and haven't been able to find anything except this picture of an older version of Excel that allowed Workbooks to be tabs, having quick access to each Workbook and its sheet tabs. Does Excel 2016 have this ability?

Thanks,

Answer 1

Hello,

Please be informed that the feature in the screenshot you have provided was present in older version of Excel application.  Excel 2013 onwards Single Document Interface (SDI) was introduced. SDI is a method of organizing graphical user interface (UI) applications into individual windows that the operating system window manager handles separately. From Excel 2013, each Excel window can contain only one workbook, and each has its own ribbon UI. By default when you open a new workbook, it will be displayed in another Excel window, even though it is the same Excel instance.

Multiple Document Interface feature was available up to Excel 2010, in which a single parent window is used to contain multiple nested child windows, with only the parent window having a menu or tool bar. Until Excel 2010, each workbook in a single instance of Excel utilizes a common ribbon UI.

I hope the above information helps. Let us know if you need further assistance.

Thank you.