Tip: Quickly insert multiple sheets at once

Save 5 minutes a day by using ASAP Utilities to quickly create or copy worksheets.

"Easily insert many worksheets or worksheet-copies"

The standard method to create a series of worksheets with custom names is to add them and then rename them one by one. This can be a time-consuming task.

If you already have a list of the names for the worksheets then you can use this list to quickly have all the worksheets created and named properly in one go.
Or just type the list of names in the cells (which is faster than renaming the sheets tabs) and then have the sheets automatically inserted and named at once.

You can quickly create or copy worksheets with the following tool:
ASAP Utilities » Sheets » Insert multiple sheets (uses the cell values as sheet names)...

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

We've originally developed this utility when we needed to create workbooks to log working hours and have a worksheet for every week.
One template with the proper information, formatting and page setup was created and then it was copied 52 times.

Do you recognize any of these situations?

  • Is it possible to insert 100 new worksheets in one go or do I have to click on 'insert','worksheet' 100 times?
  • We have to insert 30 worksheets that each have a different name into an existing Excel Workbook - is there a quick way of doing this?
  • I have an excel worksheet, which I want to make 42 copies of, and rename each copy with the initials of the person to whom it belongs. The initials are stored in another excel file. Can I do this via a batch file or something?
  • In Excel, when I right click a tab in a workbook and get the option of 'move or copy' is it possible to 'copy' a worksheet multiple times all at once?
  • The sheet that I'm copying has cells that contain more than 255 characters. When I copy the sheet, only the first 255 characters in each cell are copied. How can I get all information copied, I need to do this for 16 sheets.
  • Do you have a workaround for the "The sheet you are copying has cells that contain more than 255 characters. When you copy the entire sheet, only the first 255 characters in each cell are copied." error I get in Excel?

Just use the following tool:
ASAP Utilities » Sheets » Insert multiple sheets (uses the cell values as sheet names)...

This is a quicker solution than manually copying or adding and then re-naming the worksheets of the default method in Excel.
The default shortcut in Excel to insert a single worksheet is Shift+F11 or Alt+Shift+F1.

Bonus tips, also interesting

  1. Fill » Quick numbering of selected cells...
  2. Sheets » Export worksheets as separate files...
  3. Sheets » Protect multiple sheets at once...
  4. Select » Set current selection to all worksheets
  5. Sheets » Remove all empty worksheets
  6. Sheets » Set print area on selected worksheets
  7. Sheets » Copy a sheet's page and print settings...
  8. Microsoft: 5 tips for working with multiple worksheets in Excel

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the amount of sheets you're working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.

Download

In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.
Download page

Comments are closed.

Pinterest