Excel for Mac - Ability to create folder/group of spreadsheets within a single workbook?

Anonymous
2023-09-20T17:48:56+00:00

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:

Microsoft 365 and Office | Excel | Other | MacOS

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.

0 comments No comments
{count} votes
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-09-20T18:40:21+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful