Shortcuts
Windows
Mac
Creates a new workbook
Ctrl+N
⌘+N
Opens an existing workbook
Ctrl+O
⌘+O
Saves a workbook
Ctrl+S
⌘+S
Closes the current workbook
Ctrl+W
⌘+W
Close Excel
Ctrl+F4
⌘+Q
Cut
Ctrl+X
⌘+X
Copy
Ctrl+C
⌘+C
Paste
Ctrl+V
⌘+V
Paste Special
Alt+E+S
⌘ + Option + V
Paste a name into formula
F3
F3
Save as
F12
⌘+⇧+S
Open print preview window
Ctrl+F2
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
Open options
Alt+F+T
⌘ + ,
Open help
F1
⌘ + /
Undo last action
Ctrl+Z
⌘+Z
Redo last action
Ctrl+Y
⌘+Y
Copy selected cells
Ctrl+C
⌘+C
Repeat last action
F4
⌘+Y
Paste values
Ctrl+shift+V
⌘+⌃+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
Insert table
Ctrl+T
⌘+T
Toggle Autofilter
Ctrl+Shift+L
⌘+⇧+F
Activate filter
Alt+↓
⌥+↓
Select table row
Shift+Space
⇧+Space
Select table column
Ctrl+Space
⌃+Space
Select table
Ctrl+A
⌘+A
Clear slicer filter
Alt+C
⌥+C
Toggle table total row
Ctrl+Shift+T
⌃+⇧+T
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
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
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
ShiftPg+Up
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