How to copy an excel table and keep the original size: first select the table you want to copy and paste, and copy; then right-click on the new worksheet to paste; then select the paste option in the lower right corner, and click Inverted triangle icon; finally select the [Keep Source Column Width] button.

How to copy the excel table and keep the original size:

1. First, find what we want to do on the computer Click to open the excel table to be operated;

2. Select the table we want to copy and paste;

3. After selecting the table, right-click the mouse, then click copy or directly press ctrl c to copy;

4. Go to a new worksheet, right-click to paste or ctrl v to paste;

5. There is a paste option at the bottom right of the pasted form, and then click the inverted triangle icon;

6. In the pop-up options, select "Keep source column width".

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to copy an excel table and keep the original size. For more information, please follow other related articles on the PHP Chinese website!