Can you create a folder in Excel workbook to hold related sheets?

M

Mookie

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

Gary''s Student

You can embed them in a workbook:

Insert > Object... > Create from File > Browse
 
M

Mookie

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

Dave Peterson

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