签到排名:今日本吧第个签到,
本吧因你更精彩,明天继续来努力!
连续签到:天 累计签到:天
0超级会员单次开通12个月以上,赠送连续签到卡3张
方方格子Excel工具箱-使用技巧
技巧1:在所有单元格内容前增加文字
![](http://imgsrc.baidu.com/forum/w%3D580/sign=6011c1a10ffa513d51aa6cd60d6c554c/d456dd44d688d43f760ac58f7a1ed21b0ff43b86.jpg)
1楼2016-02-09 10:33回复
2楼2016-02-09 10:34
技巧2:批量删除重复值
![](http://imgsrc.baidu.com/forum/w%3D580/sign=a59023e9de33c895a67e9873e1127397/67979a638535e5dd4da5f1a171c6a7efcf1b629d.jpg)
3楼2016-02-10 18:46
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧3:统计重复次数
![](http://imgsrc.baidu.com/forum/w%3D580/sign=5fc2f484d6c8a786be2a4a065708c9c7/2b6e14b4c9ea15ce4c0eb477b1003af33b87b246.jpg)
4楼2016-02-10 18:47
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧4:快速找出2部分数据的相同和不同
![](http://imgsrc.baidu.com/forum/w%3D580/sign=4bcdcc2a044f78f0800b9afb49310a83/db8bfb8e8c5494ee403f5d672af5e0fe99257e01.jpg)
5楼2016-02-10 19:20
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧5:大量数据中标记出重复值
![](http://imgsrc.baidu.com/forum/w%3D580/sign=c1b4d3cf62380cd7e61ea2e59145ad14/62c5b902738da97748d8aa54b751f8198718e3b4.jpg)
6楼2016-02-11 16:38
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧6:大量数据中快速找出重复值
![](http://imgsrc.baidu.com/forum/w%3D580/sign=5f2c51b4fcedab6474724dc8c736af81/d5afe050f3deb48f77778ea1f71f3a292df5780d.jpg)
7楼2016-02-11 16:38
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧7:批量合并相同单元格
![](http://imgsrc.baidu.com/forum/w%3D580/sign=28362a01221f95caa6f592bef9167fc5/00617b9a033b5bb576d60f8131d3d539b600bc26.jpg)
8楼2016-02-11 16:39
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧9:合并单元格求和
![](http://imgsrc.baidu.com/forum/w%3D580/sign=37fa1009f51fbe091c5ec31c5b600c30/bf7e9b0635fae6cd37b8841e08b30f2442a70f12.jpg)
10楼2016-02-11 16:39
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧10:合并单元格排序
![](http://imgsrc.baidu.com/forum/w%3D580/sign=965ea35dcffcc3ceb4c0c93ba244d6b7/bb46ff7fca806538dd998b6c90dda144ad348230.jpg)
11楼2016-02-11 16:40
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧12:数字和汉字分离
![](http://imgsrc.baidu.com/forum/w%3D580/sign=4c66cb94b04543a9f51bfac42e168a7b/b170f3305c6034a8a1a0ade1cc134954082376e2.jpg)
13楼2016-02-12 19:19
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧13:批量插入文本到开头
![](http://imgsrc.baidu.com/forum/w%3D580/sign=0ea5c58de01190ef01fb92d7fe1a9df7/4a8cbdd2572c11df227caa43642762d0f603c2f3.jpg)
14楼2016-02-12 19:19
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧14:批量插入文本到末尾
![](http://imgsrc.baidu.com/forum/w%3D580/sign=2247ac0493eef01f4d1418cdd0ff99e0/20af1e3c269759eeaba575abb5fb43166c22dfab.jpg)
15楼2016-02-12 19:19
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧15:批量截取中间文本
![](http://imgsrc.baidu.com/forum/w%3D580/sign=c121f0f20bf431adbcd243317b37ac0f/1e2f95b54aed2e73f842934c8001a18b86d6faf9.jpg)
16楼2016-02-12 19:20
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
技巧16:在文本中提取产品的规格(包含单位)
![](http://imgsrc.baidu.com/forum/w%3D580/sign=882963466a224f4a5799731b39f69044/26a154d4ad6eddc46b08a19b3edbb6fd536633bc.jpg)
17楼2016-02-12 19:20
![](http://imgsrc.baidu.com/forum/w%3D580/sign=646ec69933fae6cd0cb4ab693fb20f9e/5472d688d43f879457876f80d41b0ef41ad53adf.jpg?v=tbs)
![](//tb1.bdstatic.com/tb/cms/PC%E7%AB%AF%E5%BA%95%E9%83%A8%E9%80%9A%E6%A0%8F%E5%BC%B9%E5%B1%821000x120.png)
![](//tb2.bdstatic.com/tb/static-spage/widget/fixed_bar/images/icon_close_1683259.png)