How Excel batch Create worksheets, Excel bulk Create worksheets Tutorial

Start Excel 2016 and create a new worksheet, and then enter the worksheet description in any cell, then the top down, enter the name of the worksheet that you want to create, and then select all the input in the order that it is actually needed.

Next, switch to the Insert tab and click the PivotTable button on the toolbar.

In the Open Create PivotTable dialog box, the Select a table or range item has been automatically filled in with the parameter, which is the range of data selected above. If you don't have a choice at first, you can choose again here. Select the existing sheet item below and place the cursor in the input box to the right of position, and then click on any blank cell in the worksheet to choose where to place the pivot table. Here the small series selects the C1 cell.

When you are finished, click OK and the PivotTable Field pane appears on the right.

In the Pivot Table pane, drag the 2016 month report (which is based on the list title that you set previously) and drop it in the filter box below.

Next, select the C1 cell (that is, the cell that holds the PivotTable report), and then switch to the PivotTable Tools-Analysis tab, click the arrow on the left side of the toolbar, and choose Show Filter Page from the Drop-down menu.

The Report Filter Page dialog box will appear because there is only one filtered page field and the default is selected, so just click OK to complete the task of bulk-creating the worksheet, with the name of the sheet you specify.

The next problem is that all the worksheets you create have a pivot table, and now we don't need it anymore. Right-click on any sheet tab and choose Select All Sheets from the right-click menu.

Finally press CTRL + a selection, and then click the Toolbar "clear → Clear all", the batch created a number of clean worksheets are completed.