Pinned topic EXCEL快捷键运用

‏2020-12-30T09:02:12Z | Tags:

Answered question This question has been answered.

Unanswered question This question has not been answered yet.

Ctrl+H（替换键）1.求和批量替换成求和平均？下面举例：求和想换成求平均值，把sum替换成average即可实现。

2.EXCEL如何快速把12月改成11月？

列如：一列日期全是12月份直接把/12/替换成/11/就可以。斜杠不可少，否则年份或天数包含12天时也会替换成11了。

ctrl+home快速跳到文档开头
trl+end快速跳到文档末尾
home快速跳到行首
end快速跳到行尾

......

更多EXCEL实用快捷键，欢迎补充~

4 images associated with this topic
View Images

邹小婷 cc9e1bc0-b761-1036-8d71-ef16cba5f6da zxiaoting@kinlong.cn

83 Posts
回复：EXCEL快捷键运用

‏2020-12-30T09:18:05Z

This is the accepted answer. This is the accepted answer.

实用
- Log in to reply.
熊峰 c75ed940-ed61-1039-9c64-ab4bc38c0954 xiongfeng@kinlong.cn

165 Posts
回复：EXCEL快捷键运用

‏2020-12-30T09:22:37Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
孟佳佳 cd36b240-b761-1036-8dc2-ef16cba5f6da mjiajia@kinlong.cn

62 Posts
回复：EXCEL快捷键运用

‏2020-12-31T01:30:28Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
代文彪 f7a65940-ef90-1038-885c-ab4bc38c0954

262 Posts
回复：EXCEL快捷键运用

‏2020-12-31T03:41:05Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
徐洪 db84ce40-b761-1036-9c35-ef16cba5f6da

221 Posts
回复：EXCEL快捷键运用

‏2020-12-31T05:19:59Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李德民 e98c54c0-81e5-103a-95dc-ab4bc38c0954

102 Posts
回复：EXCEL快捷键运用

‏2020-12-31T17:23:00Z

This is the accepted answer. This is the accepted answer.

点赞
- Log in to reply.
石明华 0bc631c0-d7fe-1038-8501-ab4bc38c0954

169 Posts
回复：EXCEL快捷键运用

‏2021-01-03T03:08:44Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李娟 d031a2c0-b761-1036-90e9-ef16cba5f6da

80 Posts
回复：EXCEL快捷键运用

‏2021-01-03T05:25:31Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
张秋菊 d9bb0ac0-b761-1036-9abf-ef16cba5f6da zqiuju@kinlong.cn

99 Posts
回复：EXCEL快捷键运用

‏2021-01-08T05:45:31Z

This is the accepted answer. This is the accepted answer.

实用，学习
- Log in to reply.
王增涛 1a286dc0-dd52-1037-833f-ab4bc38c0954

93 Posts
回复：EXCEL快捷键运用

‏2021-01-08T05:50:16Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
吉芳亮 f08f3e40-6a52-103a-9457-ab4bc38c0954 jfangliang@kinlong.cn

122 Posts
回复：EXCEL快捷键运用

‏2021-01-08T09:39:00Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
谢敏婷 f23910c0-907b-1038-9aa1-ab4bc38c0954

21 Posts
回复：EXCEL快捷键运用

‏2021-01-09T01:18:55Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
江璐英 cdcf48c0-b761-1036-8e9c-ef16cba5f6da jluying@kinlong.cn

132 Posts
回复：EXCEL快捷键运用

‏2021-01-11T06:31:15Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
席素云 de7fbec0-b761-1036-9f74-ef16cba5f6da xsuyun@kinlong.cn

119 Posts
回复：EXCEL快捷键运用

‏2021-01-12T02:25:33Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
廖晓漫 d9bb0ac0-b761-1036-9ac1-ef16cba5f6da

152 Posts
回复：EXCEL快捷键运用

‏2021-01-12T03:54:23Z

This is the accepted answer. This is the accepted answer.

学到了
- Log in to reply.
刘伟 bd189340-a6d4-103a-9804-ab4bc38c0954

327 Posts
回复：EXCEL快捷键运用

‏2021-01-12T04:18:50Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
郑丹丹 e3dd0940-b761-1036-84ff-ef16cba5f6da zdandan1@kinlong.cn

45 Posts
回复：EXCEL快捷键运用

‏2021-01-15T08:37:36Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
卢娟 ba6df040-77ae-103a-9544-ab4bc38c0954

172 Posts
回复：EXCEL快捷键运用

‏2021-01-16T00:34:00Z

This is the accepted answer. This is the accepted answer.

棒
- Log in to reply.
潘孝丽 f6952ec0-60e4-103a-93ad-ab4bc38c0954 pxiaoli@kinlong.cn

146 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:31:26Z

This is the accepted answer. This is the accepted answer.
郑丹丹 e3dd0940-b761-1036-84ff-ef16cba5f6da zdandan1@kinlong.cn

‏2021-01-15T08:37:36Z

More...
优秀
- Log in to reply.
褚玉垒 8a7aeac0-d0eb-1038-832d-ab4bc38c0954

51 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:37:22Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
史良 a25a7340-729f-1038-95f7-ab4bc38c0954

71 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:38:32Z

This is the accepted answer. This is the accepted answer.

学习了
- Log in to reply.
戴琳 cdcf48c0-b761-1036-8e72-ef16cba5f6da dailin@kinlong.cn

14 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:42:11Z

This is the accepted answer. This is the accepted answer.

日期的那个替换学习到了，实用
- Log in to reply.
王文幸 1b090dc0-61ae-103a-93d4-ab4bc38c0954

67 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:43:58Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
王增涛 1a286dc0-dd52-1037-833f-ab4bc38c0954

93 Posts
回复：EXCEL快捷键运用

‏2021-01-16T01:44:23Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
林晓俊 b7bf8740-c8e3-1037-8126-ab4bc38c0954

131 Posts
回复：EXCEL快捷键运用

‏2021-01-16T02:16:30Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
耿小艳 37f9a3c0-414a-1039-9241-ab4bc38c0954 gxiaoyan@kinlong.cn

369 Posts
回复：EXCEL快捷键运用

‏2021-01-16T04:35:59Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
耿小艳 37f9a3c0-414a-1039-9241-ab4bc38c0954 gxiaoyan@kinlong.cn

369 Posts
回复：EXCEL快捷键运用

‏2021-01-16T04:36:05Z

This is the accepted answer. This is the accepted answer.

优秀
- Log in to reply.
李冉 281e5ac0-99be-1037-98e8-ab4bc38c0954

41 Posts
回复：EXCEL快捷键运用

‏2021-01-16T04:36:13Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
廖海深 d4f656c0-b761-1036-959e-ef16cba5f6da

94 Posts
回复：EXCEL快捷键运用

‏2021-01-16T05:03:51Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
吉芳亮 f08f3e40-6a52-103a-9457-ab4bc38c0954 jfangliang@kinlong.cn

122 Posts
回复：EXCEL快捷键运用

‏2021-01-16T06:56:46Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
王茂盛 3d9349c0-201d-1038-8eeb-ab4bc38c0954 wmaosheng@kinlong.cn

155 Posts
回复：EXCEL快捷键运用

‏2021-01-20T06:42:41Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
熊涛 84a51740-2692-1039-8db6-ab4bc38c0954 xiongtao@kinlong.cn

343 Posts
回复：EXCEL快捷键运用

‏2021-01-20T06:45:27Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
舒霞明 dc1d64c0-b761-1036-9d50-ef16cba5f6da sxiaming@kinlong.cn

20 Posts
回复：EXCEL快捷键运用

‏2021-01-22T08:46:40Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
韦春贵 aa05d4c0-3e51-103a-8fad-ab4bc38c0954 wchungui@kinlong.cn

413 Posts
回复：EXCEL快捷键运用

‏2021-01-22T09:08:05Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
郭华彬 d51474c0-b607-1037-9cb9-ab4bc38c0954 ghuabin1@kinlong.cn

73 Posts
回复：EXCEL快捷键运用

‏2021-02-01T19:58:34Z

This is the accepted answer. This is the accepted answer.

棒
- Log in to reply.
邹枞 b118cdc0-1d50-103a-8b99-ab4bc38c0954

204 Posts
回复：EXCEL快捷键运用

‏2021-02-26T06:38:44Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
李瑞丹 7713ab40-59d2-103a-92c7-ab4bc38c0954

105 Posts
回复：EXCEL快捷键运用

‏2021-02-26T09:22:52Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
易相华 d1fb6640-b761-1036-9283-ef16cba5f6da yxianghua@kinlong.cn

235 Posts
回复：EXCEL快捷键运用

‏2021-02-27T05:37:55Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
陈发全 cc058540-b761-1036-8cc3-ef16cba5f6da cfaquan@kinlong.cn

621 Posts
回复：EXCEL快捷键运用

‏2021-02-27T07:32:09Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
刘伟 bd189340-a6d4-103a-9804-ab4bc38c0954

327 Posts
回复：EXCEL快捷键运用

‏2021-03-01T23:54:47Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
李忠 55a6c6c0-252c-103a-8c5d-ab4bc38c0954 lizhong@kinlong.cn

116 Posts
回复：EXCEL快捷键运用

‏2021-03-02T00:28:23Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
刘英姿 e4759fc0-b761-1036-8582-ef16cba5f6da lyingzi@kinlong.cn

38 Posts
回复：EXCEL快捷键运用

‏2021-03-02T00:39:41Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
吴泽海 d889ddc0-b761-1036-9972-ef16cba5f6da

