Method: First open the excel table that needs to be operated, select the cells that need to be copied; then right-click the mouse and select "Copy" in the pop-up right-click menu; then open another excel table and select the specified cell grid; finally, right-click the mouse and select "Paste" in the pop-up right-click menu.
![How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/article/202105/06/2021050613391386108.jpg)
The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.
Open the wps form and enter its main interface;
![1620279219116637.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/221/417/796/1620279219116637.png)
Click on the file and select Open;
![1620279245857066.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/642/301/820/1620279245857066.png)
# #Find an existing table file, select it and press Open;
![1620279279166078.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/966/760/210/1620279279166078.png)
Open the table in wps2019;
![1620279308284325.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/143/493/395/1620279308284325.png)
Start from the first row and column, that is, cell A1, press and hold the left mouse button, drag the mouse to select all the tables;
![1620279343225135.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/856/141/164/1620279343225135.png)
Press the right button , click Copy;
![1620279370101445.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/359/357/597/1620279370101445.png)
Click another workbook, and click the first cell with the mouse, which is the starting position where the copied table is stored;
![1620279401717410.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/235/543/100/1620279401717410.png)
Right-click the mouse and click Paste;
![1620279428387213.png How to copy an Excel table to make it the same size as the original](https://img.php.cn/upload/image/138/103/694/1620279428387213.png)
We will copy a new table that is exactly the same as the original table.
Related learning recommendations:
excel tutorial
The above is the detailed content of How to copy an Excel table to make it the same size as the original. For more information, please follow other related articles on the PHP Chinese website!
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn