#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default New Worksheet

Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default New Worksheet

Not really.

You could embed another workbook into a worksheet (insert|Object|from file).
But that's pretty unusual (in my experience).

Maybe just naming the worksheets would be sufficient:

Main
Main--Sub 01
Main--Sub 02
Main--Sub 03
....



Loni wrote:

Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default New Worksheet

With a system of macros, and menus, you can simulate what you want by hiding
and unhiding groups of sheets .............but it would be a custom thing set
up just for that workbook with your specific sheetnames.............hth
Vaya con Dios,
Chuck, CABGx3



"Loni" wrote:

Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default New Worksheet

In later versions of Excel it is possible to color tabs. By coloring tabs it
would be easy to see what tabs belong to other taps.

"Loni" wrote:

Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search one worksheet for values in another worksheet? ClayShooters Excel Discussion (Misc queries) 1 July 4th 06 03:01 PM
Worksheet not showing up in VBE Kevin Vaughn Excel Worksheet Functions 3 June 12th 06 03:22 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"