天气预报 > 生活 > Excel下拉求不了和怎么回事
Excel下拉求不了和怎么回事
更新时间: 2021-06-10 19:08:24  

1、表格设置为手动重算模式了。

2、打开Excel表格,下拉公式后,不能自动计算。

3、点击左上角的文件,然后点击选项。

4、点击进入Excel选项后,点击公式,然后在计算选项中勾选自动重算。

5、在计算选项中勾选自动重算后,公式就自动重算了。

关键词: excel 怎么 回事

Excel下拉求不了和怎么回事相关经验

天气预报

最新推荐

页面:/news/view-1191422/ | 耗时:0.4176 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1191422 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1191422 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1191422 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1131337,1070818,1065409,1105920,1072759,1076568,1114983,1073758,1107733,1120105,1084135,1084643,1112959,1093439,1112662,1117295,1093983,1111292,1108642,1069445,1118655,1109881,981473,1042843,1108900,1107404,1068660,1061042,1113153,1109963) ORDER BY field (ArticleID,1131337,1070818,1065409,1105920,1072759,1076568,1114983,1073758,1107733,1120105,1084135,1084643,1112959,1093439,1112662,1117295,1093983,1111292,1108642,1069445,1118655,1109881,981473,1042843,1108900,1107404,1068660,1061042,1113153,1109963)