天气预报 > 其他 > WPS怎么批量复制数据
WPS怎么批量复制数据
更新时间: 2020-09-19 00:00:00  

方法如下:

1、打开或新建要编辑的表格;

2、假设L列单元格的内容要重复出现在后面的行次中;

3、鼠标移至要复制内容的最末一行,单击鼠标,选中此单元格;

4、移动鼠标至单元格右下角,使鼠标的指针变成黑色实心线加形状时,拖动鼠标即可快速复制此单元格的内容到其他单元格内;5、此方法可批量复制数据,也可同时选中多列的单元格,拖动鼠标同样可轻松复制选中单元格内容到其他的单元格。

关键词: wps 怎么 批量 复制 数据

WPS怎么批量复制数据相关经验

天气预报

最新推荐

页面:/news/view-546851/ | 耗时:0.8823 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=546851 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=546851 LIMIT 0,1
select * from tbl_Articles_sphinx where id=546851 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1122104,1101669,1065181,1123056,1054306,1070478,1055055,1606619,1067181,1275802,1129777,1103230,1088746,1125506,1078873,1102348,1112943,1058865,1133375,1072006,1106256,1064819,1052425,1065765,1094249,1131263,1050341,1052819,1091251,1116293) ORDER BY field (ArticleID,1122104,1101669,1065181,1123056,1054306,1070478,1055055,1606619,1067181,1275802,1129777,1103230,1088746,1125506,1078873,1102348,1112943,1058865,1133375,1072006,1106256,1064819,1052425,1065765,1094249,1131263,1050341,1052819,1091251,1116293)