elƪʾʹ"Office "

ע Ҫִ²"Microsoft Office "ҿɼҪ򿪻ʾ"Office "밴 Alt+H Դ""˵Ȼ O"Office "ɼ밴 F1 ʾ""
F1 
 ʾ"""Office "رգ F1 ""ڣ 
""
Alt+ 
 ""ʾбѡ""⡣Alt+1 ʾһ⣬Alt+2 ʾڶ⣬ơ 
Alt+¼ 
 ʾ""бе"" 
Alt+ϼ 
 ʾ""беһ"" 
Esc 
 ر""Ϣʾ 
 򵼻Ի
Tab 
 е"" ť 
ѡ"" ť󣬰ո 
 򵼻Իʾ""Ҫ""ٰһοոע⣬е򵼻Ի򶼾""ṩ""
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ
 ʾʹ""
Ҫʹ""ڣر"Microsoft Office "Ҫر""밴 F1 ʾ"" Alt+O Դ"Office "Իе"ѡ"ѡ Alt+U "ʹ Office "ѡȻ Enter F1 ʾ""ڡ
F1 
 ر""ʾ""ڡ"" F1 ʾ""
""
F6 
 """Ŀ¼""Ӧ"""֮л 
Tab 
 ѡȡһصıӣⶥ"ȫʾ""ȫ" 
Shift+Tab 
 ѡȡһصıӣ Microsoft Office Web ¶"鿴"ť 
Enter 
 ִѡ?quot;ȫʾ""ȫ"ıеĲ 
Alt+O 
 ʾ"ѡ"˵Է"" 
Alt+OȻ T 
 ػʾ"Ŀ¼""Ӧ"""ѡ 
Alt+OȻ B 
 ʾһ鿴 
Alt+OȻ F 
 ǰʾУʾһ 
Alt+OȻ H 
 ָҳ 
Alt+OȻ S 
 ""ֹͣ""⣨Ҫֹͣ Web ҳã 
Alt+OȻ I 
  Microsoft Internet Explorer "Internet ѡ"Ի򣬿ڴ˸ķʹ 
Alt+OȻ R 
 ˢ⣨ָ Web ҳӣòã 
Alt+OȻ P 
 ӡе⣬ֻӡѡ 
Alt+F4 
 ر"" 
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ
ʹ"Ŀ¼""""Ӧ"
 F6 Դ""л"Ŀ¼Ӧ򵼡"
Ctrl+Tab 
 лһѡ 
Alt+C 
 л"Ŀ¼"ѡ 
Alt+A 
 л"Ӧ"ѡ 
Alt+I 
 л""ѡ 
Enter 
 ѡ"" 
¼ 
 ѡһһ"" 
ϼ 
 ѡһһ"" 
Shift+F10 
 ʾݲ˵ 
ע ʹĻ鿴ʵóʱ""ڵ"Ӧ"ѡϣ"Office """⣬ô""ṩѽ

Excel̿ݼȫ() 

ʹ""
 F6 Դ"Ŀ¼Ӧ򵼡" л""⡣
Alt+Ҽ 
 תһ"" 
Alt+ 
 תһ"" 
Tab 
 ѡȡһصıӣⶥ"ȫʾ""ȫ" 
Shift+Tab 
 ѡȡһصıӣ Microsoft Office Web ¶"鿴"ť 
Enter 
 ִѡ"ȫʾ""ȫ"ıеĲ 
 ϼ¼ 
""Ŀʼ 
Page Up  Page Down 
 ԽϴĲ""Ŀʼ 
Home  End 
 ǰ""Ŀʼ 
Ctrl+P 
 ӡǰ"" 
Ctrl+A 
 ѡ"" 
Ctrl+C 
 ѡƵ 
Shift+F10 
 ʾݲ˵ 
 Office İ
ʾʹô
Alt+Tab 
 лһ 
Alt+Shift+Tab 
 лһ 
Ctrl+Esc 
 ʾ Windows"ʼ"˵ 
Ctrl+W  Ctrl+F4 
 رѡĹڡ 
Ctrl+F5 
 ָѡĹڵĴС 
F6 
 л֣""˵ϵ""Ĺеһ 
Shift+F6 
 лֵĹеһ 
Ctrl+F6 
 򿪶ʱлһڡ 
Ctrl+Shift+F6 
 лһڡ 
Ctrl+F7 
 δʱִиùڵ""˵ϵ"ƶ"ʹüͷƶôڣɲ Esc 
Ctrl+F8 
 δʱִйڵ""˵ϵ"С"ʹüͷڴСʱ Esc 
Ctrl+F9 
 СΪͼꡣ 
Ctrl+F10 
 󻯻ԭѡĹڡ 
PrtScr 
 ĻͼƬƵС 
Alt+Print Screen 
 ѡڵͼƬƵС

Excel̿ݼȫ() 

ʺʹܱ
Alt+Shift+F10 
 ʾܱǵĲ˵Ϣʾ˶ܱǣлһܱǲʾ˵Ϣ 
¼ 
 ѡȡܱǲ˵еһ 
ϼ 
 ѡȡܱǲ˵еһ 
Enter 
 ִܱǲ˵ѡӦĲ 
Esc 
 رܱǲ˵Ϣ
ʾ
󲻹Ƿܱʱ֪ͨҪʾ밲װڼϰװ Microsoft Office Sounds
ڷάʱ Microsoft Office Web վ Microsoft Office Sounds"?quot;˵ϣ" Office""Microsoft Office Sounds"װļҪ""˵ϵ"ѡ"Ի""ѡѡ"ṩ"ѡѡлøѡ󣬴ýӰ֧ Office 
ע еĳӽת Web ϣʱлر
ʺʹ񴰸
F6 
 ӳ򴰿ڵ񴰸񡣿Ҫ F6 Ρ 
ע  F6 ûʾ񴰸밴 Alt ˵Ȼٰ Ctrl+Tab 񴰸 
Ctrl+Tab 
 ˵򹤾ڻ״̬ʱ񴰸񡣿Ҫ Ctrl+Tab Ρ 
Tab  Shift+Tab 
 񴰸ڻ״̬ʱѡһһѡ 
Ctrl+¼ 
 ʾ񴰸˵ϵȫ 
¼ϼ 
 ѡӲ˵ѡƶһѡĳЩضѡƶ 
ո Enter 
 ѡĲ˵ִзѡťĲ 
Shift+F10 
 һݲ˵ѡļ˵ 
Home  End 
 ˵Ӳ˵ɼʱѡеĵһһ 
Page Up  Page Down 
 ѡļбϻ¹ 
Ctrl+Home  Ctrl+End 
 ƶѡļбĶײ 
