Excel does not support grouping of sheets, or a hierarchy of sheets.
You might vote for one of the requests found here: group sheets on the Excel Feedback Portal.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello!
I am using MS Excel for Mac (v16.78) on a MacBook Pro M2 Max running OS Ventura 13.5.2.
I have an Excel workbook containing several spreadsheets (tabs across the bottom of the application) for our household weekly budget. A main spreadsheet lists the entire month's bills with payees/due dates/amounts/account numbers, etc. Then, the other sheets contain one week of each month of the year from the main worksheet. There are so many now that I must scroll using the arrow buttons to move through them. Please see the screenshot attached.
I would like to know if there is a way to create something like a folder structure where I could drop the four or five week's worth of spreadsheets into and label it by the Month/Year - for example:
Spreadsheet #1: September 1-7 2023
Spreadsheet #2: September 8-14 2023
Spreadsheet #3: September 15-21 2023
Spreadsheet #4: September 22-28 2023
Ideally, I would like to place these four spreadsheets into a created "container" on the strip at the bottom where the spreadsheet tabs are and be able to label the container by the month and year. I do not want to group them because if I make a change on one spreadsheet, I don't want the change to propagate to the others.
Does this exist? If so, how is it done? If not, Microsoft, why not?
Thank you.
Here is a screenshot of what I am working with and what I would like to accomplish:
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Excel does not support grouping of sheets, or a hierarchy of sheets.
You might vote for one of the requests found here: group sheets on the Excel Feedback Portal.