Shulou(Shulou.com)11/24 Report--

The title of the original text: "Why is the copied table" deformed "? how to retain the original format? "

When you copy a table in Excel, you will find that the table is deformed. What format, row height, and column width have changed? what is the situation? How to copy to keep the format unchanged? Today, Mr. Wang came to share several methods with everyone.

As shown in the figure, copy and paste the table directly, and the row height and column width will be changed.

How can I copy it to keep the source format unchanged?

01, copy table retention format with row height and column width Click the triangle button next to the top A, you can select the entire table, then copy, and then position the cursor to the target cell, paste. The format of the copied table, as well as the row height and column width are exactly the same.

02, copy the whole row to retain the source format the above method is to copy the contents of the entire worksheet, but if you have multiple tables in the worksheet, you only need to copy one of the tables, then you can first select the entire row of the table to copy, then to the target cell "right"-"selective paste"-"keep the source column width".

03. Copy the garbled code of the table with the formula. When we copy the table with the formula, the formula in it will be confused due to the change in the position of the cell.

Here, it is suggested that you can convert the copied formula into numerical paste.

We can be divided into three steps to paste, after copying the table with the formula, navigate to the target cell of the paste, "right"-"selective paste" select "column width" to determine. Then "right" again-"paste selectively" and select "numeric" to determine. Finally, select format.

The table pasted in this way retains both the format and the column width, and converts the formula to a numerical value.

Copy the theme and color of the table sometimes copy the table, but the color of the table changes. What's going on?

This is because the theme styles and colors used in the table have not been copied.

We can advance the source table and click "Page layout"-"theme"-"Save current theme".

Open the copied table and go to "Page layout"-"theme". Find and use our previously saved theme here to restore the table color.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.