Question

电子表格中的带原格式的复制和粘贴如何设置？

Answer 1

1、打开“Excel”软件，打开一个表格素材。
/iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3d77caf579b4a1cd11728b294b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3d77caf579b4a1cd11728b294b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3d77caf579b4a1cd11728b294b"/>
2、确定我们需要粘贴的文件内容，然后用鼠标右键的选择：“复制”（按组合键“Ctrl+C”）。

/iknow-pic.cdn.bcebos.com/d62a6059252dd42a09c317e20d3b5bb5c8eab8b4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d62a6059252dd42a09c317e20d3b5bb5c8eab8b4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d62a6059252dd42a09c317e20d3b5bb5c8eab8b4"/>
3、然后在工作表的底部，点击“+”。
/iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef95f9be6ff3faaf51f2de669f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef95f9be6ff3faaf51f2de669f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef95f9be6ff3faaf51f2de669f"/>

4、新建一个工作表。
/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4b9f88917d3c451da81cb3e62"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4b9f88917d3c451da81cb3e62?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4b9f88917d3c451da81cb3e62"/>
5、在新的工作簿中选择“选择性粘贴”（按“Ctrl+V”）。
/iknow-pic.cdn.bcebos.com/32fa828ba61ea8d37ce2624d990a304e241f58b2"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/32fa828ba61ea8d37ce2624d990a304e241f58b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d37ce2624d990a304e241f58b2"/>
6、在粘贴按钮中，找到其中中的“保留原格式”。
/iknow-pic.cdn.bcebos.com/30adcbef76094b36ef9d0aa4adcc7cd98d109d6f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/30adcbef76094b36ef9d0aa4adcc7cd98d109d6f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/30adcbef76094b36ef9d0aa4adcc7cd98d109d6f"/>
7、如此就粘贴了一个和原表格相同的表格。
/iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9ca7025903701213fb80e911d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9ca7025903701213fb80e911d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9ca7025903701213fb80e911d"/>

• 官方服务
  • 官方网站
  • 官方网站