wps表格中如何快速复制相同内容?小编这就告诉大家
材料/工具
电脑
wps
方法
1/6
打开或新建要编辑的表格
![](https://iknow-pic.cdn.bcebos.com/5ab5c9ea15ce36d3fc6aa8a328f33a87e950b132?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2/6
假设L列单元格的内容要重复出现在后面的行次中
![](https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800a628ba29da33533fa828b4732?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3/6
鼠标移至要复制内容的最末一行,单击鼠标,选中此单元格
![](https://iknow-pic.cdn.bcebos.com/0eb30f2442a7d93371c6cfe0bf4bd11373f00132?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4/6
移动鼠标至单元格右下角,使鼠标的指针变成黑色实心线“+”形状时,拖动鼠标即可快速复制此单元格的内容到其他单元格内
![](https://iknow-pic.cdn.bcebos.com/562c11dfa9ec8a1399747c73e503918fa0ecc033?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5/6
此方法可复制单个单元格,也可同时选中多列的单元格,拖动鼠标同样可轻松复制选中单元格内容到其他的单元格
![](https://iknow-pic.cdn.bcebos.com/5243fbf2b2119313852ad42377380cd791238d33?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6/6
文字的内容拖动就可以复制相同内容到其他单元格