Sheet1 and sheet2 are merged

Appropriate methods need to be used depending on the data situation.

If you have two worksheets, you can copy one worksheet to the other table through the copy or move function of the tab bar, and the specific operation steps are as follows:

Materials required: Excel.

1. Open Table 1 and Table 2 in the same window, enter Table 1, and right-click the redundant tabs in Table 1.

2. Click "Delete" in the pop-up menu to delete the two extra tables.

3. Then go to Table 2, right-click on the sheet, and click to move or copy the sheet in the menu.

4. Click the arrow and click Table 1 in the drop-down menu.

5. Then check Create Copy, click Move to Last, and click OK.

6. In this way, a copy of sheet1 of table 2 can be added to table 1.

1. Right-click on the desktop and select New Microsoft Excel Worksheet.

2. Open the Excel2013 file, right-click on the worksheet tab "sheet1", and select the [Rename] menu item in the pop-up shortcut menu.

3. At this time, the worksheet label "sheet1" is highlighted and is in the state of OK.

<>5. After the modification is completed, click the floppy disk** in the upper left corner to save.

Excel is a method of merging worksheets by different sheets.

1. Import VBA module: create a new Excel summary table, rename Sheet1 to "Summary Table", delete the rest of the worksheets, press Alt+F11 to bring up the VBA device Right-click in the project window and select [Import File] Select the VBA module file (Quickly merge worksheets and workbooks. BAS) to close the VBA.

After importing, you can see the two macros "Merge Workbook" and "Merge Worksheet" from [Macros] [Development Tools].

2. Make a one-click Merge Workbook and a one-click Merge Worksheet button. Insert a rectangle, enter the text "Merge Workbook" and adjust the text color size and alignment, etc., then copy a rectangle and change the text to "Merge Worksheets". Select the Chinese character as the rectangle of "Merge Workbook", right-click Specify Macro Select the macro "Merge Workbook", select the Chinese word as the rectangle of "Merge Worksheets", right-click Specify Macro Select the macro "Merge Worksheet".

3. Merge 12 workbook data from January to December into 1 worksheet. Click Merge Workbooks, first select all the workbooks that need to be merged, and click Open to merge the 12-month sales table into the excel summary table. Then copy the header row to the first row of the summary table, and then click Merge Worksheets, and all the worksheets will be summarized into the summary table.