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.

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.

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.

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