One minute! 100 worksheets can be generated with the click of a mouse
Due to the need of the position, I have to make an Excel form every month.
Worryingly, a series of worksheets are created in each Excel file and named after the date.
For example, if you have 31 days in August, you need to create 31 worksheets, and the result is as follows:
When I first started the job, I didn't find it difficult, so I finished it silently.
Would you do the same?
But day after day, doing such mechanical repetitive work, my mood is as follows:
Manual creation is not only inefficient, but also error-prone. I've had enough!
So, frantically looking for a way to be lazy.
After collecting tutorials, test and compare them one by one. I really found a good way to install neither plug-ins nor code. And it's very simple and easy.
How do you do that? A total of four steps are required:
❶ lists all the table names in the table
❷ generates a PivotTable report by table name
❸ adds the table name to the PivotTable filter area
❹ displays the filter page
The steps are simple. Let's take a look at the specific operation methods:
❶ lists the list names
The advantage of listing all the table names in the Excel table is that it can be done in batches using the auto-fill function.
It is important to note that the date cannot be displayed in the form of "8x1" because the worksheet name cannot contain the character "/", so it must be formatted as "8-1".
❷ generates PivotTable
Add the ❸ name field to the filter area
❹ displays the filter page
Create a batch of worksheets easily and the task is done. In summer, I can eat melons leisurely.
However, it is not completely done yet. All the generated tables also have PivotTable components, so you can't add data directly. What I want in the end is an empty form.
To get rid of these remaining PivotTable parts, you just need to select all the worksheets and clear the contents and formatting.
After learning this trick, I found a lot of repetitive work, in fact, there are ways to finish it in batches. Since then, I have been fascinated by searching for all kinds of smart "lazy" methods, which has really saved a lot of work time.
Do you also have some tricks to be lazy in Excel? Welcome to the comments section to tell me.
This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: King, Aji Editor: Zhu Lan
