2. To edit multiple worksheets at the same time, you need to have enough worksheets to edit first, although you can add multiple tables by inserting, as shown below.
But if you need a lot of worksheets, I don't think anyone wants to do it. Here is a method that can be set at one time. Specifically, open the Options submenu under the Tools menu, find the General tab, which contains the item "Number of sheets in new workbook", and modify its value as needed.
4. Open a new workbook after closing, as shown in the figure below.
5. According to the later demand, we need to make the 12 table of receipt style, the 12 table of receipt style, and the other two tables are the consolidated tables of invoice summary table, material code and receipt/issue type. For example, editing these 12 "Receipts" tables can be done as follows. First, press and hold the "Ctrl" key on the keyboard, and then click 12 receipt forms respectively to select them all.
6. Then edit the intersecting contents in the "1 month warehousing" table. When finished, right-click the name of the selected worksheet and select Ungroup Worksheets from the pop-up menu. At this point, let's see if all other 1 1 receipt tables have been edited. Similarly, the 12 delivery table can also be operated in this way.