日常做做报表时经常会遇到清理之前的数据，但是一个个删除太麻烦了，教大家在不删除公式和字符的情况下，快速删除清空Excel里的数字。
你要删除的数字若是以纯数字的形式储存在单元格，
则选中需删除的列范围同时按ctrl+g，定位条件--常量--去掉除“数字”外的√，确定，按del键即可
Excel怎么快速删除所有数字并保留公式
Yuanman
你我的梦，源于画。
Hello! It's a great pleasure to have you visit my blog.
It's truly a fateful encounter. If you are interested in Chinese goods, we can collaborate.
I can provide you with affordable Chinese products that you can sell in your country, thereby boosting our economic income.
If you are willing to cooperate, I hope to hear from you to discuss the opportunity for collaboration.
Here is my Email: t@29ym.com
Looking forward to connecting with you and embarking on this partnership together!