Ctrl+Shift+Spacebar Ͽո 
Ctrl+ַ ַ 
Ctrl+B ʹַΪ 
Ctrl+I ʹַΪб 
Ctrl+U Ϊַ» 
Ctrl+Shift+< Сֺ 
Ctrl+Shift+> ֺ 
Ctrl+Q ɾʽ 
Ctrl+Spacebar ɾַʽ 
Ctrl+C ѡı 
Ctrl+X ѡı 
Ctrl+V ճı 
Ctrl+Z һ 
Ctrl+Y ظһ 



F1  Office  
F2 ƶֻͼ 
F3 Զͼļ Word ʾô֮ 
F4 ظһ 
F5 ѡ񡰱༭˵еġλ 
F6 ǰһ 
F7 ѡ񡰹ߡ˵еġƴд﷨ 
F8 չѡ 
F9 ѡ 
F10 ˵ 
F11 ǰһ 
F12 ѡļ˵еġΪ 




Shift+ܼ 

Shift+F1 ϼ ذʾʽ 
Shift+F2 ϼ ı 
Shift+F3 ϼ ıĸСд 
Shift+F4 ϼ ظҡ򡰶λ 
Shift+F5 ϼ ƶһ޶ 
Shift+F6 ϼ ǰһ 
Shift+F7 ϼ ѡͬʿ⡱λڡߡ˵ġԡӲ˵У 
Shift+F8 ϼ Сѡ 
Shift+F9 ϼ ֮л 
Shift+F10 ϼ ʾݲ˵ 
Shift+F11 ϼ ǰһ 
Shift+F12 ϼ ѡļ˵ϵġ桱 




Ctrl+ܼ 

Ctrl+F2 ϼ ѡļ˵ϵġӡԤ 
Ctrl+F3 ϼ ͼĳ 
Ctrl+F4 ϼ رմ 
Ctrl+F5 ϼ ԭĵĵС 
Ctrl+F6 ϼ ǰһ 
Ctrl+F7 ϼ ѡ񡰿ơ˵ϵġƶ 
Ctrl+F8 ϼ ѡ񡰿ơ˵ϵġС 
Ctrl+F9 ϼ  
Ctrl+F10 ϼ ĵ 
Ctrl+F11 ϼ  
Ctrl+F12 ϼ ѡļ˵ϵġ򿪡 




Ctrl+Shift+ܼ 

Ctrl+Shift+F3 ϼ ͼĳ 
Ctrl+Shift+F5 ϼ ༭ǩ 
Ctrl+Shift+F6 ϼ ǰһ 
Ctrl+Shift+F7 ϼ  Word ԴĵӵϢ 
Ctrl+Shift+F8 ϼ չѡ飨Ȼ󰴼ͷ 
Ctrl+Shift+F9 ϼ ȡ 
Ctrl+Shift+F10 ϼ  
Ctrl+Shift+F11 ϼ ȡ 
Ctrl+Shift+F12 ϼ ѡļ˵ϵġӡ 




Alt+ܼ 

Alt+F1 ϼ ǰһ 
Alt+F3 ϼ Զͼļ 
Alt+F4 ϼ ˳ Word 
Alt+F5 ϼ ԭ򴰿ڴС 
Alt+F7 ϼ һƴд﷨ѡСʱƴдѡ򣬸øѡλڡߡ˵ѡԻġƴд﷨ѡϡ 
Alt+F8 ϼ к 
Alt+F9 ϼ ǵĽ֮л 
Alt+F10 ϼ 򴰿 
Alt+F11 ϼ ʾ Microsoft Visual Basic  




Alt+Shift+ܼ 

Alt+Shift+F1 ϼ ǰǰһ 
Alt+Shift+F2 ϼ ѡļ˵еġ桱 
Alt+Shift+F9 ϼ ʾ Gotobutton  Macrobutton 
Alt+Shift+F11 ϼ ʾ Microsoft Visual Studio  




Ctrl+Alt+ܼ 

Ctrl+Alt+F1 ϼ ʾ Microsoft ϵͳϢ 
Ctrl+Alt+F2 ϼ ļ˵еġ򿪡 

ֺͼεĿݼ 

ıֺ 

