https://blog.youkuaiyun.com/cheer_zhangzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/cheer_zhang/article/details/79698869https://blog.youkuaiyun.com/cheer_zhang/article/details/79698869cheer_zhangMon, 26 Mar 2018 17:54:25 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79425552https://blog.youkuaiyun.com/cheer_zhang/article/details/79425552cheer_zhangFri, 02 Mar 2018 17:41:03 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79423939https://blog.youkuaiyun.com/cheer_zhang/article/details/79423939cheer_zhangFri, 02 Mar 2018 15:49:42 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79304875https://blog.youkuaiyun.com/cheer_zhang/article/details/79304875cheer_zhangSat, 10 Feb 2018 15:05:48 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79263239https://blog.youkuaiyun.com/cheer_zhang/article/details/79263239cheer_zhangThu, 08 Feb 2018 09:10:43 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79279310https://blog.youkuaiyun.com/cheer_zhang/article/details/79279310cheer_zhangThu, 08 Feb 2018 09:10:25 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79279470https://blog.youkuaiyun.com/cheer_zhang/article/details/79279470cheer_zhangThu, 08 Feb 2018 09:10:13 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79279370https://blog.youkuaiyun.com/cheer_zhang/article/details/79279370cheer_zhangThu, 08 Feb 2018 09:09:54 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79273496https://blog.youkuaiyun.com/cheer_zhang/article/details/79273496cheer_zhangWed, 07 Feb 2018 19:20:13 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79278217https://blog.youkuaiyun.com/cheer_zhang/article/details/79278217cheer_zhangWed, 07 Feb 2018 13:42:00 +0800 数据验证： ✔ 按照如下设置，勾选【提供下拉箭头】；【来源】处输入下拉列表项，用‘，’隔开： ✔ 效果如下： ✔ 下拉列表实现方案的优化： 单独保存下拉项（示例将下拉项保存到一个新的工作表）： 在数据验证对话框中点击下]]>https://blog.youkuaiyun.com/cheer_zhang/article/details/79276580https://blog.youkuaiyun.com/cheer_zhang/article/details/79276580cheer_zhangWed, 07 Feb 2018 11:20:51 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79267248https://blog.youkuaiyun.com/cheer_zhang/article/details/79267248cheer_zhangTue, 06 Feb 2018 10:39:26 +0800替换功能？当然可以，只不过效率奇低！倘若数据量大，效率会大打折扣！ 今天说的功能就是为了解决这个问题，而且效率超高！要处理的数据示例如下： 如何才能快速替换所有数据成统一的值呢？下面开始展示绝技： ☞ Ctrl+A全选 -》Ctrl+G，弹出定位条件对话框，点击【定位条件】： ]]>https://blog.youkuaiyun.com/cheer_zhang/article/details/79261973https://blog.youkuaiyun.com/cheer_zhang/article/details/79261973cheer_zhangMon, 05 Feb 2018 18:37:57 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79261574https://blog.youkuaiyun.com/cheer_zhang/article/details/79261574cheer_zhangMon, 05 Feb 2018 16:41:07 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79246825https://blog.youkuaiyun.com/cheer_zhang/article/details/79246825cheer_zhangSat, 03 Feb 2018 15:00:35 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79246718https://blog.youkuaiyun.com/cheer_zhang/article/details/79246718cheer_zhangSat, 03 Feb 2018 14:22:08 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79246558https://blog.youkuaiyun.com/cheer_zhang/article/details/79246558cheer_zhangSat, 03 Feb 2018 13:59:21 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79245729https://blog.youkuaiyun.com/cheer_zhang/article/details/79245729cheer_zhangSat, 03 Feb 2018 11:52:50 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79245441https://blog.youkuaiyun.com/cheer_zhang/article/details/79245441cheer_zhangSat, 03 Feb 2018 11:06:54 +0800https://blog.youkuaiyun.com/cheer_zhang/article/details/79244753https://blog.youkuaiyun.com/cheer_zhang/article/details/79244753cheer_zhangSat, 03 Feb 2018 09:28:41 +0800