Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Batch Create Sheets In Excel?

Date:2021-10-7 Author:Sandra

Do you know how to create multiple sheets? There is a very easy way to quickly get it. Not only do you get a lot of workbooks quickly, but they are also well named. Ok, let’s get the ball rolling. Suppose we need to make a sales table for 2021, from January to December. Then we need to create a total of twelve workbooks, and each one is named according to the month like below.

How To Batch Create Sheets In Excel?

Select any cell between A1 to A13 and go to the Insert tab, choose Pivot Table.

Then the box of Create Pivotable would be there. Check the Existing Worksheet option, and click any blank cell in sheet 1 to make the location. Hit ok.

How To Batch Create Sheets In Excel?

There will be PivotTable Fields. Just hold down the left mouse button and pull it down, to make the “ Month” drop down to behind the Filters.

How To Batch Create Sheets In Excel?
How To Batch Create Sheets In Excel?

Let’s go to the arrow of Pivot Table and choose Show Report Filter Pages behind Options.

How To Batch Create Sheets In Excel?

Hit OK.

How To Batch Create Sheets In Excel?

Wow, there are 12 sheets from January to December.

How To Batch Create Sheets In Excel?
How To Batch Create Sheets In Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *