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...
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
