Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default can you group worksheets together and create a chapter?

I'm trying to group a bunch of worksheets into a chapter. Right now I have
over 30 worksheets and need them all in the same workbook. Was hopeing to
find a way to put worksheets into one tab (Chapter) to make it easier to
navigate. Like a book. Pages in a chapter, and chapters in the book.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default can you group worksheets together and create a chapter?

Nope.

But you could prefix each worksheet name nicely:
01_Part_01
01_Part_02
....
10_Part_01
10_Part_02
....

If you're using xl2002+ (I think), you can change the colors of the tabs, too.


Daryl Rosenberg wrote:

I'm trying to group a bunch of worksheets into a chapter. Right now I have
over 30 worksheets and need them all in the same workbook. Was hopeing to
find a way to put worksheets into one tab (Chapter) to make it easier to
navigate. Like a book. Pages in a chapter, and chapters in the book.


--

Dave Peterson
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
I wish to group my worksheets under group tabs CSI Excel Worksheet Functions 5 October 19th 06 09:25 PM
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee jaking Excel Worksheet Functions 2 August 30th 05 02:09 PM
Cannot Group Seven Worksheets, only Six Josma Excel Discussion (Misc queries) 3 May 14th 05 02:29 AM
Chapter numbers hogon Excel Discussion (Misc queries) 1 April 19th 05 07:20 PM
Is it possible to create a macro to group? Mike Piazza Excel Discussion (Misc queries) 1 January 8th 05 12:23 AM


All times are GMT +1. The time now is 03:48 AM.

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

About Us

"It's about Microsoft Excel"