ʺʹò˵͹
F10  Alt 
 ѡ˵ͬʱرմ򿪵Ĳ˵Ӳ˵ 
Tab  Shift+Tab 
 ѡѡϵһһť˵ 
Ctrl+Tab  Ctrl+Shift+Tab 
 ѡѡһһ 
Enter 
 ѡĲ˵ִѡťĲ 
Shift+F10 
 ʾѡĿݲ˵ 
Alt+ո 
 ʾ Excel ڵ"ؼ"˵ 
¼ϼ 
 ˵Ӳ˵ʱѡһһ 
Ҽ 
 ѡ߻ұߵĲ˵Ӳ˵ʱ˵Ӳ˵֮л 
Home  End 
 ѡ˵Ӳ˵ϵĵһһ 
Esc 
 رմ򿪵Ĳ˵Ӳ˵ʱֻرӲ˵ 
Ctrl+¼ 
 ʾ˵ϵȫ 
Ctrl+7 
 ʾ"" 
ע üѡ˵ʾĹϵ˵ Alt ѡ˵Ҫѡظ Ctrl+TabֱѡĹڰĲ˵У»ߵĸɴ򿪲˵Ȼٰд»ߵĸ

Excel̿ݼȫ() 

񴰸ĴС
 1.  Alt ѡ˵
 2. ظ Ctrl+Tab ѡĹ񴰸
 3. ִв֮һ 
 ĴС
 1. ڹУ Ctrl+ոʾ"ѡ"˵ 
 2. ѡ"С"ٰ Enter 
 3. ʹüͷĴС
 ƶ
 4. ڹУ Ctrl+ոʾ"ѡ"˵ 
 5. ѡ"ƶ"ٰ Enter 
 6. ʹüͷɵλá Ctrl+ͷһƶһءҪʹ̶ظ¼Ҫ̶ֱ߻ұߣ򵱹ҲʱֱҼ
 񴰸ĴС
 7. 񴰸У Ctrl+ոʾĲ˵
 8. ʹ¼ѡ"С"ٰ Enter 
 9. ʹüͷɵ񴰸ĴС Ctrl+ͷһεһء
 ƶ񴰸
 10. 񴰸У Ctrl+ոʾĲ˵
 11. ¼ѡ"ƶ"ٰ Enter 
 12. ʹüͷɵ񴰸λá Ctrl+ͷһƶһء
 4. ƶС밴 Esc
ʹöԻ
Tab 
 ƶһѡѡ顣 
Shift+Tab 
 ƶһѡѡ顣 
Ctrl+Tab  Ctrl+Page Down 
 лԻеһѡ 
Ctrl+Shift+Tab  Ctrl+Page Up 
 лԻеһѡ 
ͷ 
 Ѵ򿪵беѡ֮ƶѡеѡ֮ƶ 
ո 
 ִѡťĲߣѡлѡѡ 
бѡĸ 
 бѹرգƶбеĸѡϡ 
Alt+ѡд»ߵĸ 
 ѡѡѡлѡ 
Alt+¼ 
 ѡб 
Enter 
 ִжԻĬťúͻʾİťͨ?quot;ȷ"ťĲ 
Esc 
 ȡرնԻ
ʹöԻеı༭
༭Ϊհףмճݣ磬ûļе·
Home 
 ƶݵĿʼ 
End 
 ƶݵĩβ 
Ҽ 
 ƶһַ 
Ctrl+ 
 һ 
Ctrl+Ҽ 
 һ 
Shift+ 
 ѡȡѡһַ 
Shift+Ҽ 
 ѡȡѡһַ 
Ctrl+Shift+ 
 ѡȡѡһ 
Ctrl+Shift+Ҽ 
 ѡȡѡһ 
Shift+Home 
 ѡӲ㵽ʼ 
Shift+End 
 ѡӲ㵽ĩβ 
Excel̿ݼȫ() 
ʹ"""Ϊ""ͼƬ"Ի
"""Ϊ""ͼƬ"Իֱ֧׼Իļ̿ݷʽҪ鿴Իı׼ݷʽҪļ̿ݷʽе"ʹöԻ""ʹöԻеı༭"֡ЩԻҲ֧пݷʽ
Alt+1 
 תһļУ 
Alt+2 
 "һ" ť򿪵ǰļеһļ 
Alt+3 
 " Web" ťرնԻ򲢴 Web ҳ 
Alt+4 
 "ɾ" ťɾѡļлļ 
Alt+5 
 "½ļ" ť½ļ 
Alt+6 
 "鿴" ťڿɻõļͼл 
Alt+7  Alt+L 
 ""ťʾ""˵ 
Shift+F10 
 ʾѡļлļĿݲ˵ 
Tab 
 ڶԻѡл 
F4  Alt+I 
 "ҷΧ"б 
F5 
 ˢļб 
ڹ͹İ
Ԥʹӡ
Ctrl+P  Ctrl+Shift+F12 
 ʾ"ӡ"Ի 
ڴӡԤʹаҪλӡԤ밴 Alt+Fٰ V
 ͷ 
 Ŵʾʱҳƶ 
 Page Up  Page Down 
 Сʾʱÿιһҳ 
 Ctrl+ϼ Ctrl+ 
 Сʾʱһҳ 
 Ctrl+¼ Ctrl+Ҽ 
 Сʾʱһҳ 
 
Shift+F11  Alt+Shift+F1 
 ¹ 
Ctrl+Page Down 
 ƶеһŹ 
Ctrl+Page Up 
 ƶеһŹ 
Shift+Ctrl+Page Down 
 ѡǰһŹҪȡѡŹ밴 Ctrl+Page DownߣҪѡ밴 Ctrl+Page Up 
Shift+Ctrl+Page Up 
 ѡǰһŹ 
Alt+O H R 
 Եǰ"ʽ"˵""Ӳ˵ϵ"" 
Alt+E M 
 ƶƵǰ?quot;༭"˵ϵ"ƶƹ" 
Alt+E L 
 ɾǰ"༭"˵ϵ"ɾ" 
ڹƶ͹
ͷ 
 ϡ¡ƶһԪ 
Ctrl+ͷ 
 ƶǰıԵ 
Home 
 ƶס 
Ctrl+Home 
 ƶĿͷ 
Ctrl+End 
 ƶһԪ񣬸õԪλռõеС 
Page Down 
 ƶһ 
Page Up 
 ƶһ 
Alt+Page Down 
 ƶһ 
Alt+Page Up 
 ƶһ 
F6 
 л֣""˵ϵ""Ĺеһ 
Shift+F6 
 лֵĹеһ 
Ctrl+Backspace 
 ʾԪ 
F5 
 ʾ"λ"Ի 
