boyxin
Members actively
- Tham gia
- 10/3/08
- Bài viết
- 1,664
- Được thích
- 2,335
Excel Keyboard Shortcuts
Stt
|
Key
|
Alone
|
Shift
|
Ctrl
|
Alt
|
Shift Ctrl
|1
|F1|Help|What's This Help| |Insert Chart Sheet| |2
|F2|Edit Mode|Edit Comment| |Save As| |3
|F3|Paste Name Formula|Paste Function|Define Name| |Names From Labels|4
|F4|Repeat Action|Find Again|Close Window|Quit Excel| |5
|F5|Goto|Find|Restore Window Size| | |6
|F6|Next Pane|Prev Pane|Next Workbook|Switch To VBA|Prev Workbook|7
|F7|Spell Check| |Move Window| | |8
|F8|Extend Selection|Add To Selection|Resize Window|Macro List| |9
|F9|Calculate All|Calculate Worksheet|Minimize Workbook| | |10
|F10|Activate Menu|Context Menu|Restore Workbook| | |11
|F11|New Chart|New Worksheet|New Macro Sheet|VB Editor| |12
|F12|Save As|Save|Open| |Print|13
|A| | |Select All | |Formula Arguments|14
|B| | |Bold| | |15
|C| | |Copy| | |16
|D| | |Fill Down|Data Menu| |17
|E| | | |Edit Menu| |18
|F| | |Find|File Menu|Font Name|19
|G| | |Goto| | |20
|H| | |Replace|Help Menu| |21
|I| | |Italics|Insert Menu| |22
|K| | |Insert Hyperlink| | |23
|N| | |New Workbook| | |24
|O| | |Open Workbook|Format Menu|Select Comments|25
|P| | |Print| |Font Size|26
|R| | |Fill Right| | |27
|S| | |Save| | |28
|T| | | |Tools Menu| |29
|U| | |Underline| | |30
|V| | |Paste| | |31
|W| | |Close Workbook|Window Menu| |32
|X| | |Cut| | |33
|Y| | |Repeat Active| | |34
|Z| | |Undo| | |35
|` (~)| | |Toggle Formula View| |General Format|36
|1 (!)| | |Cell Format| |Number Format|37
|2 (@)| | |Toggle Bold| |Time Format|38
|3 (#)| | |Toggle Italics| |Date Format|39
|4 ($)| | |Toggle Underline| |Currency Format|40
|5 (%)| | |Toggle Strikethru| |Percent Format|41
|6 (^)| | |a| |Exponent Format|42
|7 (&)| | |a| |Apply Border|43
|8 (*)| | |Outline| |Select Region|44
|9 (()| | |Hide Rows| |Unhide Rows|45
|0 ())| | |Hide Columns| |Unhide Columns|46
|-| | |Delete Selection|Control Menu|No Border|47
|= (+)|Formula| | |Auto Sum|Insert dialog|48
|[| | |Direct Dependents| |Direct Precedents|49
|]| | |All Dependents| |All Precedents|50
|; (semicolon)| | |Insert Date|Select Visible Cells|Insert Time|51
|' (apostrophe)| | | |Style|Copy Cell Value Above|52
|: (colon)| | |Insert Time| | |53
|/| | |Select Array| |Select Array|54
|\| | |Select Differences| |Select Unequal Cells|55
|Insert|Insert Mode| |Copy| | |56
|Delete|Clear| |Delete To End Of Line| | |57
|Home|Begin Row| |Start Of Worksheet| | |58
|End|End Row| |End Of Worksheet| | |59
|Page Up|Page Up| |Previous Worksheet|Left 1 screen| |60
|Page Down|Page Down| |Next Worksheet|Right 1 screen| |61
|Left Arrow|Move Left|Select Left|Move Left Area| | |62
|Right Arrow|Move Right|Select Right|Move Right Area| | |63
|Up Arrow|Move Up|Select Up|Move Up Area| | |64
|Down Arrow|Move Down|Select Down|Move Down Area|Drop down list| |65
|Space Bar|Space|Select Row|Select Column|Control Box|Select All|66
|Tab|Move Right|Move Left|Next Window|Next Application|Previous Window|67
|BackSpace| | |Goto Active Cell| | |
