方法/步骤
如下表,我们想在右边复制一个同内容同列宽的表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d1047dd1d4f313fb80e7bec9046?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
先选中整个表格,在键盘上同时按“CTRL”+“C”,复制该表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/00e93901213fb80e31d870a926d12f2eb9389446?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选中单元格F2, 单击鼠标右键,在弹出的下拉菜单中选择粘贴。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8c1001e93901213ff13a5fa244e736d12f2e9546?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
可以看到,新表格中的数据和原表格一样,但是列宽不一致,导致F列的数据未完全显示出来,所以我们还需进行下一步操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a2cc7cd98d1001e97e350571a80e7bec54e79746?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选中F2单元格,单击鼠标右键,在弹出的下拉菜单中选择“选择性粘贴”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/203fb80e7bec54e77ae50b60a9389b504fc26a46?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
在弹出的对话框中,将“列宽”勾选上,点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bec1fd3129f3f2eb9389b506b46?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
这次我们看到的新表格的列宽与原表格相同了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e93901690b9c406bec54e736d19646?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述