Shift+F5 
 ʾ""Ի 
Shift+F4 
 ظһ""ͬ"һ" 
Tab 
 ܱĹϵķԪ֮ƶ 
Excel̿ݼȫ() 
ѡƶ
Enter 
 ѡڴƶ 
Shift+Enter 
 ѡڴƶ 
Tab 
 ѡдƶѡеĵԪƶ 
Shift+Tab 
 ѡдƶѡеĵԪƶ 
Ctrl+ 
 ˳ʱ뷽ƶѡһǡ 
Ctrl+Alt+Ҽ 
 ڲڵѡУлһѡ 
Ctrl+Alt+ 
 лһڵѡ 
ע ڰ Enter  Shift+Enter ֮󣬸ƶ򣺰 Alt+Tٰ O""˵ϵ"ѡ"Ű Ctrl+Tab ֱѡ"༭"ѡȻ" Enter ƶ"á
""ģʽƶ
ѡ""ģʽ״̬н""
End 
 򿪻ر""ģʽ 
End+ͷ 
 һлһݿΪλƶ 
End+Home 
 ƶһԪ񣬸õԪλռõеһС 
End+Enter 
 ƶǰұߵķǿյԪѴ"Lotus 1-2-3 ü"""˵"ѡ"е"1-2-3 İ"ѡ˿ݼá 
 Scroll Lock 򿪵״̬ƶ͹ 
 Scroll Lock رյ״̬ʹù Page Up  Page DownʱԪѡ֮ƶҪڹʱıѡĵԪȴ Scroll Lock
Scroll Lock 
 򿪻ر Scroll Lock 
Home 
 ƶϽǵĵԪ 
End 
 ƶ½ǵĵԪ 
ϼ¼ 
 ϻ¹һС 
Ҽ 
 ҹһС 
ѡݺ͵Ԫİ
ѡԪкԼ
Ctrl+ո 
 ѡС 
Shift+ո 
 ѡС 
Ctrl+A 
 ѡŹ 
Shift+Backspace 
 ѡ˶Ԫ£ֻѡԪ 
Ctrl+Shift+ո 
 ѡһ£ѡϵж 
Ctrl+6 
 ضʾʾռλ֮л
ѡضĵԪ
Ctrl+Shift+*Ǻţ 
 ѡԪΧĵǰ򣨰ΧڿкͿе򣩡͸ӱУѡ͸ӱ 
Ctrl+/ 
 ѡԪ顣 
Ctrl+Shift+Oĸ O 
 ѡעеԪ 
Ctrl+\ 
 ѡУѡȡԪеֵƥĵԪ 
Ctrl+Shift+| 
 ѡУѡȡԪеֵƥĵԪ 
Ctrl+[ţ 
 ѡȡѡеĹʽֱõеԪ 
Ctrl+Shift+{ţ 
 ѡȡѡеĹʽֱӻõеԪ 
Ctrl+]ҷţ 
 ѡȡֱûԪĹʽĵԪ 
Ctrl+Shift+}Ҵţ 
 ѡȡֱӻûԪĹʽĵԪ 
Alt+;ֺţ 
 ѡȡǰѡеĿɼԪ 
Excel̿ݼȫ() 
չѡ
F8 
 򿪻رչģʽչģʽУ״̬н"չ"ͷչѡ 
Shift+F8 
 ĵԪӵѡУʹüͷƶҪӵʼȻ F8 ͼͷѡһ 
Shift+ͷ 
 ѡչһԪ 
Ctrl+Shift+ͷ 
 ѡչԪͬһлͬһеһǿյԪ 
Shift+Home 
 ѡչס 
Ctrl+Shift+Home 
 ѡչĿʼ 
Ctrl+Shift+End 
 ѡչһʹõĵԪ½ǣ 
Shift+Page Down 
 ѡչһ 
Shift+Page Up 
 ѡչһ 
End+Shift+ͷ 
 ѡչԪͬһлͬһеһǿյԪ 
End+Shift+Home 
 ѡչһʹõĵԪ½ǣ 
End+Shift+Enter 
 ѡչǰеһԪѴ"Lotus 1-2-3 ü"""˵"ѡ"е"1-2-3 İ"ѡ˿ݼ򽫲á 
Scroll Lock+Shift+Home 
 ѡչϽǵĵԪ 
Scroll Lock+Shift+End 
 ѡչ½ǵĵԪ 
롢༭øʽͼݵİ

Enter 
 ɵԪ벢ѡȡһԪ 
Alt+Enter 
 ڵԪлС 
Ctrl+Enter 
 õǰѡĵԪ 
Shift+Enter 
 ɵԪ벢ѡȡһԪ 
Tab 
 ɵԪ벢ѡȡһԪ 
Shift+Tab 
 ɵԪ벢ѡȡһԪ 
ESC 
 ȡԪ롣 
ͷ 
 ϡ¡ƶһַ 
Home 
 Ƶס 
F4  Ctrl+Y 
 ظһβ 
Ctrl+Shift+F3 
 б־ơ 
Ctrl+D 
 䡣 
Ctrl+R 
 䡣 
Ctrl+F3 
 ơ 
Ctrl+K 
 볬ӡ 
EnterھгӵĵԪУ 
 ӡ 
Ctrl+;ֺţ 
 Իڡ 
Ctrl+Shift+:ðţ 
 ʱ䡣 
Alt+¼ 
 ʾ嵥ĵǰеֵб 
Ctrl+Z 
 һβ 
ַ
 F2 ɱ༭Ԫ񣬴 Num LockС̰м
Alt+0162 
 ֱַ 顣 
Alt+0163 
 Ӣַ ꡣ 
Alt+0165 
 ԻԲ  
Alt+0128 
 ŷԪ ? 
Excel̿ݼȫ() 
벢㹫ʽ
=Ⱥţ 
 빫ʽ 
F2 
 ر˵Ԫı༭״̬󣬽ƶ༭ڡ 
Backspace 
 ڱ༭ڣɾһַ 
Enter 
 ڵԪ༭ɵԪ롣 
Ctrl+Shift+Enter 
 ʽΪ鹫ʽ롣 
Esc 
 ȡԪ༭е롣 
Shift+F3 
 ڹʽУʾ"뺯"Ի 
Ctrl+A 
 λڹʽйʽƵҲʱʾ""Ի 
Ctrl+Shift+A 
 λڹʽкƵҲʱš 
F3 
 ճʽС 
Alt+=Ⱥţ 
  SUM "Զ"ʽ 
Ctrl+Shift+"˫ţ 
 ԪϷԪеֵƵǰԪ༭ 
Ctrl+&#39;Ʋţ 
 ԪϷԪеĹʽƵǰԪ༭ 
