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 active on the main spreadsheet. In a way I need a folder in a folder. I still need to be able to see these sheets so in a way if I click on the folder tab it will open the sheets. I’m not looking at combining the sheets into one sheet, or hide the sheets from view. Is this something that is even possible?
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.
NikolinoDE Would you please explain how to create the folder in the desktop Microsoft excel? I can't figure it out. Thank you.
- laylas NikolinoDE I hope Excel for the web will consider implementing the functionality as it will serve as a significant assistance in organizing data for those of us who use it on a daily basis.
If your goal is to work on two sheets without affecting the other sheets, that might be linked, save a copy of the file. Keep both files open. On the copy, delete the sheets that are not needed. Now you can work on the two sheets and still have the other one for viewing.
If you are looking for an Excel App that can easily hide and unhide sheets so you can focus on the two, try the Excel Sheet Organizer at www.excelsweetspot.com.
See if any of these work.
