How to copy an Excel table to make it the same size as the original

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.

The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.

Open the wps form and enter its main interface;

Click on the file and select Open;

# #Find an existing table file, select it and press Open;

Open the table in wps2019;

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;

Press the right button , click Copy;

Click another workbook, and click the first cell with the mouse, which is the starting position where the copied table is stored;

Right-click the mouse and click Paste;

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!