Ctrl+`ţ 
 ʾԪֵʾʽ֮л 
F9 
 д򿪵Ĺей 
 ѡһֹʽѡ֡Ȼ Enter  Ctrl+Shift+Enter鹫ʽüֵ滻ѡ֡ 
Shift+F9 
  
Ctrl+Alt+F9 
 д򿪵Ĺейϴμ֮Ƿ˸ġ 
Ctrl+Alt+Shift+F9 
 ¼ʽȻд򿪵ĹееԪ񣬰δΪҪĵԪ 
༭
F2 
 ༭Ԫ񣬲õԪĩβ 
Alt+Enter 
 ڵԪлС 
Backspace 
 ༭ԪȻõԪ񣬻ڱ༭ԪʱɾԪеǰһַ 
Delete 
 ɾҲַɾѡ 
Ctrl+Delete 
 ɾ㵽ĩı 
F7 
 ʾ"ƴд"Ի 
Shift+F2 
 ༭Ԫע 
Enter 
 ɵԪ룬ѡȡһԪ 
Ctrl+Z 
 һβ 
Esc 
 ȡԪ롣 
Ctrl+Shift+Z 
 ʾ"Զ"ܱʱָһεԶ 
롢ɾ͸ƵԪ
Ctrl+C 
 ѡĵԪ 
Ctrl+Cٰһ Ctrl+C 
 ʾ Microsoft Office 壨ճ 
Ctrl+X 
 ѡĵԪ 
Ctrl+V 
 ճƵĵԪ 
Delete 
 ѡԪݡ 
Ctrl+ַ 
 ɾѡĵԪ 
Ctrl+Shift+Ӻ 
 հ׵Ԫ 
Excel̿ݼȫ() 
ݵĸʽ
Alt+&#39;Ʋţ 
 ʾ"ʽ"Ի 
Ctrl+1 
 ʾ"Ԫʽ"Ի 
Ctrl+Shift+~ 
 Ӧ""ָʽ 
Ctrl+Shift+$ 
 ӦôСλ""ʽУ 
Ctrl+Shift+% 
 ӦòСλ"ٷֱ"ʽ 
Ctrl+Shift+^ 
 ӦôλСλ"ѧ"ָʽ 
Ctrl+Shift+# 
 Ӧúꡢ¡Ի"Ի"ʽ 
Ctrl+Shift+@ 
 ӦúСʱͷӲ"ʱ"ʽ 
Ctrl+Shift+! 
 ӦôλСλʹǧλָҸø (-) ʾ""ʽ 
Ctrl+B 
 ӦûȡӴָʽ 
Ctrl+I 
 Ӧûȡбʽ 
Ctrl+U 
 Ӧûȡ»ߡ 
Ctrl+5 
 Ӧûȡɾߡ 
Ctrl+9 
 ѡС 
Ctrl+Shift+(ţ 
 ȡѡڵе״̬ 
Ctrl+0㣩 
 ѡС 
Ctrl+Shift+)ţ 
 ȡѡڵе״̬ 
Ctrl+Shift+& 
 ѡԪӦ߿ 
Ctrl+Shift+_ 
 ȡѡԪ߿ 
ʹ"Ԫʽ"Իе"߿"ѡ
 Ctrl+1 ʾöԻ
Alt+T 
 ӦûȡϿߡ 
Alt+B 
 Ӧûȡ¿ߡ 
Alt+L 
 Ӧûȡߡ 
Alt+R 
 Ӧûȡҿߡ 
Alt+H 
 ѡ˶еĵԪӦûȡˮƽָߡ 
Alt+V 
 ѡ˶еĵԪӦûȡֱָߡ 
Alt+D 
 Ӧûȡ¶Խǿߡ 
Alt+U 
 Ӧûȡ϶Խǿߡ 
ɸѡּʾ͹嵥İ
ʹݱ""˵ϵ"¼"
¼ 
 ƶһ¼еͬһֶΡ 
ϼ 
 ƶһ¼еͬһֶΡ 
Tab  Shift+Tab 
 ƶ¼еÿֶΣȻƶÿť 
Enter 
 ƶһ¼ֶΡ 
Shift+Enter 
 ƶһ¼ֶΡ 
Page Down 
 ƶǰ 10 ¼ͬһֶΡ 
Ctrl+Page Down 
 ʼһµĿհ׼¼ 
Page Up 
 ƶ 10 ¼ͬһֶΡ 
Ctrl+Page Up 
 ƶ׼¼ 
Home  End 
 ƶֶεĿͷĩβ 
Shift+End 
 ѡչֶεĩβ 
Shift+Home 
 ѡչֶεĿͷ 
Ҽ 
 ֶƶһַ 
Shift+ 
 ֶѡߵһַ 
Shift+Ҽ 
 ֶѡұߵһַ 
Excel̿ݼȫ(ʮ) 
ɸѡб""˵ϵ"Զɸѡ"
Alt+¼ 
 ڰͷĵԪУʾǰе"Զɸѡ"б 
¼ 
 ѡ"Զɸѡ"беһ 
ϼ 
 ѡ"Զɸѡ"беһ 
Alt+ϼ 
 رյǰе"Զɸѡ"б 
Home 
 ѡ"Զɸѡ"беĵһ"ȫ" 
End 
 ѡ"Զɸѡ"беһ 
Enter 
 ݴ"Զɸѡ"бѡɸѡб 
ʾغͷּʾ
Alt+Shift+Ҽ 
 лз顣 
Alt+Shift+ 
 ȡлз顣 
Ctrl+8 
 ʾطּʾš 
Ctrl+9 
 ѡС 
Ctrl+Shift+(ţ 
 ȡѡڵе״̬ 
Ctrl+0㣩 
 ѡС 
Ctrl+Shift+)ţ 
 ȡѡڵе״̬ 
͸ӱ͸ͼİ
Ļñ
1.  F10 ɼ˵ 
2.  Ctrl+Tab  Ctrl+Shift+Tab ɼ"͸ӱֶб" 
3. ¼ϼѡֶΡҼɴ򿪻رһչֶΡ 
4.  Tab ѡ"ӵ"бٰ¼ɴ򿪸б 
5. ¼ϼѡҪƶֶεȻ Enter 
6.  Tab ѡ"ӵ"бȻ Enter 
ʹ"͸ӱ͸ͼ--"Ի
ҪʾöԻ밴 Tabֱ"͸ӱ͸ͼ"ĵ 3 ѡ""
ϼ¼ 
 ѡұбеһһֶΰť 
Ҽ 
 лֶΰťʱѡҲİť 
Alt+R 
 ѡֶ""С 
Alt+C 
 ѡֶ""С 
Alt+D 
 ѡֶ""С 
Alt+P 
 ѡֶ"ҳ"С 
Alt+L 
 ʾѡֶε"͸ӱֶ"Ի 
ʾֶе
Alt+¼ 
 ʾ͸ӱ͸ͼֶεбʹüͷѡֶΡ 
ϼ 
 ѡбеһ 
¼ 
 ѡбеһ 
Ҽ 
 ںпõ¼ʾ¼ 
 
 ¼ʾ¼ 
Home 
 ѡбеĵһɼ 
End 
 ѡбеһɼ 
Enter 
 رбʾѡ 
ո 
 ѡС˫ѡСбеĸѡ˫ѡпͬʱѡĳ¼ 
Tab 
 б"ȷ"ť"ȡ"ť֮л 
͸ӱĲ
Ctrl+Shift+*Ǻţ 
 ѡ͸ӱ 
Alt+Shift+Ҽ 
 ͸ӱֶеѡ顣 
Alt+Shift+ 
 ȡ͸ӱֶзķ顣 

Excel̿ݼȫ(ʮһ) 

ͼİ
ͼѡͼԪ
F11  Alt+F1 
 ǰݵͼ 
Ctrl+Page Down 
 ѡͼѡеһŹֱѡͼΪֹ 
Ctrl+Page Up 
 ѡͼѡеһŹֱѡͼΪֹ 
¼ 
 ѡͼеһԪء 
ϼ 
 ѡͼеһԪء 
Ҽ 
 ѡеһԪء 
 
 ѡеһԪء 
ѡǶͼ
1. ʾ"ͼ" Alt+Vٰ TȻ¼ֱѡ"ͼ"ΪֹȻ Enter 
2.  F10 ɼ˵ 
3.  Ctrl+Tab  Ctrl+Shift+Tab ѡ"ͼ" 
4. Ҽѡ"ͼ"ϵ"ѡ" ť 
5.  Ctrl+Enter ѡһ 
6.  Tab ǰѭѡ󣨻 Shift+Tab ѭѡ󣩣ֱԲγߴصҪѡǶͼϡ 
7.  Ctrl+Enter ɼͼԱѡеԪء 
ڻͼİ
 Ļͬʱʾ"""ͼ"ʱ Alt+U """ѡͼ"֮л Enter ִѡ
ѡͼ
༭ͼеıʱͨ Tab  Shift+Tab ѡһһִв
1.  F10ٰ Ctrl+Tab ѡ"ͼ"ȻҼѡ"ѡ" ť 
2.  Ctrl+Enter ѡһͼ 
3.  Tab ǰѭѡ󣨻 Shift+Tab ѭѡ󣩣ֱߴصҪѡĶϡ 
ѷ飬 Tab ѡ÷飬ſѡ÷еÿȻѡһ 
4. ѡʱҪлع밴 Esc 
ѡͼ
1.  Alt+U ѡ"ͼ"ϵ"ѡͼ?quot;˵ 
2. ʹüͷƶ"ѡͼ"ȻҼ 
3. ʹüͷѡ"ѡͼ" 
4.  Ctrl+Enter 
5. Ҫ"ѡͼ"ĸʽ밴 Ctrl+1 ʾ"ѡͼθʽ"Ի 
ı
1.  F10ٰ Ctrl+Tab ѡ"ͼ"ȻҼѡ"ı" ť 
2.  Ctrl+Enter 
3. ıмı 
4. ִв֮һ 
Ҫɼ󣬷ع밴 Esc
Ҫıĸʽ밴 Escٰ CTRL+1 ʾ"ıʽ"Իɸʽú밴 Enterٰ Esc ɷع 

1.  Alt+Iٰ PȻ W""˵ϵ"ͼƬ"Ӳ˵е"" 
2. ʹüͷѡʽȻ Enter 
3. ıȻʹ Tab ѡԻеѡ 
4.  Enter ɲ"" 
5. Ҫ""ĸʽʹ""ϵĹߣ Ctrl+1 ʾ"ָʽ"Ի 
 תͼ
1. ѡȡҪתĻͼ 
2.  Ctrl+1 ʾ"ʽ"˵Ȼ Ctrl+Tab ѡ"С"ѡ 
3.  Alt+T ѡ"ת" 
4. ʹüͷѡת 
ĻͼĴС
1. ѡȡҪСĻͼ 
2.  Ctrl+1 ʾ"ʽ"˵Ȼ Ctrl+Tab ѡ"С"ѡ 
3. ѡҪСѡ 
ƶͼ
1. ѡȡҪƶĻͼ 
2. ͷƶ 
3. Ҫ΢ƶλã밴 Ctrl+ͷһΪλƶö
ƻͼ
Ҫͼĸѡȡö󲢰 Ctrl+DҪĳԣ磬ɫʽƵһִв
1. ѡȡҪƵԵĻͼ 
ںı"ѡͼ"ıʽһơ 
2.  Ctrl+Shift+C ɸƶԡ 
3.  Tab  Shift+Tab ѡȡҪиԵĶ 
4.  Ctrl+Shift+V ɽԸƵöС 
Excel̿ݼȫ(ʮ) 
ʼԵİ
ʹ"ʶ""ı"
Ctrl 
 ģʽдģʽ֮л 
Esc 
 ʶıʱֹͣʶ 
͵ʼ
ҪʹЩ͵ʼ뽫 Microsoft Outlook ΪĬϵĵʼ򡣴󲿷ְ Outlook Express
Shift+Tab 
 ѡеԪ A1 ʱƶʼе"˵"ʼУƶ"""ܼ"ʾ"""ռ"""ʾ򣬽ƶ"ܼ"ʾ"""ռ"""ͨѶȻƶԪ A1 
Alt+S 
 ͵ʼ 
Ctrl+Shift+B 
 "ͨѶ" 
Alt+O 
 "ѡ"˵ʹ"ѡ""ܼͿ""˿" 
Alt+P 
  Outlook "ʼѡ"Ի"ѡ"˵ϵ"ѡ" 
Alt+K 
 "ͨѶ"ݼ"ռ""""ܼ"еơ 
Alt+ 
 "ռ"е"ͨѶ" 
Alt+C 
 ""е"ͨѶ" 
Alt+B 
 ʾ"ܼ""ܼ"е"ͨѶ" 
Alt+J 
 ת"" 
Ctrl+Shift+G 
 ʼ־ 
Alt+A 
 ΪҪ͵ӽ 
ʹú
Alt+F8 
 ʾ""Ի 
Alt+F11 
 ʾ"Visual Basic ༭" 
Ctrl+F11 
  Microsoft Excel 4.0  
ʹö
Ctrl+ұߵ Shift 
 л"ҵ"䷽ıַֻ 
Ctrl+ߵ Shift 
 л""䷽ıַֻ 
Alt+Shift+ϼ 
 ʾƴϢԻıУָƶƴϢС 
Alt+Shift+¼ 
 ָƴϢƻظַС 
Num LockAlt+С̵ 
  Unicode ַ 
Alt+X 
 ڼ Unicode ַʮƴϼὫִתΪַ
 Unicode ַϼὫַתΪʮƴ롣



 ҲѾExcelɹϰŲ񱨱ҲExcelʵֹǧεĸ㣬ҲΪExcelҲˣ⡣ƽظĵӦֵʹ÷ֻExcelȫɵİٷ֮һרExcelеһЩΪ֪ļ֣һ¹Excelı顣 
       һòͬòͬɫʾ 
ڹʱУôڵ2000ԪĹܶԡɫʾڵ1500ԪĹܶԡɫʾ1000ԪĹܶԡɫʾԡɫʾǿá 
1.򿪡ʱѡСܶУִСʽʽ򿪡ʽԻ򡣵ڶҲťѡСڻڡѡںķֵ2000ʽť򿪡ԪʽԻ򣬽塱ġɫΪɫ 
2.ӡťĲú(ڵ1500ΪɫС1000Ϊɫ) 
3.ɺ󣬰¡ȷť 
ʱɣܶǲǰҪԲͬɫʾˡ 

       б 
ǳҪҵ뵽УΪ˱ƵһԣáЧԡܽһб 
1.Sheet2Уҵư(硰ҵҵҵҵҵ)ֱ벻ͬУһҵݿ⡣ 
2.ѡA(ҵҵ)ڡơڣ롰ҵҵַ󣬰سȷϡ 
ĲBCзֱΪҵҵҵ 
3.лSheet1УѡҪ롰ҵ𡱵(C)ִСݡЧԡ򿪡ЧԡԻڡáǩУҲťѡССѡġԴУ롰ҵҵҵҵҵ(Ԫ֮ӢĶŸ)ȷ˳ 
ѡҪҵƵ(D)ٴ򿪡ЧԡԻѡССѡڡԴ빫ʽ=INDIRECT(C1)ȷ˳ 
4.ѡCⵥԪ(C4)ҲťѡӦġҵ뵥ԪСȻѡиõԪӦDеԪ(D4)ťɴӦҵбѡҪҵõԪС 
ʾԺӡʱҪӡҵУѡиУһ꣬ѡءѡɡ 
ĵ²˵ 
ڲ˵½һĵ˵õĹĵӵУʱá 
1.ڹհ״һ꣬ѡԶ塱ѡ򿪡Զ塱ԻڡǩУѡСµġ²˵ٽġ²˵ϵ˵ 
ѡݡťڵ˵ġһ(硰ĵ) 
2.ڡѡһ(硰롱ѡ)ұߡѡһ(硰ӡѡ)ϵ²˵(ĵ)УĲ(硰ʱ)һĵбơ 
ظĲӼĵбơ 
3.ѡСĵ˵ĳ˵(硰ʱ)һ꣬ڵĿݲ˵Уѡ䳬ӡ򿪡ѡ򿪡䳬ӡԻͨҷΧҲťλӦĹ(硰.xls)ļУѡиùĵ 
ظĲ˵ӦĹĵ 
4.ԺҪ򿪡ĵ˵еĳĵʱֻҪչĵ˵еӦѡɡ 
ʾǽӡѡϵˡĵ˵УӰ조롱˵Сӡ˵͡áϵġ볬ӡťĹܡ 
ġרҵš 
ڱ༭רҵʱҪһЩרҵţΪ˷룬ǿһԼġרҵš 
1.ִСߡ¼ºꡱ򿪡¼ºꡱԻ?硰fuhao1?걣ڡ˺깤УȻȷʼ¼ơѡС¼ƺꡱϵġáťȻҪ뵽ĳԪУٵ¼ƺꡱϵġֹͣťɺ¼ơ 
Ĳһһ¼ƺŵ롰ꡱ 
2.򿪡Զ塱ԻڡǩУ½ť½Իơרҵšȷ󣬼ڹгһ 
лǩУѡСġꡱġԶ尴ťϵרҵš(жٸž϶ٸť) 
3.ѡһԶ尴ťյ2ؼĵ1ǽ 
4.һĳİť󵯳Ŀݲ˵Уѡָꡱѡ򿪡ָꡱԻѡӦĺ(fuhao1)ȷ˳ 
ظ˲ťӦĺ 
5.رաԶ塱ԻԺʹͨһʹáרҵšԪпרҵˡ 
塢áӡҳ 
еĹҪӡвͬáɡ 
1.ҪӡĹڲҪӡ()ѡһֵ꣬Ŀݲ˵УѡءѡҪӡ() 
2.ִСͼ򿪡Ի򣬵ӡť桱Իһ(硰ϱ)󣬵ȷť 
3.ص()ʾظӡĴӡ档 
4.ԺҪӡĳֱʱ򿪡ѡҪӡıƣʾť̰趨õĽʾáŰһ£¹ϵġӡťһоOKˡ 
ݰ 
ҪԱڵĲŽЩƼȵйϢǰƴ˳Ҳǰʻ˳ô?ɲԶ 
1.ִСʽѡ򿪡ѡԻ򣬽롰ԶСǩУڡСķ벿(硰,,һ,,䡱)ӡ͡ȷť˳ 
2.ѡСšһԪִСݡ򿪡򡱶Ի򣬵ѡťѡԻ򣬰еťѡиղԶУΡȷťأݾͰҪ 
               [url=http://b24.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ee7522fd02a3fc778c61987ce2ffa01ee635f8072d02a72f6e40309db31b3b18addbee5176ac5797f5aaf6fe1d5541f847b1b4ece66c7fe67c09999bd4d420c747df6dc9d][url=http://b24.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ee7522fd02a3fc778c61987ce2ffa01ee635f8072d02a72f6e40309db31b3b18addbee5176ac5797f5aaf6fe1d5541f847b1b4ece66c7fe67c09999bd4d420c747df6dc9d][/url][/url] 
ߡݳ 
ֵԪеݲ߲ģֻýˡ 
1.ѡҪݵĵԪ()ִСʽԪ򿪡ԪʽԻڡ֡ǩġࡱѡСԶ塱ѡȻұߡ͡ķ롰(Ӣ״̬µķֺ) 
2.лǩ£ѡеġءѡȷť˳ 
3.ִСߡ򿪡Իú󣬡ȷء 
ԺԪеݲʾʹExcel͸ҲΡ 
ʾڡǩ£벻Ҫǰ渴ѡеġšţԷֹɾݡ 
ˡСӢ뷨ܻس 
ڱ༭ʱеĵԪҪӢģеĵԪҪģл뷨ʵڲ㣬βһ£뷨ܻص? 
ѡҪĵĵԪִСݡЧԡ򿪡ЧԡԻл뷨ģʽǩ£ģʽҲťѡС򿪡ѡ󣬡ȷ˳ 
ԺѡҪĵĵԪһԪʱ뷨(뷨беĵ1뷨)Զ򿪣ѡԪʱ뷨Զرա 
šáԶͳһı 
ǲǾΪĳЩ̶ı硶Ա?Ǿ¿ɡ 
1.ִСߡԶ򿪡ԶԻ 
2.ڡ滻ķ롰pcw(ҲַpcwСд)ڡ滻Ϊķ롰Աٵӡ͡ȷť 
3.ԺҪıʱֻҪ롰pcwַ?ʱԲǡpcwĴСд?Ȼȷһ¾ͳˡ 
ʮExcelԶ庯 
ExcelȻḻǵҪǿԶһһЩض㡣棬ǾԶһĺ 
1.ִСߡVisual Basic༭˵(򰴡Alt+F11ݼ)Visual Basic༭ڡ 
2.ڴУִСģ顱˵һµģ顪ģ1 
3.ұߵġ봰ڡ´룺 
Function V(a,b,h)V = h*(a+b)/2End Function 
4.رմڣԶ庯ɡ 
ԺʹúһʹԶ庯 
ʾ淽ԶĺֻͨӦĹʹá 
ʮһͷͼƬ 
Ϊӵıǳģֻܲڱͷ? 
1.ִСʽ򿪡ԻѡҪΪͼƬ󣬰¡롱ťͼƬ档 
2.ڰסCtrlͬʱڲҪͼƬĵԪ()ͬʱѡЩԪ() 
3.ʽϵġɫҲťֵġɫ塱УѡСɫԺµĵԪͼƬѡеĵԪ()ûгͼƬ(ʵͼƬɫڸ) 
ʾ?ڵԪͼƬǲִ֧ӡġ 
ʮַ&ϲı 
뽫еݺϲһУҪúһССַ&ܽ㶨(˴ٶBCDкϲһ) 
1.Dк(EF)ȻD1Ԫ빫ʽ=B1&C1&D1 
2.ٴѡD1ԪáʽƵDĵԪУBCDеݼϲEжӦĵԪС 
3.ѡEУִСơȻѡFУִС༭ѡճ򿪡ѡճԻѡеġֵѡ¡ȷťEе(ǹʽ)ƵFС 
4.BCDEɾɺϲ 
ʾɵ12ĲϲЧѾʵ֣ʱɾBCDУʽִ󡣹е3ʽתΪġֵ 

                   [url=http://b23.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ee51ceb02adf7a5e8327da9609da0384544823662d67bf8fcccbf1873799613bf44c2a2b2a6e5b3eb50e86e336b14b2a2c0a215f4c843d5bcccb54705a59439fa357f6dab][url=http://b23.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ee51ceb02adf7a5e8327da9609da0384544823662d67bf8fcccbf1873799613bf44c2a2b2a6e5b3eb50e86e336b14b2a2c0a215f4c843d5bcccb54705a59439fa357f6dab][/url][/url]
ɼ 
ʡδӡɼ⣬в˲ȡ¼ƺVBAķʵ֣ڳѧ˵һѶȡڴֿǣһúʵֵļ㷽 
˴ٶѧɼSheet1A1G64ԪУе1Ϊ⣬2Ϊѧơ 
1.лSheet2УѡA1Ԫ빫ʽ=IF(MOD(ROW()3)=0壬IF(0MOD?ROW()3(=1sheet1AINDEX(sheet1$A$GINT(((ROW()+4)/3)+1)COLUMN()))) 
2.ٴѡA1ԪáʽƵB1G1ԪУȻͬʱѡA1G1ԪáʽƵA2G185ԪС 
ˣɼͣһ¡ 
3.иߺпͬʱѡA1G2Ԫ(1λѧĳɼ)ʽ߿Ҳťֵı߿бУѡСпߡѡΪѡеӱ߿(Ҫ߿򣬿Բд˲Ĳ) 
4.ͬʱѡA1G3Ԫ򣬵áϵġʽˢťȻסA4G186ԪΪеĳɼӱ߿ 
ӡťɽɼӡ 
ʮġExcelѡ 
úʱ֪ʹʲôȽϺʡExcelġܿ԰СΧѡʵĺ 
ִС򿪡뺯ԻڡķҪ(硰)Ȼ󵥻תťϵͳ̽롰йصĺѡʾڡѡбСٽϲ鿴صİļɿȷҪĺ 
ʮ塢ͬʱ鿴ͬжԪڵ 
ʱǱ༭ĳ(Sheet1)ʱҪ鿴(Sheet2Sheet3)ĳԪݣExcelġӴڡʵ֡ 
ִСͼӴڡ򿪡ӴڡеġӼӡťչӼӵ㡱ԻѡҪ鿴ĵԪٵӡťظǰӵ㡱 
ԺĸУֻҪ򿪡Ӵڡɲ鿴бӵ㵥ԪڵݺϢ 
ʮΪԪٻ߿ 
Excel 2002ǰİ汾УΪԪӱ߿ĲȽ鷳Excel 2002Դ˹ܽȫµչ 
ʽϡ߿Ҳť󵯳бУѡͼ߿ѡִСͼ߿չ߿򡱹 
ťѡһֱ߿ʽȻҪӱ߿ĵԪΪӦĵԪٻϱ߿ 
ʾ˱߿ûϵѡйϵġ߿򡱰ťȻڴı߿һ£Ϳı߿򡣢Ҫͬɫı߿򣬿ȰҲġɫť󵯳ĵɫѡҪɫٻ߿򼴿ɡһܻڵԪл϶Խǵбߡ 



                    [url=http://b24.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ec70095d9b73387df5bd5fbca497bf1101d46fffe1c4dc5120136606d789715fc96b11bf98712f1aecee4c12bce92d93b5d22d00225e5c578266a98ebefe8466373f93ce4][url=http://b24.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33ec70095d9b73387df5bd5fbca497bf1101d46fffe1c4dc5120136606d789715fc96b11bf98712f1aecee4c12bce92d93b5d22d00225e5c578266a98ebefe8466373f93ce4][/url][/url]
ʮߡضԪıĳ 
ڸλĵԪȴһλڸֵĵԪȴֵʱExcelԶжϡʱ棬Ǹöð!ҪʵһܣExcel˵Ҳѡ 
ǽ궨λһǼǡݡĵԪУΪͳһͼķ㣬ϣݡһλʾԣǿԵݡ˵ġЧԡѡڡáƬЧġ˵ѡıȡȻڡݡ˵ѡ񡰵ڡҡȡΪ4ͬʱ桱ƬУЧʱʾĳ桱Ϊֹͣڡ⡱͡Ϣзֱ롰ıǷ!͡λݡ 
ȻڸõԪĲһλʱExcelͻᵯʾľԻ򣬸ԭ򣬲ֱȷʽֵ󷽿ɼ¼롣?ʵExcelġЧԡжУ͵ݸʽѡ硰ı͡дСʱԶȤβţԼһּ׼ExcelչʾڲͬĹء 
ʮˡűĹ̶Ԫ 
֪ÿδExcelĬϴ򿪶Źɴ˾ͿɿExcelӵǿĵűĴʺڶ໥ıЭҪЭȻȾҪͬ롣ˣںܶ£ҪͬʱڶűͬԪͬݡ 
ôζԱг༭?ǵһıǩSheet1ȻסShiftһűıǩSheet3(ıһ𣬿԰סCtrlеѡ)ʱǿExcelıϵƳˡ顱ǾͿԽжԹı༭ˡҪһűݵĵԪдʲôǷ֣顱бͬһλöʾӦˡ 
ǣͬԶԶġ磬Ҫűͬλõͳһıʽô?ȣǵøıһűݸʽٵ༭˵ġ䡱ѡȻӲ˵ѡͬ鹤ʱExcelᵯ鹤ĶԻѡ񡰸ʽһ㡰ȷͬбλõݸʽıˡ 
ʮšııĴСд 
ExcelУΪṩǿֵ֧ĲǹʽҲݿ⣬ǺҪΪExcelеĺֻ֣ʵֻҪдеݣExcelж༭⺯ııĴСд 
Excel 2002УṩйıСдתĺǷֱǣ=UPPER(Դݸ)ıȫתΪд=LOWER(Դݸ)ıȫתСд=PROPER(Դݸ)ıתɡʵĴСдÿʵĸΪдȡ磬һűA1ԪСдġexcelȻĿ굥Ԫ롰=UPPER(A1)سõĽǡEXCELͬA3Ԫ롰mr.weiweiȻĿ굥Ԫ롰=PROPER(A3)ôǵõĽͽǡMr.Weiweiˡ 
ʮȡַеضַ 
ֱ⣬ѴڵĵԪȡضַ룬һʡʱʡµķرǶһЩʽͬϢˣԱϢ 
ٴA4ԪȡνĻʹá=RIGHT(Դݸȡַ)ʾA4ԪҲַʼȡ2ַ뵽λáȻȡĻҪʹá=LEFT(Դݸȡַ)ˡһǲ˿ʼֱӴмȡַҪA5Ԫȡ人ʱֻĿ굥Ԫ롰=MID(A5,4,2)Ϳˡ˼ǣA5Ԫȡ4ַַҲǵ4͵5֡
ʮһѻתʡӢĵĻתһȽϸӵ⡣Ϊûһʮ̶ֹģʽڱʶʹõġth׺ԡ123βȴֱԡstnd͡rdβġң1112133ֲһȴȻԡthβġˣʵƺܸӡʵֻҪ˼·׼ֻдһʽͿתˡţ뿴=A2&IF(OR(VALUE(RIGHT(A2,2))={11,12,13}),th,IF(OR(VALUE(RIGHT(A2))={1,2,3,},CHOOSE(RIGHT(A2),st,nd,rd),th))ùʽһȴȷԡ111213βģϡth׺1ԭЧһ֣ԡ1βʹástԡ2βʹándԡ3βʹárd12ԭЧôáthˣʺʵתʵֵɺͿݡ
ʮŲλ
Ͳ˶֪ʱһԼ׳ɵġȫдǾǽеĿλ룬ڿݵǰϡ$֮ķšʵExcelҲƵ뷽ǾǡREPTĻʽǡ=REPT(šλ)
磬ҪA2Ԫֽβá#16λֻ뽫ʽΪ=(A2&REPT(#,16-LEN(A2)))ɣҪA3Ԫеִá#16λҪΪ=REPT(#,16-LEN(A3)))&A3⣬á#ŽA4еֵ䣬ҪΪ=REPT(#,8-LEN(A4)/2)&A4&REPT(#)8-LEN(A4)/2)㻹ӲרҵҪA5ԪֵĶͷϡ$ŵĻǾ͸Ϊ=(TEXT(A5,$#,##0.00(&REPT(#,16-LEN(TEXT(A5,$#,##0.00))))һҪ
ʮıֱͼ
ظ֮⣬REPTһӦþǿֱڹдɴıɵֱͼԭҲܼ򵥣ŵظָԪеļֳ̲һıȽЧ
һ֧ƽȻ󽫡EСΪֱͼСԤڡ·ݵʾGСΪֱͼСԤ㡱ʾȻݱнDСֵáWingdingsġNֳַ岽£
E3Ԫд빫ʽ=IF(D30,REPT(n,ROUND(D3*100,0)),)Ҳ϶G14ǿһûжExcelͼܵĴıֱͼչǰֱۣˡ
ʮġ㵥Ԫе
ʱǿܶĳԪַȤҪ㵥ԪеҪ⣬õSUBSTITUTE⣬ҪáTRIMɾո񡣱A1ԪСhow many words?ôǾͿµıʽæ
=IF(LEN(A1)=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),,,))+1)
ʽĺáSUBSTITUTEһַáTRIMɾַĿոȻַԭַλӶóո񡱵󽫿ո+1͵óԪַˡ
ʮ塢ŷԪת
Excel 2002е¹ߡڰװExcel 2002ʱѡĬϷʽôܿܲڡߡ˵ҵǿѡ񡰹ߡ˵еġغꡱȻڵйѡŷԪߡѡȷExcel 2002ͻаװˡ
ɺٴδ򿪡ߡ˵ŷԪתһרŷԪŷ˳ԱתĴھͳˡExcelһǿͨûתġԴ򡱺͡Ŀ򡱣ȻѡתǰĲּͬɡʾľǡ100ŷԪֱתŷ˳ԱҵıȼһȻΪʹŷԪʾרҵǻԵExcelϵġŷԪťתĻֵŷԪʽˡ


                 [url=http://b23.photo.store.qq.com/http_imgload.cgi?/rurl4_b=cbea9c4f45a9aca91d47cd434453f33e3d9365b5ee270ef523bb545f90841a79cc5745f37187efe6f524173a5a38d059b284713860e22c3072afef8904c9f8c8b77290f7f3269c854e35ecd52cdf5438e61033f8