ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can you group worksheets together and create a chapter? (https://www.excelbanter.com/excel-worksheet-functions/183311-can-you-group-worksheets-together-create-chapter.html)

Daryl Rosenberg

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.

Dave Peterson

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


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com