ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Sheets » Insert multiple sheets (uses the cell values as sheet names)...

This utility quickly adds new worksheets based on the information in your selected datarange.
For each cell in your selection a new worksheet will be created and the cell content will be used for the name of the new worksheet.
You can specify to use a certain worksheet as a source/template sheet. This way you can for example easily create 52 copies of that worksheet.
If you use Excel version XP/2002 or newer then you can also specify to use the cell color for the sheet-tab color of the new worksheets.

Usage:
1. Select a range of cells that contain the names for the new sheets. (You can use the "Quick numbering of selected cells" utility from ASAP Utilities, or Excel's built in fill tools to help you quickly create a list of names).
2. Start this utility, set the options and a sheet will be created for each and based on each cell in your selection.

Screenshots

Sheets » Insert multiple sheets (uses the cell values as sheet names)...

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

Tip: Quickly insert multiple sheets at once

Starting this utility

In the Excel menu choose: ASAP Utilities » Sheets » Insert multiple sheets (uses the cell values as sheet names)...

« Return to the list of “Sheets” tools.

« Previous
Add new worksheet (fill in a name)...

Next »
Rename current sheet...

Excel 2010 with ASAP Utilities in the menu

Download ASAP Utilities

Additional keywords for this tool:
Tabs, Sheetname, building worksheets from a list, automatically generate new sheets, copy one worksheet to many

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: