How to merge multiple tables into one page in excel

How to merge multiple tables into one page in excel: first open the [Clipboard] task pane and copy the table for the first quarter; then copy the tables for the second and third quarter to the clipboard, and Do not copy the header; then open the general table and paste the first quarter's table; finally, paste the other tables in sequence.

How to merge multiple tables into one page in excel:

1. Click the [Start] tab Click the dialog box launcher in the [Clipboard] group (the arrow shown in the figure below) to open the "Clipboard" task pane.

#2. Select the "First Quarter" table and press Ctrl C to copy the table contents. The copied content now appears in the Clipboard task pane.

#3. Follow the same method and copy the tables for the second quarter, third quarter and fourth quarter to the clipboard. It should be noted that there is no need to copy the header of the subsequent tables.

4. After the four quarters are copied, as shown in the figure below, in the "Clipboard" task pane, the content copied first is at the bottom, and the content copied later is The content is above, please pay attention to the order.

5. Switch to the worksheet "Annual Income and Expenditure Statement", position the cursor on the cell where you want to insert the table, and click the "Clipboard" task pane Click the bottom piece of content so that the content of the first quarter is pasted.

#6. Follow the same method and paste the tables for the second quarter, third quarter and fourth quarter into the designated areas. Note that the contents in the Clipboard task pane should be pasted from bottom to top and the insertion position should be noted. After completion, it will look like the following picture:

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to merge multiple tables into one page in excel. For more information, please follow other related articles on the PHP Chinese website!