正文概述

Excel复制表格怎么保留原格式？看看你就会了

Copying tables is commonly used in office work, but many colleagues often encounter issues with table column width and format inconsistencies when copying tables. Today, we will share with you how to copy tables in Excel while retaining the original table format.

1. Selective Paste

After selecting the entire table, right-click and choose "Paste Special" - "Keep Source Formatting" to ensure that the copied table remains exactly the same.

2. Group Worksheets

After creating a new worksheet, select the data in Table 1, then hold down the Shift key and select the second blank table. Click "Home" - "Edit" - "Fill" - "Group Worksheets," and then select "Defaults" for all. This way, the copied table will be exactly the same and retain the original format.

3. Move and Copy Tables

Right-click on the original table name - select "Move or Copy" - choose "Move to end," check "Create a copy," and then click "OK."

4. Ctrl Key Copy

On the table you want to copy, hold down the Ctrl key and select the worksheet, drag it to the right, and release to copy an identical table.

These are the tips for copying tables while preserving the original format. With this method, you can easily solve the problem of table distortion during copying.

Excel 复制表格格式表格

注意事项：
不要在微信、知乎、QQ、内置浏览器下载、请用手机浏览器下载！如果您是手机用户，请移步电脑端下载！
1、文稿PPT，仅供学习参考，请在下载后24小时删除。
2、如果资源涉及你的合法权益，第一时间删除。
3、联系方式：mail@johngko.com

第一素材网 » Excel复制表格怎么保留原格式？看看你就会了