excel 2000, how do i setup sub-sheets
 

i am setting up a database using excel 2000 and have a large number of
worksheets in my workbook. i would like to set up sub-sheets under
worksheets to separate them by subject. how can i do this?

If I understand correctly, you can't...worksheets are not hierarchical

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ME" wrote in message
...
i am setting up a database using excel 2000 and have a large number of
worksheets in my workbook. i would like to set up sub-sheets under
worksheets to separate them by subject. how can i do this?

NO

--
Don Guillett
SalesAid Software

"ME" wrote in message
...
i am setting up a database using excel 2000 and have a large number of
worksheets in my workbook. i would like to set up sub-sheets under
worksheets to separate them by subject. how can i do this?

Hi,

One way to keep the worksheets in your workbook order is to name them
1, 1.1, 1.2, ... 5.1
and perhaps even change the tab-color (right click on the sheet name)

Ola

You cannot have sub-sheets of worksheets.

Gord Dibben Excel MVP

On Fri, 7 Jan 2005 08:31:04 -0800, "ME" wrote:

i am setting up a database using excel 2000 and have a large number of
worksheets in my workbook. i would like to set up sub-sheets under
worksheets to separate them by subject. how can i do this?

Ola

The OP has XL2000 and this doesn't have coloured tabs

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ola" wrote in message
...
Hi,

One way to keep the worksheets in your workbook order is to name them
1, 1.1, 1.2, ... 5.1
and perhaps even change the tab-color (right click on the sheet name)

Ola