Making full use of shortcut keys can greatly speed up our operation of the computer. Of course, the boss also likes employees who work faster. If you don’t want to be fired, I suggest you use it often until you are skilled.
Shortcut Keys for General Functions
Open options Alt +F +T ⌘ +, Open help F1 ⌘ +/ Undo last action Ctrl +Z ⌘ +Z Redo last action Ctrl +Y ⌘ +Y Repeat last action F4 ⌘ +Y Copy selected cells Ctrl +C ⌘ +C Cut selected cells Ctrl +X ⌘ +X Paste content from clipboard Ctrl +V ⌘ +V Display the Paste Special dialog box Ctrl +Alt +V ⌘ +⌃ +V Display find and replace Ctrl +F ⌘ +F Display find and replace, replace selected Ctrl +H ⌃ +H Find next match Shift +F4 ⌘ +G Find previous match Ctrl +Shift +F4 ⌘ +⇧ +G Create embedded chart Alt +F1 Fn +⌥ +F1 Create chart in new worksheet F11 Fn +F11
Shortcut Keys for Workbooks
Insert new worksheet Shift +F11 fn +⇧ +F11 Go to next worksheet Ctrl +PgDn Fn +⌃ +↓ Go to previous worksheet Ctrl +PgUp Fn +⌃ +↑ Move to next pane F6 Fn +F6 Move to previous pane Shift +F6 Fn +⇧ +F6 Go to next workbook Ctrl +Tab ⌃ +Tab Go to previous workbook Ctrl +Shift +Tab ⌃ +⇧ +Tab Minimize current workbook window Ctrl +F9 ⌘ +M Maximize current workbook window Ctrl +F10 fn +⌃ +F10 Select adjacent worksheets Shift +Click ⇧ +Click Select non-adjacent worksheets Ctrl +Click ⌘ +Click Toggle scroll lock Scr +L +k Fn +⇧ +F12 Toggle full screen Ctrl +Shift +F1 ⌃ +⌘ +F
Shortcut Keys for Active Cell Select active cell only Shift +Backspace ⇧ +Delete Show the active cell on worksheet Ctrl +Backspace ⌘ +Delete Move active cell clockwise in selection Ctrl +. ⌃ +. Move active cell down in selection Enter Return Move active cell up in selection Shift +Enter ⇧ +Return Move active cell right in a selection Tab Tab Move active cell left in a selection Shift +Tab ⇧ +Tab
Shortcut Keys for Extend Selection Extend selection by one cell right Shift +→ ⇧ +→ Extend selection by one cell left Shift +← ⇧ +← Extend selection by one cell up Shift +↑ ⇧ +↑ Extend selection by one cell down Shift +↓ ⇧ +↓ Extend the selection to the last cell right Ctrl +Shift +→ ⌃ +⇧ +→ Extend the selection to the last cell left Ctrl +Shift +← ⌃ +⇧ +← Extend the selection to the last cell up Ctrl +Shift +↑ ⌃ +⇧ +↑ Extend the selection to the last cell down Ctrl +Shift +↓ ⌃ +⇧ +↓ Extend selection up one screen Shift +PgUp Fn +⇧ +↑ Extend selection down one screen Shift +PgDn Fn +⇧ +↓ Extend selection right one screen Alt +Shift +PgDn Fn +⇧ +⌥ +↓ Extend selection left one screen Alt +Shift +PgUp Fn +⇧ +⌥ +↑ Extend selection to start of row Shift +Home Fn +⇧ +← Extend selection to first cell in worksheet Ctrl +Shift +Home Fn +⌃ +⇧ +← Extend selection to last cell in worksheet Ctrl +Shift +End Fn +⌃ +⇧ +→ Toggle extend selection mode F8 Fn +F8
Shortcut Keys for Entering DataEnter and move down Enter Return Enter and move up Shift +Enter ⇧ +Return Enter and move right Tab Tab Enter and move left Shift +Tab ⇧ +Tab Complete entry and stay in same cell Ctrl +Enter ⌃ +Return Enter same data in multiple cells Ctrl +Enter ⌃ +Return Insert current date Ctrl +; ⌃ +; Insert current time Ctrl +Shift: ⌘ +; Copy formula from cell above Ctrl +‘ ⌃ +‘ Copy value from cell above Ctrl +Shift +“ ⌃ +⇧ +“ Add hyperlink Ctrl +K ⌘ +K Display AutoComplete list Alt +↓ ⌥ +↓ Fill right from cell left Ctrl +R ⌃ +R Fill down from cell above Ctrl +D ⌃ +D Flash fill Ctrl +E
Shortcut Keys for Borders Add border outline Ctrl +Shift +& ⌘ +⌥ +0 Add or remove border right Alt +R ⌘ +⌥ +→ Add or remove border left Alt +L ⌘ +⌥ +← Add or remove border top Alt +T ⌘ +⌥ +↑ Add or remove border bottom Alt +B ⌘ +⌥ +↓ Add or remove border upward diagonal Alt +D Add or remove border horizontal interior Alt +H Add or remove border vertical interior Alt +V Remove borders Ctrl +Shift_ ⌘ +⌥ +_
Shortcut Keys for FormattingFormat (almost) anything Ctrl +1 ⌘ +1 Display Format Cells with Font tab selected Ctrl +Shift +F ⌃ +⇧ +F Apply or remove bold formatting Ctrl +B ⌘ +B Apply or remove italic formatting Ctrl +I ⌘ +I Apply or remove underscoring Ctrl +U ⌘ +U Apply or remove strikethrough formatting Ctrl +5 ⌘ +⇧ +X Add or remove the shadow font style ⌘ +⇧ +W Add or remove the outline font style ⌘ +⇧ +D Align center Alt +H +A +C ⌘ +E Align left Alt +H +A +L ⌘ +L Align right Alt +H +A +R ⌘ +R Indent Alt +H6 ⌃ +⌥ +Tab Remove indent Alt +H5 ⌃ +⌥ +⇧ +Tab Increase font size one step Alt +H +F +G ⌘ +⇧ +> Decrease font size one step Alt +H +F +K ⌘ +⇧ +<
Cell Edit Mode
Edit the active cell F2 ⌃ +U Insert or edit comment ShiftF2 Fn +⇧ +F2 Cancel entry Esc Esc Select one character right Shift +→ ⇧ +→ Select one character left Shift +← ⇧ +← Move one word right Ctrl +→ ⌃ +→ Move one word left Ctrl +← ⌃ +← Select one word right CtrlShift +→ ⌃ +⇧ +→ Select one word left Ctrl +Shift +← ⌃ +⇧ +← Select to beginning of cell Shift +Home Fn +⇧ +← Select to end of cell Shift +End Fn +⇧ +→ Delete to end of line Ctrl +Delete ⌃ +Delete Delete character to the left of cursor Backspace Delete Delete character to the right of cursor Delete Fn +Delete Start a new line in the same cell Alt +Enter ⌃ +⌥ +Return
AcShortcut Keys for File
Create new workbook Ctrl +N ⌘ +N Open workbook Ctrl +O ⌘ +O Save workbook Ctrl +S ⌘ +S Save as F12 ⌘ +⇧ +S Print file Ctrl +P ⌘ +P Open print preview window Ctrl +F2 Close current workbook Ctrl +W ⌘ +W Close Excel Alt +F4 ⌘ +Q
Shortcut Keys for Grid OperationsDisplay Insert Dialog box Ctrl +Shift ++ ⌘ +⇧ ++ Insert rows Ctrl +Shift ++ ⌘ +⇧ ++ Insert columns Ctrl +Shift ++ ⌘ +⇧ ++ Display Delete dialog box Ctrl +– ⌘ +– Delete rows Ctrl +– ⌘ +– Delete columns Ctrl +– ⌘ +– Delete cells Ctrl +– ⌘ +– Delete contents of selected cells Delete Fn +Delete Hide columns Ctrl +0 ⌃ +0 Hide rows Ctrl +9 ⌃ +9 Unhide rows Ctrl +Shift +9 ⌃ +⇧ +9 Unhide columns Ctrl +Shift +0 ⌃ +⇧ +0 Group rows or columns Alt +Shift +→ ⌘ +⇧ +K Ungroup rows or columns Alt +Shift +← ⌘ +⇧ +J Open Group Dialog Box Alt +Shift +→ ⌘ +⇧ +K Open Ungroup Dialog Box Alt +Shift +← ⌘ +⇧ +J Hide or show outline symbols Ctrl +8 ⌃ +8 Zoom in Ctrl +Alt ++ ⌥ +⌘ ++ Zoom out Ctrl +Alt +– ⌥ +⌘ +–
Shortcut Keys for Cell Edit ModeEdit the active cell F2 ⌃ +U Insert or edit comment Shift +F2 Fn +⇧ +F2 Cancel entry Esc Esc Select one character right Shift +→ ⇧ +→ Select one character left Shift +← ⇧ +← Move one word right Ctrl +→ ⌃ +→ Move one word left Ctrl +← ⌃ +← Select to beginning of cell Shift +Home Fn +⇧ +← Select to end of cell Shift +End Fn +⇧ +→ Select one word right Ctrl +Shift +→ ⌃ +⇧ +→ Select one word left Ctrl +Shift +← ⌃ +⇧ +← Delete to end of line Ctrl +Delete ⌃ +Delete Delete character to the left of cursor Backspace Delete Delete character to the right of cursor Delete Fn +Delete Start a new line in the same cell Alt +Enter ⌃ +⌥ +Return
Shortcut Keys for Pivot TablesSelect entire pivot table Ctrl +A ⌘ +A Toggle pivot table field checkbox Space Space Group pivot table items Alt +Shift +→ ⌘ +⇧ +K Ungroup pivot table items Alt +Shift +← ⌘ +⇧ +J Hide pivot table item Ctrl +– Ctrl +– Create pivot chart on same worksheet Alt +F1 Create pivot chart on new worksheet F11 Fn +F11 Open pivot table wizard Alt +D +P ⌘ +⌥ +P
Shortcut Keys for FormulasToggle absolute and relative references F4 ⌘ +T Open the Insert Function Dialog Box Shift +F3 Fn +⇧ +F3 Autosum selected cells Alt += ⌘ +⇧ +T Toggle formulas on and off Ctrl +` ⌃ +` Insert function arguments Ctrl +Shift +A ⌃ +⇧ +A Enter array formula Ctrl +Shift +Enter ⌃ +⇧ +Return Calculate worksheets F9 Fn +F9 Calculate active worksheet Shift +F9 Fn +⇧ +F9 Force calculate all worksheets Ctrl +Alt +F9 Evaluate part of a formula F9 Fn +F9 Expand or collapse the formula bar Ctrl +Shift +U ⌃ +⇧ +U Display function arguments dialog box Ctrl +A ⌃ +A Open the Name Manager Ctrl +F3 Fn +⌃ +F3 Define name using row and column labels Ctrl +Shift +F3 Fn +⌃ +⇧ +F3 Paste name into formula F3 Accept function with autocomplete Tab ↓ +Tab
Shortcut Keys for Drag and DropDrag and cut drag drag Drag and copy Ctrl +drag ⌥ +drag Drag and insert Shift +drag ⇧ +drag Drag and insert copy Ctrl +Shift +drag ⌥ +⇧ +drag Drag to worksheet Alt +drag ⌘ +drag Drag to duplicate worksheet Ctrl +drag ⌥ +drag
Shortcut Keys for NavigationMove one cell right → → Move one cell left ← ← Move one cell up ↑ ↑ Move one cell down ↓ ↓ Move one screen right Alt +PgDn Fn +⌥ +↓ Move one screen left Alt +PgUp Fn +⌥ +↑ Move one screen up PgUp Fn +↑ Move one screen down PgDn Fn +↓ Move to right edge of data region Ctrl +→ +⌃ +→ Move to left edge of data region Ctrl +← +⌃ +← Move to top edge of data region Ctrl +↑ ⌃ +↑ Move to bottom edge of data region Ctrl +↓ ⌃ +↓ Move to beginning of row Home Fn +← Move to last cell in worksheet Ctrl +End Fn +⌃ +→ Move to first cell in worksheet Ctrl +Home Fn +⌃ +← Turn End mode on End Fn +→ Go back to hyperlink Ctrl +G +Enter ⌃ +G +Return
Shortcut Keys for Select SpecialDisplay ‘Go To’ dialog box Ctrl +G ⌃ +G Select cells with comments Ctrl +Shift +O Fn +⌃ +⇧ +O Select current region around active cell Ctrl +Shift +* ⇧ +⌃ +Space Select current region Ctrl +A ⌘ +A Select current array Ctrl +/ ⌃ +/ Select row differences Ctrl +\ ⌃ +\ Select column differences Ctrl +Shift +| ⌃ +⇧ +| Select direct precedents Ctrl +[ ⌃ +[ Select all precedents Ctrl +Shift +{ ⌃ +⇧ +{ Select direct dependents Ctrl +] ⌃ +] Select all dependents Ctrl +Shift +} ⌃ +⇧ +} Select visible cells only Alt +; ⌘ +⇧ +Z
Shortcut Keys for Number FormattingApply general format Ctrl +Shift +~ ⌃ +⇧ +~ Apply currency format Ctrl +Shift +$ ⌃ +⇧ +$ Apply percentage format Ctrl +Shift +% ⌃ +⇧ +% Apply scientific format Ctrl +Shift +^ ⌃ +⇧ +^ Apply date format Ctrl +Shift +# ⌃ +⇧ +# Apply time format Ctrl +Shift +@ ⌃ +⇧ +@ Apply number format Ctrl +Shift +! ⌃ +⇧ +!
Shortcut Keys for Pivot TablesSelect entire pivot table Ctrl +A ⌘ +A Toggle pivot table field checkbox Space Space Group pivot table items Alt +Shift +→ ⌘ +⇧ +K Ungroup pivot table items Alt +Shift +← ⌘ +⇧ +J Hide pivot table item Ctrl +– Ctrl +– Create pivot chart on same worksheet Alt +F1 Create pivot chart on new worksheet F11 Fn +F11 +b Open pivot table wizard Alt +D +P ⌘ +⌥ +P
Shortcut Keys for Dialog BoxesMove to next control Tab Tab Move to previous control Shift +Tab ⇧ +Tab Move to next tab Ctrl +Tab ⌃ +Tab Move to previous tab Ctrl +Shift +Tab ⌃ +⇧ +Tab Accept and apply Enter Return Check and uncheck box Space Space Cancel and close the dialog box Esc Esc
Shortcut Keys for Ribbon
Expand or collapse ribbon Ctrl +F1 ⌘ +⌥ +R Activate access keys Alt Move to next ribbon control Tab Tab Activate or open selected control Space Space Confirm control change Enter Return Get help on selected control F1
Opens the “What’s This?” window. Shift +F1 Fn +⇧ +F1 Open VBA Editor Alt +F11 Fn +⌥ +F11 Open Spelling dialog box F7 Fn +F7 Open Macro dialog box AltF8 Fn +⌥ +F8 Open Thesaurus dialog box ShiftF7 Fn +⇧ +F7 Display control menu Alt +Space ? Display right-click menu Shift +F10 Fn +⇧ +F10 Display Modify Cell Style dialog box Alt +‘ ⌘ +⇧ +L Delete comment Shift +F10 +D Fn +Shift +F10 Hide or show objects Ctrl +6 ⌃ +6 Snap to grid Alt ⌘ Duplicate object Ctrl +D ⌘ +D
Leave a Reply