How to quickly transfer Excel table contents to a new table

What if the user wants to add an Excel table content to another table? Some friends will think of copying to another form although this method is OK, but it is difficult to encounter a lot of data duplication, the following method can quickly convert the content to another table.

Operation Steps

1, open the Excel table in the workbook to select the page to be transferred, the following figure in the "Junior high School."

2, then press the right mouse button to expand the menu select "Move or copy sheet."

3, at this time select the new worksheet you want to transfer to, the following figure "Book1".

4. Before selecting "Sheet1" in the "select Sheet" below, the table is moved to the front of "Sheet1".

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

5. Finally, we see that "Book1" has already transferred the content to the new table.