92 Posts
回复：EXCEL快捷键运用

‏2021-03-02T03:29:34Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
刘伟 bd189340-a6d4-103a-9804-ab4bc38c0954

327 Posts
回复：EXCEL快捷键运用

‏2021-03-03T00:09:19Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
包彩玉 568bcec0-adbb-1039-9994-ab4bc38c0954 bcaiyu@kinlong.cn

140 Posts
回复：EXCEL快捷键运用

‏2021-03-03T02:45:57Z

This is the accepted answer. This is the accepted answer.

点赞，学习
- Log in to reply.
李明明 3a440640-24d4-1038-8f53-ab4bc38c0954 lmingming1@kinlong.cn

73 Posts
回复：EXCEL快捷键运用

‏2021-05-17T05:12:23Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
曹琴 a5edfa40-729f-1038-95fa-ab4bc38c0954

143 Posts
回复：EXCEL快捷键运用

‏2021-05-17T05:13:56Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
梁森 ce67df40-b761-1036-8f49-ef16cba5f6da

125 Posts
回复：EXCEL快捷键运用

‏2021-05-17T08:24:15Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
易相华 d1fb6640-b761-1036-9283-ef16cba5f6da yxianghua@kinlong.cn

235 Posts
回复：EXCEL快捷键运用

‏2021-05-17T23:47:22Z

This is the accepted answer. This is the accepted answer.
- Log in to reply.
陈乐 20baab40-5cf7-103a-9332-ab4bc38c0954 chenle@kinlong.cn

185 Posts
回复：EXCEL快捷键运用

‏2021-05-18T00:30:15Z

This is the accepted answer. This is the accepted answer.

学习！
- Log in to reply.
王彭 1aa0e540-f02e-1037-870b-ab4bc38c0954 wangpeng3@kinlong.cn

77 Posts
回复：EXCEL快捷键运用

‏2021-05-18T00:38:58Z

This is the accepted answer. This is the accepted answer.

学习~~~
- Log in to reply.
吴德先 fb7a01c0-4e08-103a-912f-ab4bc38c0954 wdexian@kinlong.cn

128 Posts
回复：EXCEL快捷键运用

‏2021-05-19T02:32:08Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
王贵群 e9d2ea40-b761-1036-8ab7-ef16cba5f6da wguiqun@kinlong.cn

63 Posts
回复：EXCEL快捷键运用

‏2021-05-19T04:20:29Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李斌 663306c0-761c-103a-952d-ab4bc38c0954 libin5@kinlong.cn

255 Posts
回复：EXCEL快捷键运用

‏2021-12-01T10:41:57Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
关艳容 6e46fe40-7165-103a-94f7-ab4bc38c0954

59 Posts
回复：EXCEL快捷键运用

‏2021-12-01T10:45:44Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李忠 55a6c6c0-252c-103a-8c5d-ab4bc38c0954 lizhong@kinlong.cn

116 Posts
回复：EXCEL快捷键运用

‏2021-12-03T05:45:23Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
石洪咪 d6a1aec0-c3e7-103a-998b-ab4bc38c0954 shongmi@kinlong.cn

92 Posts
回复：EXCEL快捷键运用

‏2021-12-04T06:17:37Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李先杰 cc058540-b761-1036-8cc6-ef16cba5f6da lxianjie@kinlong.cn

103 Posts
回复：EXCEL快捷键运用

‏2021-12-04T08:39:20Z

This is the accepted answer. This is the accepted answer.

赞
- Log in to reply.
赵晓彦 f5ec88c0-6a52-103a-946f-ab4bc38c0954

167 Posts
回复：EXCEL快捷键运用

‏2021-12-04T10:25:02Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
龚名恒 e5a6ccc0-b761-1036-8695-ef16cba5f6da

56 Posts
回复：EXCEL快捷键运用

‏2021-12-07T03:06:02Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
林家鎔 d64921c0-d7b8-103b-8898-ab4bc38c0954

7 Posts
回复：EXCEL快捷键运用

‏2021-12-07T03:41:54Z

This is the accepted answer. This is the accepted answer.

好东西
- Log in to reply.
杨玲 7a229f40-e356-103a-9b61-ab4bc38c0954 yangling@kinlong.cn

166 Posts
回复：EXCEL快捷键运用

‏2021-12-07T05:12:22Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
熊涛 84a51740-2692-1039-8db6-ab4bc38c0954 xiongtao@kinlong.cn

343 Posts
回复：EXCEL快捷键运用

‏2021-12-13T03:39:23Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.
李忠 55a6c6c0-252c-103a-8c5d-ab4bc38c0954 lizhong@kinlong.cn

116 Posts
回复：EXCEL快捷键运用

‏2021-12-14T00:35:11Z

This is the accepted answer. This is the accepted answer.

学习
- Log in to reply.