Berikut adalah daftar shortcut untuk Ms Excel sebelum versi 2007 lengkap dengan Ekivalen pada Menu.
Shortcut Key | Perintah | Ekivalen dengan Menu |
Ctrl+A | Select All | None |
Ctrl+B | Bold | Format, Cells, Font, Font Style, Bold |
Ctrl+C | Copy | Edit, Copy |
Ctrl+D | Fill Down | Edit, Fill, Down |
Ctrl+F | Find | Edit, Find |
Ctrl+G | Goto | Edit, Goto |
Ctrl+H | Replace | Edit, Replace |
Ctrl+I | Italic | Format, Cells, Font, Font Style, Italic |
Ctrl+K | Insert Hyperlink | Insert, Hyperlink |
Ctrl+N | New Workbook | File, New |
Ctrl+O | Open | File, Open |
Ctrl+P | File, Print | |
Ctrl+R | Fill Right | Edit, Fill Right |
Ctrl+S | Save | File, Save |
Ctrl+U | Underline | Format, Cells, Font, Underline, Single |
Ctrl+V | Paste | Edit, Paste |
Ctrl W | Close | File, Close |
Ctrl+X | Cut | Edit, Cut |
Ctrl+Y | Repeat | Edit, Repeat |
Ctrl+Z | Undo | Edit, Undo |
F1 | Help | Help, Contents and Index |
F2 | Edit | None |
F3 | Paste Name | Insert, Name, Paste |
F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. |
F4 | While typing a formula, switch between absolute/relative refs | None |
F5 | Goto | Edit, Goto |
F6 | Next Pane | None |
F7 | Spell check | Tools, Spelling |
F8 | Extend mode | None |
F9 | Recalculate all workbooks | Tools, Options, Calculation, Calc Now |
F10 | Activate Menubar | N/A |
F11 | New Chart | Insert, Chart |
F12 | Save As | File, Save As |
Ctrl+: | Insert Current Time | None |
Ctrl+; | Insert Current Date | None |
Ctrl+” | Copy Value from Cell Above | Edit, Paste Special, Value |
Ctrl+’ | Copy Formula from Cell Above | Edit, Copy |
Shift | Hold down shift for additional functions in Excel’s menu | none |
Shift+F1 | What’s This? | Help, What’s This? |
Shift+F2 | Edit cell comment | Insert, Edit Comments |
Shift+F3 | Paste function into formula | Insert, Function |
Shift+F4 | Find Next | Edit, Find, Find Next |
Shift+F5 | Find | Edit, Find, Find Next |
Shift+F6 | Previous Pane | None |
Shift+F8 | Add to selection | None |
Shift+F9 | Calculate active worksheet | Tools, Options, Calculation, Calc Sheet |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of w | None |
Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in al | None |
Shift+F10 | Display shortcut menu | None |
Shift+F11 | New worksheet | Insert, Worksheet |
Shift+F12 | Save | File, Save |
Ctrl+F3 | Define name | Insert, Names, Define |
Ctrl+F4 | Close | File, Close |
Ctrl+F5 | XL, Restore window size | Restore |
Ctrl+F6 | Next workbook window | Window, … |
Shift+Ctrl+F6 | Previous workbook window | Window, … |
Ctrl+F7 | Move window | XL, Move |
Ctrl+F8 | Resize window | XL, Size |
Ctrl+F9 | Minimize workbook | XL, Minimize |
Ctrl+F10 | Maximize or restore window | XL, Maximize |
Ctrl+F11 | Inset 4.0 Macro sheet | |
Ctrl+F12 | File Open | File, Open |
Alt+F1 | Insert Chart | Insert, Chart… |
Alt+F2 | Save As | File, Save As |
Alt+F4 | Exit | File, Exit |
Alt+F8 | Macro dialog box | |
Alt+F11 | Visual Basic Editor | Tools, Macro, Visual Basic Editor |
Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert, Name, Create |
Ctrl+Shift+F6 | Previous Window | Window, … |
Ctrl+Shift+F12 | File, Print | |
Alt+Shift+F1 | New worksheet | Insert, Worksheet |
Alt+Shift+F2 | Save | File, Save |
Alt+= | AutoSum | No direct equivalent |
Ctrl+` | Toggle Value/Formula display | Tools, Options, View, Formulas |
Ctrl+Shift+A | Insert argument names into formula | No direct equivalent |
Alt+Down arrow | Display AutoComplete list | None |
Alt+’ | Format Style dialog box | Format, Style |
Ctrl+Shift+~ | General format | Format, Cells, Number, Category, General |
Ctrl+Shift+! | Comma format | Format, Cells, Number, Category, Number |
Ctrl+Shift+@ | Time format | Format, Cells, Number, Category, Time |
Ctrl+Shift+# | Date format | Format, Cells, Number, Category, Date |
Ctrl+Shift+$ | Currency format | Format, Cells, Number, Category, Currency |
Ctrl+Shift+% | Percent format | Format, Cells, Number, Category, Percentage |
Ctrl+Shift+^ | Exponential format | Format, Cells, Number, Category, |
Ctrl+Shift+& | Place outline border around selected cells | Format, Cells, Border |
Ctrl+Shift+_ | Remove outline border | Format, Cells, Border |
Ctrl+Shift+* | Select the current region around the active cell. In a PivotTable | Edit, Goto, Special, Current Region |
Ctrl++ | Insert | Insert, (Rows, Columns, or Cells) Depends on s |
Ctrl+- | Delete | Delete, (Rows, Columns, or Cells) Depends on |
Ctrl+1 | Format cells dialog box | Format, Cells |
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 | None |
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 | None |
Ctrl+Tab | In toolbar: next toolbar | None |
In a workbook: activate next workbook | ||
Shift+Ctrl+Tab | In toolbar: previous toolbar | None |
In a workbook: activate previous workbook | ||
Tab | Next tool | None |
Shift+Tab | Previous tool | None |
Enter | Do the command | None |
Alt+Enter | Start a new line in the same cell. | None |
Ctrl+Enter | Fill the selected cell range with the current entry. | None |
Shift+Ctrl+F | Font Drop Down List | Format, Cells, Font |
Shift+Ctrl+F+F | Font tab of Format Cell Dialog box | Format, Cells, Font |
Shift+Ctrl+P | Point size Drop Down List | Format, Cells, Font |
Ctrl+Spacebar | Select the entire column | None |
Shift+Spacebar | Select the entire row | None |
CTRL+/ | Select the array containing the active cell. | |
CTRL+SHIFT+O | Select all cells that contain comments. | |
CTRL+\ | In a selected row, select the cells that don’t match the formula or static value in the active cell. |
|
CTRL+SHIFT+| | In a selected column, select the cells that don’t match the formula or static value in the active cell. |
|
CTRL+[ | Select all cells directly referenced by formulas in the selection. |
|
CTRL+SHIFT+{ | Select all cells directly or indirectly referenced by formulas in the selection. |
|
CTRL+] | Select cells that contain formulas that directly reference the active cell. |
|
CTRL+SHIFT+} | Select cells that contain formulas that directly or indirectly reference the active cell. |
|
ALT+; | Select the visible cells in the current selection. | |
SHIFT+BACKSPACE | With multiple cells selected, select only the active cell. | |
CTRL+SHIFT+SPACEBAR | Selects the entire worksheet. | |
Ctrl+Alt+L | Reapply the filter and sort on the current range so that changes | Data, Reapply |
Ctrl+Alt+V | Displays the Paste Special dialog box. Available only after you | Home, Paste, Paste Special… |
Shortcut key | Action | Menu equivalent comments |
Ctrl+A | Select All | None |
Ctrl+B | Bold | Format, Cells, Font, Font Style, Bold |
Ctrl+C | Copy | Edit, Copy |
Ctrl+D | Fill Down | Edit, Fill, Down |
Ctrl+F | Find | Edit, Find |
Ctrl+G | Goto | Edit, Goto |
Ctrl+H | Replace | Edit, Replace |
Ctrl+I | Italic | Format, Cells, Font, Font Style, Italic |
Ctrl+K | Insert Hyperlink | Insert, Hyperlink |
Ctrl+N | New Workbook | File, New |
Ctrl+O | Open | File, Open |
Ctrl+P | File, Print | |
Ctrl+R | Fill Right | Edit, Fill Right |
Ctrl+S | Save | File, Save |
Ctrl+U | Underline | Format, Cells, Font, Underline, Single |
Ctrl+V | Paste | Edit, Paste |
Ctrl W | Close | File, Close |
Ctrl+X | Cut | Edit, Cut |
Ctrl+Y | Repeat | Edit, Repeat |
Ctrl+Z | Undo | Edit, Undo |
F1 | Help | Help, Contents and Index |
F2 | Edit | None |
F3 | Paste Name | Insert, Name, Paste |
F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. |
F4 | While typing a formula, switch between absolute/relative refs | None |
F5 | Goto | Edit, Goto |
F6 | Next Pane | None |
F7 | Spell check | Tools, Spelling |
F8 | Extend mode | None |
F9 | Recalculate all workbooks | Tools, Options, Calculation, Calc Now |
F10 | Activate Menubar | N/A |
F11 | New Chart | Insert, Chart |
F12 | Save As | File, Save As |
Ctrl+: | Insert Current Time | None |
Ctrl+; | Insert Current Date | None |
Ctrl+” | Copy Value from Cell Above | Edit, Paste Special, Value |
Ctrl+’ | Copy Formula from Cell Above | Edit, Copy |
Shift | Hold down shift for additional functions in Excel’s menu | none |
Shift+F1 | What’s This? | Help, What’s This? |
Shift+F2 | Edit cell comment | Insert, Edit Comments |
Shift+F3 | Paste function into formula | Insert, Function |
Shift+F4 | Find Next | Edit, Find, Find Next |
Shift+F5 | Find | Edit, Find, Find Next |
Shift+F6 | Previous Pane | None |
Shift+F8 | Add to selection | None |
Shift+F9 | Calculate active worksheet | Tools, Options, Calculation, Calc Sheet |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of w | None |
Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in al | None |
Shift+F10 | Display shortcut menu | None |
Shift+F11 | New worksheet | Insert, Worksheet |
Shift+F12 | Save | File, Save |
Ctrl+F3 | Define name | Insert, Names, Define |
Ctrl+F4 | Close | File, Close |
Ctrl+F5 | XL, Restore window size | Restore |
Ctrl+F6 | Next workbook window | Window, … |
Shift+Ctrl+F6 | Previous workbook window | Window, … |
Ctrl+F7 | Move window | XL, Move |
Ctrl+F8 | Resize window | XL, Size |
Ctrl+F9 | Minimize workbook | XL, Minimize |
Ctrl+F10 | Maximize or restore window | XL, Maximize |
Ctrl+F11 | Inset 4.0 Macro sheet | |
Ctrl+F12 | File Open | File, Open |
Alt+F1 | Insert Chart | Insert, Chart… |
Alt+F2 | Save As | File, Save As |
Alt+F4 | Exit | File, Exit |
Alt+F8 | Macro dialog box | |
Alt+F11 | Visual Basic Editor | Tools, Macro, Visual Basic Editor |
Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert, Name, Create |
Ctrl+Shift+F6 | Previous Window | Window, … |
Ctrl+Shift+F12 | File, Print | |
Alt+Shift+F1 | New worksheet | Insert, Worksheet |
Alt+Shift+F2 | Save | File, Save |
Alt+= | AutoSum | No direct equivalent |
Ctrl+` | Toggle Value/Formula display | Tools, Options, View, Formulas |
Ctrl+Shift+A | Insert argument names into formula | No direct equivalent |
Alt+Down arrow | Display AutoComplete list | None |
Alt+’ | Format Style dialog box | Format, Style |
Ctrl+Shift+~ | General format | Format, Cells, Number, Category, General |
Ctrl+Shift+! | Comma format | Format, Cells, Number, Category, Number |
Ctrl+Shift+@ | Time format | Format, Cells, Number, Category, Time |
Ctrl+Shift+# | Date format | Format, Cells, Number, Category, Date |
Ctrl+Shift+$ | Currency format | Format, Cells, Number, Category, Currency |
Ctrl+Shift+% | Percent format | Format, Cells, Number, Category, Percentage |
Ctrl+Shift+^ | Exponential format | Format, Cells, Number, Category, |
Ctrl+Shift+& | Place outline border around selected cells | Format, Cells, Border |
Ctrl+Shift+_ | Remove outline border | Format, Cells, Border |
Ctrl+Shift+* | Select current region | Edit, Goto, Special, Current Region |
Ctrl++ | Insert | Insert, (Rows, Columns, or Cells) Depends on s |
Ctrl+- | Delete | Delete, (Rows, Columns, or Cells) Depends on |
Ctrl+1 | Format cells dialog box | Format, Cells |
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 | None |
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 | None |
Ctrl+Tab | In toolbar: next toolbar | None |
Shift+Ctrl+Tab | In toolbar: previous toolbar | None |
Ctrl+Tab | In a workbook: activate next workbook | None |
Shift+Ctrl+Tab | In a workbook: activate previous workbook | None |
Tab | Next tool | None |
Shift+Tab | Previous tool | None |
Enter | Do the command | None |
Alt+Enter | Start a new line in the same cell. | None |
Ctrl+Enter | Fill the selected cell range with the current entry. | None |
Shift+Ctrl+F | Font Drop Down List | Format, Cells, Font |
Shift+Ctrl+F+F | Font tab of Format Cell Dialog box | Format, Cells, Font |
Shift+Ctrl+P | Point size Drop Down List | Format, Cells, Font |