日常做做报表时经常会遇到清理之前的数据,但是一个个删除太麻烦了,教大家在不删除公式和字符的情况下,快速删除清空Excel里的数字。
你要删除的数字若是以纯数字的形式储存在单元格,
则选中需删除的列范围同时按ctrl+g
,定位条件--常量--去掉除“数字”外的√,确定,按del
键即可
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!