天气预报15天查询> 其他> excel如何自动生成123

excel如何自动生成123

更新时间: 2020-10-03 00:00:00     

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

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

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

关键词: excel 如何 自动 生成

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-1486644/ | 耗时:0.4449 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
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)