« How do you convert decimals to fractions in simplest form?
In Excel 2003, how do you copy a cell from one worksheet to another? »

How do I make multiple groups of worksheets in an Excel workbook?

I have a load of workbooks, each with a few worksheets in them. I want to put them all together in to one workbook, but keep them in seperate groups (that correspond to their original workbooks). Ideally, I would like it so that there is more than one row of tabs along the bottom. Does anyone know how I might be able to do this?

What you’re looking to do, it can’t be done.

This entry was posted on Sunday, December 27th, 2009 at 8:54 pm and is filed under worksheets. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “How do I make multiple groups of worksheets in an Excel workbook?”

  1. Rab Says:
    December 28th, 2009 at 2:04 am

    Hi Marsbarboy, Here is a great free app that will maybe solve your problem,if not this one then I’m sure it will come in handy in the future. I hope this helps,All the best Rab.

    http://www.asap-utilities.com/download-asap-utilities.php
    References :
    persona experience.

  2. Richard Says:
    December 28th, 2009 at 2:13 am

    You can’t make more than one row of tabs. Your best bet is to color the tabs. This way just color each group of tabs a different color.

    Here is an excel video tutorial that shows you how to do that:

    http://www.youtube.com/watch?v=SBj2kgNDFEg
    References :

  3. Joe Says:
    December 28th, 2009 at 2:44 am

    What you’re looking to do, it can’t be done.
    References :

Leave a Reply