1. Enter the worksheet names in batches;
2. Click [Insert] and select [Pivot Table];
3. Check [Existing worksheet] and select the location to place the pivot table;
4. Select the fields that need to be added to the report;
5. Display the report filtering page.
Recommended tutorial:excel tutorial
The above is the detailed content of How to create multiple sheets in excel. For more information, please follow other related articles on the PHP Chinese website!