mac equivalents of windows excel shortcuts
DESCRIPTION
If you have recently started using a Mac and are struggling with the Microsoft Excel Shortcuts, this will solve all your problemsTRANSCRIPT
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 1/29
LoginCart
Professional training in half the time
Products Blog Functions Formulas Tips Shortcuts
Search ShortcutsApply Reset
Ctrl N
Ctrl O
Ctrl S
220 Excel keyboard shortcuts for PC and Mac
File
Create new workbook
N
Open workbook
O
Save workbook
S
Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right.On Macs, you generally need to use the Fn key for certain shortcuts, as shownbelow.
Download the PDF Get a printed card
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 2/29
F12
Ctrl P
Ctrl F2
Ctrl F4
Alt F4
Ctrl F1
Alt
Tab
Save as
S
Print file
P
Open print preview window
Close current workbook
W
Close Excel
Q
Ribbon
Expand or collapse ribbon
R
Activate access keys
Move to next ribbon control
Tab
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 3/29
Space
Enter
F1
F1
Ctrl Z
Ctrl Y
Ctrl C
Ctrl X
Activate or open selected control
Space
Confirm control change
Return
Get help on selected control
General
Open help
/
Undo last action
Z
Redo last action
Y
Copy selected cells
C
Cut selected cells
X
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 4/29
Ctrl V
Ctrl Alt V
Ctrl F
Ctrl H
Ctrl Shift F4
Shift F4
Alt F1
F11
Ctrl Shift L
Paste content from clipboard
V
Display the Paste Special dialog box
V
Display find and replace
F
Display find and replace, replace selected
H
Find previous match
G
Find next match
G
Create embedded chart
Fn F1
Create chart in new worksheet
Fn F11
Toggle Autofilter
F
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 5/29
Alt
Ctrl T
Shift Space
Ctrl Space
Ctrl A
drag
Ctrl drag
Shift drag
Activate filter
Insert table
T
Select table row
Space
Select table column
Space
Select table
A
Drag and Drop
Drag and cut
drag
Drag and copy
drag
Drag and insert
drag
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 6/29
Ctrl Shift drag
Alt drag
Ctrl drag
Alt PgDn
Drag and insert copy
drag
Drag to worksheet
drag
Drag to duplicate worksheet
drag
Navigation
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen right
Fn
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 7/29
Alt PgUp
PgUp
PgDn
Ctrl
Ctrl
Ctrl
Ctrl
Home
Ctrl End
Move one screen left
Fn
Move one screen up
Fn
Move one screen down
Fn
Move to right edge of data region
Move to left edge of data region
Move to top edge of data region
Move to bottom edge of data region
Move to beginning of row
Fn
Move to last cell in worksheet
Fn
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 8/29
Ctrl Home
End
Shift Space
Ctrl Space
Ctrl A
Ctrl Click
Ctrl Alt
Ctrl Alt
Move to first cell in worksheet
Fn
Turn End mode on
Fn
Selection
Select entire row
Space
Select entire column
Space
Select entire worksheet
A
Add non-adjacent cells to selection
Click
Move right between non-adjacent selections
Move left between non-adjacent selections
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 9/29
Shift F8
Esc
Shift Backspace
Ctrl Backspace
Ctrl .
Enter
Shift Enter
Tab
Toggle add to selection mode
Fn F8
Cancel selection
Esc
Active Cell
Select active cell only
Delete
Show the active cell on worksheet
Delete
Move active cell clockwise in selection
.
Move active cell down in selection
Return
Move active cell up in selection
Return
Move active cell right in a selection
Tab
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 10/29
Shift Tab
Shift
Shift
Shift
Shift
Ctrl Shift
Ctrl Shift
Ctrl Shift
Move active cell left in a selection
Tab
Extend Selection
Extend selection by one cell right
Extend selection by one cell left
Extend selection by one cell up
Extend selection by one cell down
Extend the selection to the last cell right
Extend the selection to the last cell left
Extend the selection to the last cell up
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 11/29
Ctrl Shift
Shift PgUp
Shift PgDn
Shift Home
Ctrl Shift Home
Ctrl Shift End
F8
Ctrl G
Extend the selection to the last cell down
Extend selection up one screen
Fn
Extend selection down one screen
Fn
Extend selection to start of row
Fn
Extend selection to first cell in worksheet
Fn
Extend selection to last cell in worksheet
Fn
Toggle extend selection mode
Fn F8
Select Special
Display 'Go To' dialog box
G
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 12/29
Ctrl Shift O
Ctrl Shift *
Ctrl A
Ctrl /
Ctrl \
Ctrl Shift |
Ctrl [
Ctrl Shift {
Ctrl ]
Select cells with comments
Fn O
Select current region around active cell
Space
Select current region
A
Select current array
/
Select row differences
\
Select column differences
|
Select direct precedents
[
Select all precedents
{
Select direct dependents
]
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 13/29
Ctrl Shift }
Alt ;
F2
Shift F2
Esc
Shift
Shift
Ctrl
Select all dependents
}
Select visible cells only
Z
Cell edit mode
Edit the active cell
U
Insert or edit comment
Fn F2
Cancel entry
Esc
Select one character right
Select one character left
Move one word right
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 14/29
Ctrl
Ctrl Shift
Ctrl Shift
Shift Home
Shift End
Ctrl Delete
Backspace
Delete
Alt Enter
Move one word left
Select one word right
Select one word left
Select to beginning of cell
Fn
Select to end of cell
Fn
Delete to end of line
Delete
Delete character to the left of cursor
Delete
Delete character to the right of cursor
Fn Delete
Start a new line in the same cell
Return
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 15/29
Enter
Shift Enter
Tab
Shift Tab
Ctrl Enter
Ctrl Enter
Ctrl ;
Ctrl Shift :
Entering data
Enter and move down
Return
Enter and move up
Return
Enter and move right
Tab
Enter and move left
Tab
Complete entry and stay in same cell
Return
Enter same data in multiple cells
Return
Insert current date
;
Insert current time
:
Fill down from cell above
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 16/29
Ctrl D
Ctrl R
Ctrl '
Ctrl "
Ctrl K
Alt
Ctrl 1
Ctrl Shift F
D
Fill right from cell left
R
Copy formula from cell above
'
Copy value from cell above
"
Add hyperlink
K
Display AutoComplete list
Formatting
Display the Format Cells dialog box
1
Display Format Cells with Font tab selected
Apply format again
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 17/29
F4
Ctrl B
Ctrl I
Ctrl U
Ctrl 5
Alt H A C
Alt H A L
Y
Apply or remove bold formatting
B
Apply or remove italic formatting
I
Apply or remove underscoring
U
Apply or remove strikethrough formatting
X
Add or remove the shadow font style
W
Add or remove the outline font style
D
Align center
E
Align left
L
Align right
-
6/14/2014 220 Excel keyboard shortcuts for PC and Mac | Exceljet
https://exceljet.net/keyboard-shortcuts#section-footer 18/29
Alt H A R
Ctrl Shift ~
Ctrl Shift $
Ctrl Shift %
R
Indent
M
Remove indent
M
Increase font size one step
>
Decrease font size one step