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 Data

Enter 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 Formatting

Format (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 Operations

Display 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 Mode

Edit 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 forPivot Tables

Select 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 Formulas

Toggle 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 Drop

Drag 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 Navigation

Move 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 Special

Display ‘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 Formatting

Apply 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 Tables

Select 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 Boxes

Move 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