Home>Article>Topics> How to copy an excel table and keep the original size

How to copy an excel table and keep the original size

coldplay.xixi
coldplay.xixi Original
2020-08-01 13:21:20 30476browse

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 an excel table and keep the original size

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;

How to copy an excel table and keep the original size

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

How to copy an excel table and keep the original size

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

How to copy an excel table and keep the original size

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

How to copy an excel table and keep the original size

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

How to copy an excel table and keep the original size

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

How to copy an excel table and keep the original size

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!

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