| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you create a folder in Excel workbook to hold related sheets?
Is there a way to create a folder or other container in an Excel workbook to
store related sheets. For example, I have quite a few sheets and would like to group them into a few folders that I could select and then have the grouped sheets available. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you create a folder in Excel workbook to hold related sheets?
You can embed them in a workbook:
Insert Object... Create from File Browse -- Gary''s Student - gsnu200803 "Mookie" wrote: Is there a way to create a folder or other container in an Excel workbook to store related sheets. For example, I have quite a few sheets and would like to group them into a few folders that I could select and then have the grouped sheets available. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you create a folder in Excel workbook to hold related shee
I'm not trying read a folder that contains files. What I'd like to do is
group certain sheets together in an Excel book. For example, I'd like to put Sheet1 and Sheet2 in a folder so that the tabs show "Folder1" and Sheet3 and when I select Folder1, only Sheet1 and Sheet2 show up in the sheet tabs. "Gary''s Student" wrote: You can embed them in a workbook: Insert Object... Create from File Browse -- Gary''s Student - gsnu200803 "Mookie" wrote: Is there a way to create a folder or other container in an Excel workbook to store related sheets. For example, I have quite a few sheets and would like to group them into a few folders that I could select and then have the grouped sheets available. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you create a folder in Excel workbook to hold related shee
Nope. Excel doesn't allow this kind of thing.
About the closest thing you can do is to give all similar worksheets the same prefix in their names. And if you're using xl2002+, you could change the colors of the tabs. Mookie wrote: I'm not trying read a folder that contains files. What I'd like to do is group certain sheets together in an Excel book. For example, I'd like to put Sheet1 and Sheet2 in a folder so that the tabs show "Folder1" and Sheet3 and when I select Folder1, only Sheet1 and Sheet2 show up in the sheet tabs. "Gary''s Student" wrote: You can embed them in a workbook: Insert Object... Create from File Browse -- Gary''s Student - gsnu200803 "Mookie" wrote: Is there a way to create a folder or other container in an Excel workbook to store related sheets. For example, I have quite a few sheets and would like to group them into a few folders that I could select and then have the grouped sheets available. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create & delete sheets in a shared Excel workbook? | Excel Worksheet Functions | |||
| Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
| Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to create workbook with multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
