Forum Discussion
Excel sheets into a folder
I’m trying to get this done but can’t seem to fix it myself. I have one spreadsheet with 20 active sheets on it, I need to create a folder/workbook that will hold 18 of these sheets and leave 2 activ...
Excel for the web does not support the creation of folders or sub-workbooks within a single workbook, so far I know. The feature you are looking for, which is the ability to group sheets into sub-workbooks or folders for organizational purposes, is not available in Excel for the web.
In Excel, grouping sheets into sub-workbooks or folders is a feature that is typically available in the desktop version of Excel, and it allows you to create a hierarchy for better organization. However, this feature is not available in Excel for the web, which is a web-based, simplified version of Excel designed primarily for basic spreadsheet editing and collaboration.
If you require this specific functionality, you would need to use the desktop version of Excel to create sub-workbooks or folders within your Excel workbook. Once you have created these sub-workbooks, you can use Excel for the web for basic viewing and editing, but the organizational structure will be maintained in the desktop version.
Keep in mind that Microsoft regularly updates its Office 365 suite, including Excel for the web, so it is possible that new features may have been added since my last update. I recommend checking the most recent version of Excel for the web to see if this feature has been introduced. The text were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
ive opened the sheet on desktop but can’t seem to find how to create subfolders NikolinoDE
Unfortunately, as far as I could find out on the internet, Excel does not support actual folders or sub-workbooks. Neither the desktop nor the web version knows the concept of "folders" or "sub-folders" within a workbook for organizing sheets. I must apologize for my misunderstanding here.
The only thing I could offer without having tried it would be creating hyperlinks to simulate folder-like behavior. You could maybe create a "master sheet" with hyperlinks that simulate folder-like behavior:
- Create the master sheet: Add a new sheet at the top of your workbook and name it something like "Contents" or "Navigation."
- List your sheets: In the master sheet, list the names of the 18 sheets you want to organize.
- Add hyperlinks: Right-click a cell with a sheet name, select "Link," select "Place in this document," and select the appropriate sheet. Repeat this for each sheet.
- Easy navigation: If you now click on the links in the main sheet, you will be taken directly to the corresponding sheet, which is similar to a "folder system".
I don't know if this was of any help to you, but I'm at my wits' end here.
Thank you for your patience and understanding.
- thank you
- Did you figure it out?
