天气预报 > 其他 > excel如何自动生成123
excel如何自动生成123
更新时间: 2020-10-03 00:00:00  

1、在A1单元格输入1,然后把鼠标放到单元格的右下角;

2、指针变成黑色实心十字的时候,点住鼠标左键不松开,下拉填充即可;

3、如果生成的不是序列,可以点击填充柄选择填充序列这个选项即可,而且数组常用ROW函数来生成序列。

关键词: excel 如何 自动 生成

excel如何自动生成123相关经验

天气预报

最新推荐

页面:/news/view-1486644/ | 耗时:0.2659 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1486644 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1486644 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1486644 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2600417,2531252,1092752,2666471,1109895,293902,2746186,688872,242403,2022691,2562312,1653339,1279868,1079255,467249,300330,315705,2738847,1367676,1079307,1051677,2162399,1295188,2056220,2380132,313026,654955,1674619,781045,864570) ORDER BY field (ArticleID,2600417,2531252,1092752,2666471,1109895,293902,2746186,688872,242403,2022691,2562312,1653339,1279868,1079255,467249,300330,315705,2738847,1367676,1079307,1051677,2162399,1295188,2056220,2380132,313026,654955,1674619,781045,864570)