Ctrl+Shift+F ϼ ı 
Ctrl+Shift+P ϼ ıֺ 
Ctrl+Shift+> ϼ ֺ 
Ctrl+Shift+< ϼ Сֺ 
Ctrl+] ϼ ֺ 
Ctrl+[ ϼ Сֺ 

Ӧַʽ 

Ctrl+D ϼ ıַʽʽ˵еġ塱 
Shift+F3 ϼ ıĸСд 
Ctrl+Shift+A ϼ ĸΪд 
Ctrl+B ϼ ӦüӴָʽ 
Ctrl+U ϼ Ӧ»߸ʽ 
Ctrl+Shift+W ϼ ֻ֡ʼ»ߣո» 
Ctrl+Shift+D ϼ ˫» 
Ctrl+Shift+H ϼ Ӧָʽ 
Ctrl+I ϼ Ӧбʽ 
Ctrl+Shift+K ϼ ĸСд 
Ctrl+=Ⱥţϼ Ӧ±ʽԶࣩ 
Ctrl+Shift++Ӻţϼ ӦϱʽԶࣩ 
Ctrl+Shift+Z ϼ ȡ˹õַʽ 
Ctrl+Shift+Q ϼ ѡΪ Symbol  

鿴͸ָʽ 

Ctrl+Shift+*Ǻţϼ ʾǴӡַ 
Shift+F1 ϼȻ󵥻˽ʽ֣ 鿴ָʽ 
Ctrl+Shift+C ϼ Ƹʽ 
Ctrl+Shift+V ϼ ճʽ 

о 

Ctrl+1 ϼ о 
Ctrl+2 ϼ ˫о 
Ctrl+5 ϼ 1.5 о 
Ctrl+0 ϼ ڶǰһм 

ö뷽ʽ 

Ctrl+E ϼ  
Ctrl+J ϼ ˶ 
Ctrl+L ϼ  
Ctrl+R ϼ Ҷ 
Ctrl+M ϼ  
Ctrl+Shift+M ϼ ȡ 
Ctrl+T ϼ  
Ctrl+Shift+T ϼ С 
Ctrl+Q ϼ ȡʽ 

Ӧöʽ 

Ctrl+Shift+S ϼ Ӧʽ 
Alt+Ctrl+K ϼ Զøʽ 
Ctrl+Shift+N ϼ Ӧáġʽ 
Alt+Ctrl+1 ϼ Ӧá 1ʽ 
Alt+Ctrl+2 ϼ Ӧá 2ʽ 
Alt+Ctrl+3 ϼ Ӧá 3ʽ 
Ctrl+Shift+L ϼ Ӧáбʽ 

ɾֺͼ 

Backspace  ɾһַ 
Ctrl+Backspace ϼ ɾһ 
Delete  ɾҲһַ 
Ctrl+Delete ϼ ɾҲһ 
Ctrl+X ϼ ѡּе塱 
Ctrl+Z ϼ һ 
Ctrl+F3 ϼ ͼĳ 

ƺƶּͼ 

Ctrl+C ϼ ֻͼ 
 Ctrl+C ϼ ʾ塱 
F2Ȼƶ㲢 Enter  ƶֻͼ 
Alt+F3 ϼ Զͼļ 
Ctrl+V ϼ ճ塱 
Ctrl+Shift+F3 ϼ ճͼĳ 
Alt+Shift+R ϼ ĵһʹõҳüҳ 

ַ 

Ctrl+F9 ϼ  
Enter 롰ԶͼļƵǰַ󣬳Ļʾʱ Զͼļ 
Shift+Enter ϼ з 
Ctrl+Enter ϼ ҳ 
Ctrl+Shift+Enter ϼ зָ 
Ctrl+-ַϼ ѡַ 
Ctrl+Shift+-ַϼ ַ 
Ctrl+Shift+ո ϼ Ͽո 
Alt+Ctrl+C ϼ Ȩ 
Alt+Ctrl+R ϼ ע̱ 
Alt+Ctrl+T ϼ ̱ 
Alt+Ctrl+.㣩ϼ ʡԺ 

ѡֺͼ 
ѡıķǣס Shift ܹƶļ 


Shift+Ҽͷ Ҳһַ 
Shift+ͷ һַ 
Ctrl+Shift+Ҽͷ ʽβ 
Ctrl+Shift+ͷ ʿʼ 
Shift+End ϼ β 
Shift+Home ϼ  
Shift+¼ͷ һ 
Shift+ϼͷ һ 
Ctrl+Shift+¼ͷ β 
Ctrl+Shift+ϼͷ  
Shift+Page Down ϼ һ 
Shift+Page Up ϼ һ 
Ctrl+Shift+Home ϼ ĵʼ 
Ctrl+Shift+End ϼ ĵβ 
Alt+Ctrl+Shift+Page Down ϼ ڽβ 
Ctrl+A ϼ ƪĵ 
Ctrl+Shift+F8 ϼȻʹüͷ Esc ȡѡģʽ ı 
F8+ͷ Esc ȡѡģʽ ĵеĳλ 


ʾ ֪ƶİϣôһҲڰס Shift ͬʱͬİѡ֡磬 Ctrl+Ҽͷɽһʣ Ctrl+Shift+ҼͷѡӲ㵽һʴ׼֡ 


ѡеֺͼ 

Tab  ѡһԪ 
Shift+Tab ϼ ѡһԪ 
ס Shift ظĳͷ ѡչڵԪ 
еĵһһԪ񡣰ס Shift ظϼͷ¼ͷ ѡ 
Ctrl+Shift+F8 ϼȻüͷ Esc ȡѡģʽ չѡݣ飩 
Shift+F8 ϼ Сѡ 
Alt+ּϵ 5 Num Lock 账ڹر״̬ ѡű 




չѡ 

F8  չģʽ 
F8 Ȼ밴ͷҼͷ ѡڵַ 
F8 밴һѡһʣ밴ѡһӣƣ ѡ 
Shift+F8 ϼ ѡ 
Esc  رչģʽ 

ƶ 
밴 ִв 
ͷ һַ 
Ҽͷ һַ 
Ctrl+ͷ һ 
Ctrl+Ҽͷ һ 
Ctrl+ϼͷ һ 
Ctrl+¼ͷ һ 
Shift+Tab ϼ һԪڱУ 
Tab һԪڱУ 
ϼͷ һ 
¼ͷ һ 
End  β 
Home   
Alt+Ctrl+Page Up ϼ ڶ 
Alt+Ctrl+Page Down ϼ ڽβ 
Page Up  һ 
Page Down  һ 
Ctrl+Page Down ϼ ҳ 
Ctrl+Page Up ϼ ҳ 
Ctrl+End ϼ ĵβ 
Ctrl+Home ϼ ĵͷ 
Shift+F5 ϼ ǰһ޶ 
Shift+F5 ϼ һιرĵʱλ 




ڱƶ 

Tab  һеһԪ 
Shift+Tab ϼ һеһԪ 
Alt+Home ϼ һеĵһԪ 
Alt+End ϼ һеһԪ 
Alt+Page Up ϼ һеĵһԪ 
Alt+Page Down ϼ һеһԪ 
ϼͷ һ 
¼ͷ һ 

ڱвƱ 
밴 ڵԪв 
Enter  ¶ 
Ctrl+Tab ϼ Ʊ 

鿴ͱĵ 

Ctrl+N ϼ 뵱ǰʹùĵͬĵ 
Ctrl+O ϼ ĵ 
Ctrl+W ϼ رĵ 
Alt+Ctrl+S ϼ ĵ 
Alt+Shift+C ĵ 
Ctrl+S ϼ ĵ 

ҡ滻ı 
밴 ִв 
Ctrl+F ϼ ֡ʽ 
Alt+Ctrl+Y ϼ ظңڹرաҺ滻֮ 
Ctrl+H ϼ 滻֡ʽ 
Ctrl+G ϼ λҳǩעע͡ͼλλ 
Alt+Ctrl+Z ϼ ҳǩעעͼλλ 
Alt+Ctrl+Home ϼ ĵ 

ͻָ 

Esc  ȡ 
Ctrl+Z ϼ  
Ctrl+Y ϼ ָظ 

лͼ 
밴 ִв 
Alt+Ctrl+P ϼ лҳͼ 
Alt+Ctrl+O ϼ лͼ 
Alt+Ctrl+N ϼ лͨͼ 
Ctrl+\ ϼ ĵĵ֮ƶ 

ĵĿݼ 
Ҫ󻯣밴 Alt+ոȻ X Ҫôڻԭǰĳߴλã밴 Alt+ոȻ R Ҫӡ⣬밴 Ctrl+P ϼ 

Alt+Ctrl+M ϼ ע 
Ctrl+Shift+E ϼ 򿪻رձ޶ 
Home λעʼ 
Ene λעβ 
Ctrl+Home ϼ λһעʼ 
Ctrl+End ϼ λһעĽβ 

ڴáעβעĿݼ 

Alt+Shift+O ϼ Ŀ¼ 
Alt+Shift+I ϼ Ŀ¼ 
Alt+Ctrl+X ϼ  
Alt+Ctrl+F ϼ ע 
Alt+Ctrl+D βע 

ڴĿݼ 

Alt+Shift+D ϼ Date  
Alt+Ctrl+L ϼ Listnum  
Alt+Shift+P ϼ Page  
Alt+Shift+T ϼ Time  
Ctrl+F9 ϼ  


Ctrl+Shift+F7 ϼ  Word ԴĵеϢ 
F9  ѡ 
Ctrl+Shift+F9 ϼ  
Shift+F9 ϼ ֮л 
Alt+F9 ϼ е뼰л 
Alt+Shift+F9 ϼ ʾ Gotobutton  Macrobutton 
F11  λһ 
Shift+F11 ϼ λǰһ 
Ctrl+F11 ϼ  
Ctrl+Shift+F11 ϼ 

EXcelݼȫ
1>ݼ֮ڹƶ͹ϡ¡ƶԪͷ 
ƶǰıԵCTRL+ ͷ 
ƶףHOME 
ƶĿͷCTRL+HOME 
ƶһԪ񡣣CTRL+END 
ƶһPAGE DOWN 
ƶһPAGE UP 
ƶһALT+PAGE DOWN 
ƶһALT+PAGE UP 
ƶһCTRL+PAGE DOWN 
ƶǰһCTRL+PAGE UP 
ƶһ򴰿ڣCTRL+F6  CTRL+TAB 
ƶǰһ򴰿ڣCTRL+SHIFT+F6 
ƶѲֹеһF6 
ƶֵĹеһSHIFT+F6 
ʾԪCTRL+BACKSPACE 
ʾλԻF5 
ʾҡԻSHIFT+F5 
ظһΡҡSHIFT+F4 
ڱеķԪ֮ƶTAB 


2>Excelݼ֮ENDģʽʱڹƶ 
򿪻ر END ģʽEND 
һлݿΪλƶEND, ͷ 
ƶһԪ.END, HOME 
ڵǰƶһǿհ׵Ԫ񡣣END, ENTER 

3>Excelݼ֮ڡģʽʱڹƶ 
򿪻رչSCROLL LOCK 
ƶϽǴĵԪHOME 
ƶ½ǴĵԪEND 
ϻ¹һУϼͷ¼ͷ 
ҹһУͷҼͷ 

4>Excelݼ֮Ԥʹӡĵ 
ʾӡԻCTRL+P 
ڴӡԤʱ 
Ŵʾʱĵƶͷ 
СʾʱĵÿιһҳPAGE UP 
СʾʱһҳCTRL+ϼͷ 
СʾʱһҳCTRL+¼ͷ 

5>Excelݼ֮ڹͼͺ 
¹SHIFT+F11 
ʹõǰͼF11  ALT+F1 
ʾꡱԻALT+F8 
ʾVisual Basic ༭ALT+F11 
 Microsoft Excel 4.0 깤CTRL+F11 
ƶеһCTRL+PAGE DOWN 
ƶеһCTRL+PAGE UP 
ѡеǰһSHIFT+CTRL+PAGE DOWN 
ѡǰһSHIFT+CTRL+PAGE UP 

6>Excelݼ֮ѡͼ 
ѡеһŹCTRL+PAGE DOWN 
ѡеһCTRL+PAGE UPEND, SHIFT+ENTER 

7>Excelݼ֮ڹ 
ɵԪ벢ѡƣENTER 
ڵԪУALT+ENTER 
õǰѡĵԪCTRL+ENTER 
ɵԪ벢ѡƣSHIFT+ENTER 
ɵԪ벢ѡƣTAB 
ɵԪ벢ѡƣSHIFT+TAB 
ȡԪ룺ESC 
ɾߵַɾѡBACKSPACE 
ɾұߵַɾѡDELETE 
ɾ㵽ĩıCTRL+DELETE 
ƶһַͷ 
ƵףHOME 
ظһβF4  CTRL+Y 
༭ԪעSHIFT+F2 
лб־ƣCTRL+SHIFT+F3 
䣺CTRL+D 
䣺CTRL+R 
ƣCTRL+F3 

8>Excelݼ֮ݸʽ 
ʾʽԻALT+' Ʋţ 
ʾԪʽԻCTRL+1 
Ӧá桱ָʽCTRL+SHIFT+~ 
ӦôСλġҡʽCTRL+SHIFT+$ 
ӦòСλġٷֱȡʽ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+) 

