Excel Shortcuts List for Mac and PC (Searchable)

How to Use this Shortcut List:

+ Indicates to hold the previous key, while pressing the next key.

> Indicates to tap the previous key, releasing it before pressing the next key.

Find the shortcuts list below:

DescriptionPC ShortcutMac Shortcut
Basic Shortcutsyes
Save Workbook
Ctrl+S
+S
Save As
F12
++S
Print
Ctrl+P
+P
Create New Workbook
Ctrl+N
+N
Open Workbook
Ctrl+O
+O
Open Print Preview
Ctrl+F2
+P
Close Workbook
Ctrl+F4
+W
Close Excel
Alt+F4
+Q
Undo Previous Action
Ctrl+Z
+Z
Redo Previous Action
Ctrl+Y
+Y
Open Help
F1
+/
Clear Cell Contents
Delete
fn+delete
Clear Cell Formatting
Alt > H > E > F
Clear All
Alt > H > E > A
Number Formatting Shortcutsyes
Apply General Format
Ctrl+Shift+~
++~
Apply Number Format
Ctrl+Shift+!
++!
Apply Time Format
Ctrl+Shift+@
++@
Apply Date Format
Ctrl+Shift+#
++#
Apply Currency Format
Ctrl+Shift+$
++$
Apply Percentage Format
Ctrl+Shift+%
++%
Apply Scientific Format
Ctrl+Shift+^
++^
Viewing Shortcutsyes
Close Window
Ctrl+WorCtrl+F4
+W
Restore Window Size
Ctrl+F5
Next Window
Ctrl+F6
Move Window
Ctrl+F7
Resize Window
Ctrl+F8
Minimize Window
Ctrl+F9
+F9
Maximize / Restore Window
Ctrl+F10
+F10
Next Pane
F6
Previous Pane
Shift+F6
Full Screen Mode
Alt > V > U
++F
Exit Full Screen
Esc
esc
Rotate or Flip Screen
Ctrl+Alt+
Take Screenshot
PrtSc
++3
View Mode Shortcutsyes
Toggle Formula View Mode
Ctrl+`
+`
Open Print Preview
Ctrl+F2
+P
Expand Or Collapse Ribbon
Ctrl+F1
++R
Expand Or Collapse The Formula Bar
Ctrl+Shift+U
++U
Copy, Cut, & Paste Shortcutsyes
Copy
Ctrl+C
+C
Cut
Ctrl+X
+X
Paste
Ctrl+V
+V
Open Paste Special Dialog Box
Ctrl+Alt+V
++V
Paste Value
Ctrl+Alt+V > V > Enter
++V > +V > return
Paste Format
Ctrl+Alt+V > T > Enter
++V > +T > return
Paste & Transpose
Ctrl+Alt+V > E > Enter
++V > +E > return
Paste & Skip Blanks
Ctrl+Alt+V > B > Enter
++V > +B > return
Borders Shortcutsyes
Add Outline Border
Ctrl+Shift+&
++0
Add Or Remove Top Border
Alt > H > B > T
++
Add Or Remove Bottom Border
Alt > H > B > B
++
Add Or Remove Right Border
Alt > H > B > R
++
Add Or Remove Left Border
Alt > H > B > L
++
Remove Borders
Ctrl+Shift+_
++_
Formatting Shortcutsyes
Open Format Cells Dialog Box
Ctrl+1
+1
Repeat Previous Format
F4
+Y
Toggle Bold Formatting
Ctrl+B
+B
Toggle Italic Formatting
Ctrl+I
+I
Toggle Underline
Ctrl+U
+U
Toggle Strikethrough
Ctrl+5
++X
Apply Superscript Formatting
Ctrl+Shift+F > Alt+E
Apply Subscript Formatting
Ctrl+Shift+F > Alt+B
Wrap Text
Alt > H > W
Merge Cells
Alt > H > M
Align Center
Alt > H > A > C
+E
Align Left
Alt > H > A > L
+L
Align Right
Alt > H > A > R
+R
Indent
Alt > H > 6
+ > tab
Remove Indent
Alt > H > 5
+ > +tab
Increase Font Size
Alt > H > F > G
++>
Decrease Font Size
Alt > H > F > K
++
Apply Conditional Formatting
Alt > H > L
Format Painter
Ctrl+Alt+V
Highlight Cell
Alt > H > H
Fill Color
Alt > H > H
Pivot Table Shortcutsyes
Open Pivot Table Wizard
Alt > N > V
+ > P
Create Pivot Chart On Same Worksheet
Alt+F1
Create Pivot Chart On New Worksheet
F11
F11
Select Entire Pivot Table
Ctrl+A
+A
Group Pivot Table Items
Alt+Shift+
++K
Ungroup Pivot Table Items
Alt+Shift+
++J
Hide Pivot Table Item
Ctrl+-
+-
Toggle Pivot Table Field Checkbox
Space
space
Entering Data Shortcutsyes
Enter Text And Move Down
Enter
return
Enter Text And Move Right
Tab
tab
Enter Text And Move Up
Shift+Enter
+return
Enter Text 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
Copy Formula From Cell Above
Ctrl+'
+'
Copy Value From Cell Above
Ctrl+Shift+"
++"
Add Hyperlink
Ctrl+K
+K
Insert Current Date
Ctrl+;
+;
Insert Current Time
Ctrl+Shift+:
++:
Display Autocomplete List
Alt+
+
Flash Fill
Ctrl+E
Fill Down
Ctrl+D
+D
Fill Right
Ctrl+R
+R
Navigation Shortcutsyes
Move One Cell
Move to Edge of Data Region
Ctrl+
+
Move One Screen Up
PgUp
fn+
Move One Screen Down
PgDn
fn+
Move One Screen Right
Alt+PgDn
fn+ >
Move One Screen Left
Alt+PgUp
fn+ >
Move To Beginning Of Row
Home
fn+
Move To First Cell In Worksheet
Ctrl+Home
fn++
Move To Last Used Cell In Worksheet
Ctrl+End
fn++
Turn End Mode On
End
fn+
Creating Formula Shortcutsyes
Open The Insert Function Dialog Box
Shift+F3
+F3
Cycles Through Absolute And Relative References
F4
+T
Insert Function Arguments into Cell
Ctrl+Shift+A
++A
Open The Insert Function Dialog Box From Within Cell
Ctrl+A
+A
Sum Selected Cells
Alt+=
++T
Calculate Part of a Formula
F9
F9
Create Array Formula
Ctrl+Shift+Enter
++return
Named Ranged Shortcutsyes
Open Name Manager Dialog Box
Ctrl+F3
+L
Insert Named Range Into Formula
F3
Create Name Based on Row and Column Headings
Ctrl+Shift+F3
++F3
Calculation Shortcutsyes
Calculate Now
F9
F9
Calculate Active Sheet
Shift+F9
+F9
Force Calculate
Ctrl+Alt+F9
Manual Calculation
Alt > M > X > M
Turn on Automatic Calculation
Alt > M > X > A
Refresh
F9
F9
Dialog Box Navigation Shortcutsyes
Toggle Checkbox
Space
space
Apply Changes and Close the Dialog Box
Enter
return
Cancel Changes and Close the Dialog Box
Esc
esc
Next Control
Tab
tab
Previous Control
Shift+Tab
+tab
Next Tab
Ctrl+Tab
+tab
Previous Tab
Ctrl+Shift+Tab
++tab
Spreadsheet Review Shortcutsyes
Toggle Formula View Mode
Ctrl+`
+`
trace precedents
Alt > M > P
trace dependents
Alt > M > D
Cell Editing Shortcutsyes
Edit The Active Cell
F2
+U
Toggle Between Cell Edit Mode and Cell Enter Mode
F2
+U
Save Changes and Exit Cell Edit Mode
Enter
Cancel Entry and Exit Cell Edit Mode
Esc
esc
Go to Beginning of Cell
Home
fn+
Go to End of Cell
End
fn+
Select Character
Shift+
+
Move One Word to Right or Left
Ctrl+
+
Select One Word to Right or Left
Ctrl+Shift+
++
Delete Character to Right of Cursor
Delete
fn+delete
Delete Character to the Left of Cursor
Backspace
delete
Insert New Line Break Within Cell
Alt+Enter
++return
Insert Or Edit Comment
Shift+F2
+F2
Ribbon Shortcutsyes
Expand Or Collapse Ribbon
Ctrl+F1
++R
Activate Ribbon Shortcut Keys
Alt
+F2
Move To Next Ribbon Control
Tab
tab
Activate Selected Control
Space
space
Confirm Control Change
Enter
return
Cancel Control Change
Esc
esc
Get Help On Selected Control
F1
Workbook Shortcutsyes
Insert New Worksheet
Shift+F11
+F11
Go To Next Worksheet (Tab)
Ctrl+PgDn
fn++
Go To Previous Worksheet (Tab)
Ctrl+PgUp
fn++
Move To Next Pane
F6
F6
Move To Previous Pane
Shift+F6
+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
Switch Tabs
Ctrl+PgUp or PgDn
fn++or
Selection Shortcutsyes
Select Current Region (Possibly Entire Worksheet)
Ctrl+A
+A
Select Visible Cells Only
Alt+;
++Z
Select Cells With Comments
Ctrl+Shift+O
fn+++O
Display 'Go To' Dialog Box
Ctrl+G
+G
Select Region Directly Around Active Cell
Ctrl+Shift+*
++space
Select Current Array
Ctrl+/
+/
Select Row Differences
Ctrl+\
+\
Select Column Differences
Ctrl+Shift+|
++|
Select All Precedents
Ctrl+Shift+{
++{
Select All Dependents
Ctrl+Shift+}
++}
Select Direct Precedents
Ctrl+[
+[
Select Direct Dependents
Ctrl+]
+]
Misc. Shortcutsyes
Find
Ctrl+F
+F
Find and Replace
Ctrl+H
+H
Find Previous Match
Ctrl+Shift+F4
+fn+F
Find Next Match
Shift+F4
+F
Insert Chart
Alt+F1
+F1
Insert Chart in New Worksheet
F11
F11
Toggle Autofilter
Ctrl+Shift+L
++F
Activate Filter
Alt+
+
Create Table
Ctrl+T
+T
Open Visual Basic ( VBA ) Editor
Alt+F11
+fn+F11
Open Macros
Alt+F8
+fn+F8
Stop Running Macro
Ctrl+Pause Break
+.
Worksheet Shortcutsyes
Insert Row
Ctrl++
+I
Insert Column
Ctrl++
+I
Delete Row
Ctrl+-
+-
Delete Column
Ctrl+-
+-
Delete Cell
Ctrl+-
+-
Hide Column
Ctrl+0
+0
Hide Row
Ctrl+9
+9
Unhide Row
Ctrl+Shift+9
++9
Unhide Column
Ctrl+Shift+0
++0
Display Insert Dialog Box
Ctrl++
+I
Display Delete Dialog Box
Ctrl+-
+-
Group Rows Or Columns
Alt+Shift+
++K
Ungroup Rows Or Columns
Alt+Shift+
++J
Select Entire Row
Shift+Space
+space
Select Entire Column
Ctrl+Space
+space
Select Entire Worksheet
Ctrl+A
+A
Toggle Add To Selection Mode
Shift+F8
+F8
Mouse Shortcutsyes
Zoom In / Zoom Out
Ctrl+Mouse
+ Mouse
Drag And Copy
Ctrl+Drag
+ Drag
Drag And Cut
Drag
Drag
Drag And Insert
Shift+ Drag
+ Drag
Drag And Insert Copy
Ctrl+Shift+ Drag
++ Drag
Drag To Worksheet
Alt+ Drag
+ Drag