Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

Quickly create worksheets from a list of worksheet names in Excel

How can you do if you need to create a list of worksheets with customized worksheet names in Excel? Instead of modifying the sheet names one by one after creating, you can use kutools for Excel's Create Sequence Worksheets utility to create a list of worksheet from various worhseet names in Excel.

Create sequence worksheets from a list of Excel default names

Create sequence worksheets from a list of month / day names

Create sequence worksheets from a list of series numbers

Create sequence worksheets from a custom list

Create sequence worksheets from a list of cell values


Click Enterprise >> Worksheet >> Create Sequence Worksheets. See screenshots:

shot create sequence sheet 1 shot arrow right shot create sequence sheet 2

Create sequence worksheets from a list of Excel default names

In Excel file the default worksheet name displayed as Sheet1,Sheet2,Sheet3…,and if you need to create multiple worksheet names as this, you need to click new tab many times, but with this Create Sequence Worksheets utility, you can quickly create multiple sequence default sheet names.

1. Apply this utility by clicking Enterprise > Worksheet > Create Sequence Worksheets.

2. In the Create Sequence Worksheets dialog box, specify the following options:

  • (1.) Select one worksheet that you want to create sequence worksheets based on.
  • (2.) Specify the number of the worksheets that you want to create.
  • (3.) Then check Excel Default Name option under Sheet names based on.

shot-create-sequence-worksheets3

3. Then click OK, and the sequence worksheets with default sheet names have been created in a new workbook.

shot-create-sequence-worksheets4


Create sequence worksheets from a list of month / day names

Supposing you want to generate multiple worksheets from a list of month or day names, with this multifunctional tool, you can quickly deal with it.

1. Go to the Create Sequence Worksheets dialog box, do the following operations:

  • (1.) Select one worksheet that you want to create sequence worksheets based on.
  • (2.) Check Custom Lists option under Sheet names based on to expand this dialog box.
  • (3.) Then in the expanded dialog, click the day names or month names from the right list box that you want, and the number of the creating worksheets will be displayed automatically.

shot-create-sequence-worksheets5

2. And then click OK, a list of worksheets with the moth or day names have been created in a new workbook. See screenshot:

shot-create-sequence-worksheets6


Create sequence worksheets from a list of series numbers

With this utility, you can also generate sequence worksheets based on series numbers.

1. Apply this feature, and in the Create Sequence Worksheets dialog box, set the following options:

  • (1.) Select one worksheet that you want to create sequence worksheets based on.
  • (2.) Check Sequence Numbers option under Sheet names based on to expand this dialog box.
  • (3.) And in the expanded dialog, set the sequential numbers and you can add the prefix or suffix for the numbers as you need.
  • (4.) Specify the number of the worksheets that you want to create.

shot-create-sequence-worksheets7

2. After specifying the options, click OK, and you will get the following sequence worksheets.

shot-create-sequence-worksheets8


Create sequence worksheets from a custom list

Sometimes, you need the certain worksheet names frequently, in order not to input them over and over again, you can add the sheet names to the custom list, and then you can repeatedly use them to create new workbook with the custom list.

1. Go to the Create Sequence Worksheets dialog box, and specify the operations as follows:

  • (1.) Select one worksheet that you want to create sequence worksheets based on.
  • (2.) Click Custom List option under Sheet names based on to expand this dialog box.
  • (3.) Then click shot-button1 button and a Create List dialog box will pop out, you can create your own custom list data. In the Create Lists dialog, type one sheet name you need and click shot-button2 button to add the name into the below list box, repeating it to add other names.

shot-create-sequence-worksheets9

2. After inputting the sheet names, click Add button to add this list data into the list box. And click the custom list from the right list box that you are created, and the number of the creating worksheets will be displayed automatically.

shot-create-sequence-worksheets10

3. Then click OK, and your customized names of worksheets have been created in a new workbook. See screenshot:

shot-create-sequence-worksheets11

Tip: If you check Worksheet color option in the Create Lists dialog box, you can specify the color for the sheet tabs. See following screenshots:

shot-create-sequence-worksheets12

-1

shot-create-sequence-worksheets13


Create sequence worksheets from a list of cell values

Supposing you have a range of data, and you want to create worksheets from the range of data. How can you do?

1. Select the range that you want to create worksheets.

2. Go to the Create Sequence Worksheets dialog box, select one worksheet that you want to create sequence worksheets based on. And then check Data in a range option under Sheet names based on, and the number of the creating worksheets will be displayed automatically. See screenshot:

shot-create-sequence-worksheets14

3. And then click OK, the new worksheets have been created with the cell values in a new workbook. See screenshot:

shot-create-sequence-worksheets15

Demo: Quickly create worksheets from a list of worksheet names in Excel

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.