9>Excelݼ֮༭ 
༭Ԫ񲢽õĩβF2 
ȡԪ༭еESC 
༭ԪԭеݣBACKSPACE 
ճʽУF3 
ɵԪ룺ENTER 
ʽΪ鹫ʽ룺CTRL+SHIFT+ENTER 
ڹʽм뺯֮ʾʽѡ壺CTRL+A 
ڹʽм뺯ΪúţCTRL+SHIFT+A 
ʾƴд顱Ի򡣣F7  

10>Excelݼ֮롢ɾ͸ѡ 
ѡCTRL+C 
ѡCTRL+X 
ճѡCTRL+V 
ѡݣDELETE 
ɾѡCTRL+ ַ 
һβCTRL+Z 
հ׵ԪCTRL+SHIFT+ Ӻ 

11>Excelݼ֮ѡƶ 
ѡƶENTER 
ѡƶSHIFT+ENTER 
ѡƶTAB 
ѡƶSHIFT+TAB 
˳ʱ뷽ƶѡһǣCTRL+PERIOD 
ƵڵѡCTRL+ALT+Ҽͷ 
ƵڵѡCTRL+ALT+ͷ 

12>Excelݼ֮ѡԪл 
ѡǰԪΧCTRL+SHIFT+*Ǻţ 
ѡչһԪȣSHIFT+ ͷ 
ѡչԪͬͬеǿյԪCTRL+SHIFT+ ͷ 
ѡչףSHIFT+HOME 
ѡչĿʼCTRL+SHIFT+HOME 
ѡչһʹõĵԪCTRL+SHIFT+END 
ѡУCTRL+SPACEBAR 
ѡУSHIFT+SPACEBAR 
ѡCTRL+A 
ѡ˶ԪֻѡеĵԪSHIFT+BACKSPACE 
ѡչһSHIFT+PAGE DOWN 
ѡչһSHIFT+PAGE UP 
ѡһѡϵжCTRL+SHIFT+SPACEBAR 
ضʾռλ֮лCTRL+6 
ʾءáCTRL+7 
ʹüͷչѡĹܣF8 
еĵԪӵѡУSHIFT+F8 
ѡչϽǵĵԪSCROLLLOCK, SHIFT+HOME 
ѡչ½ǵĵԪSCROLLLOCK, SHIFT+END 

13>Excelݼ֮Endģʽʱչѡ 
򿪻ر END ģʽEND 
ѡչԪͬͬеǿյԪEND, SHIFT+ ͷ 
ѡչϰݵһԪEND, SHIFT+HOME 
ѡչǰеһԪEND, SHIFT+ENTER 

14>Excelݼ֮ѡַԪ 
ѡлԪΧĵǰCTRL+SHIFT+*Ǻţ 
ѡеǰ飬ǻԪ飺CTRL+/ 
ѡдעĵԪCTRL+SHIFT+O (ĸ O) 
ѡвڻԪֵƥĵԪCTRL+ 
ѡвڻԪֵƥĵԪCTRL+SHIFT+| 
ѡǰѡйʽֱõԪCTRL+[ ţ 
ѡǰѡйʽֱӻõеԪCTRL+SHIFT+{  
ֻѡֱõǰԪĹʽڵĵԪCTRL+] ҷţ 
ѡдйʽĵԪЩʽֱӻõǰԪCTRL+SHIFT+}Ҵ