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

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Date:2019-8-30 Author:Olivia

In previous post, we have introduced the tip of how to batch create multiple documents with different titles in Word. You might have the same problem when editing with Excel. The method is quite different but also easy, but it can save your time and improve the efficiency. Let’s see what we can do about it.

First, select all the text, go to Insert tab and click PivotTable in Tables group.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

The Create PivotTable dialog box appears, and simply click OK.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Then check the box of your table title under PivotTable Fields, for this example, it’s Monthly Sales in 2019.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Left-click and drag the table title to the box of FILTERS.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Next, click Options and select Show Report Filter Pages in the upper left corner.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Hit OK when the Show Report Filter Pages dialog box appears.

How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel

Now you know how to batch create multiple sheets with different titles. The names of new created sheets are those text you just entered.

How to Batch Create Multiple Sheets with Different Titles in Microsoft 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 *