Excels Keyboard Shortcuts
Excels Keyboard Shortcuts Shortcut key Action Menu equivalent comments Ctrl+A Select All Ctrl+B Bold Ctrl+C Copy Ctrl+D Fill Down Ctrl+F Find Ctrl+G Goto Ctrl+H Replace Ctrl+I Italic Ctrl+K Insert Hyperlink Ctrl+N New Workbook Ctrl+O Open Ctrl+P Print Ctrl+R Fill Right Ctrl+S Save Ctrl+U Underline Ctrl+V Paste Ctrl W Close Ctrl+X Cut Ctrl+Y Repeat Ctrl+Z Undo F1 Help F2 Edit F3 Paste Name F4 Repeat last action F4 While typing a formula, switch between absolute/relative refs F5 Goto F6 Next Pane F7 Spell check F8 Extend mode F9 Recalculate all workbooks F10 Activate Menubar F11 New Chart F12 Save As Ctrl+: Insert Current Time Ctrl+; Insert Current Date Ctrl+" Copy Value from Cell Above Ctrl+' Copy Fromula from Cell Above Shift Hold down shift for additional functions in Excel's menu Shift+F1 What's This? Shift+F2 Edit cell comment Shift+F3 Paste function into formula Shift+F4 Find Next Shift+F5 Find Shift+F6 Previous Pane Shift+F8 Add to selection Shift+F9 Calculate active worksheet Shift+F10 Display shortcut menu Shift+F11 New worksheet Shift+F12 Save Ctrl+F3 Define name Ctrl+F4 Close Ctrl+F5 XL, Restore window size Ctrl+F6 Next workbook window Shift+Ctrl+F6 Previous workbook window Ctrl+F7 Move window XL Ctrl+F8 Resize window XL Ctrl+F9 Minimize workbook XL Ctrl+F10 Maximize or restore window XL Ctrl+F11 Inset 4.0 Macro sheet Ctrl+F12 File Open Alt+F1 Insert Chart Alt+F2 Save As Alt+F4 Exit Alt+F8 Macro dialog box Alt+F11 Visual Basic Editor Ctrl+Shift+F3 Create name by using names of row and column labels Ctrl+Shift+F6 Previous Window Ctrl+Shift+F12 Print Alt+Shift+F1 New worksheet Alt+Shift+F2 Save Alt+= AutoSum No direct equivalent Ctrl+` Toggle Value/Formula display Ctrl+Shift+A Insert argument names into formula Alt+Down arrow Display AutoComplete list Alt+' Format Style dialog box Ctrl+Shift+~ General format Ctrl+Shift+! Comma format Ctrl+Shift+@ Time format Ctrl+Shift+# Date format Ctrl+Shift+$ Currency format Ctrl+Shift+% Percent format Ctrl+Shift+^ Exponential format Ctrl+Shift+& Place outline border around selected cells Format, Cells, Border Ctrl+Shift+_ Remove outline border Ctrl+Shift+* Select current region Ctrl++ Insert Insert, (Rows, Columns, or Cells) Ctrl+- Delete Delete, (Rows, Columns, or Cells) Ctrl+1 Format cells dialog box Ctrl+2 Bold Format, Cells, Font, Font Style, Bold Ctrl+3 Italic Format, Cells, Font, Font Style, Italic Ctrl+4 Underline Format, Cells, Font, Font Style, Underline Ctrl+5 Strikethrough Format, Cells, Font, Effects, Strikethrough Ctrl+6 Show/Hide objects Tools, Options, View, Objects, Show All/Hide Ctrl+7 Show/Hide Standard toolbar View, Toolbars, Stardard Ctrl+8 Toggle Outline symbols Ctrl+9 Hide rows Format, Row, Hide Ctrl+0 Hide columns Format, Column, Hide Ctrl+Shift+( Unhide rows Format, Row, Unhide Ctrl+Shift+) Unhide columns Format, Column, Unhide Alt or F10 Activate the menu Ctrl+Tab In toolbar: next toolbar Shift+Ctrl+Tab In toolbar: previous toolbar Ctrl+Tab In a workbook: activate next workbook
Create Date : 29 กันยายน 2551 |
Last Update : 29 กันยายน 2551 19:53:41 น. |
|
2 comments
|
Counter : 897 Pageviews. |
|
|
|