How to: Select a number of worksheets and export each as a single workbook

I just received the following question from Azad from Australia:

Hi, Is it possible to select a number of worksheets and export as a single workbook?

As you probably already know, Excel itself doesn't have a option for this. It can be a time consuming job to save each worksheet as a separate workbook.

Fortunately it is very easy to do with the following tool from ASAP Utilities:
Export » Export worksheets as separate files...

Save worksheets as separate workbooks

3 Responses to “How to: Select a number of worksheets and export each as a single workbook”

  1. […] addition to my post for yesterday that demonstrated how to save worksheets as separate workbooks, this article will show how how to save several worksheets together in a single new […]

  2. I love the asap utilites program!

    Is there are way to encrypt the new workbook files that you are creating with the export worksheets as separate workbooks function without going into each new file?


  3. Hello Jennifer,

    Thank you for your feedback and compliment.

    Do you mean to protect the new workbooks with a password?
    At this moment that is not possible via this tool. Might be a good addition though.
    Would you use that often?

    Kind regards,
    Bastien Mensink