excel 2000, how do i setup sub-sheets

M

ME

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?
 
N

Nick Hodge

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
O

Ola

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
 
N

Nick Hodge

Ola

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
VBA for Dependents shortcut menu 0
Merging from an Excel file with graphics 1
Section and Page numbering 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Embed the same Excel multiple times 0
Excel does not accept text format! 0
VBA word change keys 0

Top