当前时间： 2026-06-14 22:06:49
分类：办公文件
评论(0)
制作表格模板时,如何删除具体数字仅保留公式?工作中经常需要自己制作一个表格模板，再分发给各部门。很多时候表格模板除了要将每个单元格的格式、数据有效性等限制下，还需要部分单元格的计算结果位置写好公式。公式写完且验证完没问题之后，如何删除这些测试数据，仅保留写公式的单元格呢？如果模板像上图一样很简单，我们可以选中红框内单元格直接delete删除。但是如果模板比较复杂，计算单元格比较分散，单纯用delet清除功能，就需要单独选很多块区域，稍一不注意就会将有公式的单元格也清除掉。首先选中数据区域（注意尽量不要选择标题和项目行列），摁Ctrl键+G调出定位窗口。一般上面数据类型是全部选中的。我们取消除了常量和数字，其它所有的选中。点击确定后，就会发现已经将我们的测试数字全部选中，有公式的单元格都没有被选。关注狸子，一起探讨办公小技巧
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-16 23:36:22 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/751428.html
- 运行时间 : 0.152385s [ 吞吐率：6.56req/s ] 内存消耗：4,797.04kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=1d959505f632050c232384463124394e
- CONNECT:[ UseTime:0.000622s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000892s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000338s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000339s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000634s ]
- SELECT * FROM `set` [ RunTime:0.000222s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000537s ]
- SELECT * FROM `article` WHERE `id` = 751428 LIMIT 1 [ RunTime:0.000402s ]
- UPDATE `article` SET `lasttime` = 1781624182 WHERE `id` = 751428 [ RunTime:0.006251s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000256s ]
- SELECT * FROM `article` WHERE `id` < 751428 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
- SELECT * FROM `article` WHERE `id` > 751428 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000399s ]
- SELECT * FROM `article` WHERE `id` < 751428 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001190s ]
- SELECT * FROM `article` WHERE `id` < 751428 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001843s ]
- SELECT * FROM `article` WHERE `id` < 751428 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.005631s ]
0.154039s
夜雨聆风
