Managing multiple worksheets

[dad4peanuts]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I regularly create files with 50+ worksheets with interlinked references - mostly historical and projected financial statements. Is there anyway possible to group files in a folder in the tab bar at the bottom of the sheet for ease of navigation? For example, can I group together all worksheets for 2009, 2010 etc in separate folders that can be expanded or contracted for ease of navigation?

Thank you

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
I regularly create files with 50+ worksheets with interlinked references
- mostly historical and projected financial statements. Is there anyway
possible to group files in a folder in the tab bar at the bottom of the
sheet for ease of navigation? For example, can I group together all
worksheets for 2009, 2010 etc in separate folders that can be expanded
or contracted for ease of navigation?

Thank you

No, You can't put sheet tabs in a folder. But you can create an index
sheet with hyperlinks to the individual sheets.

 

[John McGhie]

In addition to Bob's suggestion, about now is a good time to be asking
yourself whether you would be better off to put this data into FileMaker
Pro?

There comes a time when managing very complex relationships in Excel becomes
vexatious to the spirit

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I
regularly create files with 50+ worksheets with interlinked references -
mostly historical and projected financial statements. Is there anyway possible
to group files in a folder in the tab bar at the bottom of the sheet for ease
of navigation? For example, can I group together all worksheets for 2009, 2010
etc in separate folders that can be expanded or contracted for ease of
navigation?

Thank you

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]