Excel 2016 Keyboard shortcuts for windows
Select current array
Ctrl /
Select current region
Ctrl A
Select entire worksheet
Ctrl A
select table
Ctrl A
Display Paste Special
Ctrl Alt V
Move left non-adjacent
Ctrl Alt left-arrow
Move right non-adjacent
Ctrl Alt right-arrow
Show active cell
Ctrl Backspace
Copy selected cells
Ctrl C
Add non-adjacent cells to selection
Ctrl Click
Move to last cell in worksheet
Ctrl End
Display find and replace
Ctrl F
Expand or collapse ribbon
Ctrl F1
Open print preview window
Ctrl F2
Close current workbook
Ctrl F4
Display 'Go To' Dialog box
Ctrl G
Find with replace selected
Ctrl H
Move to first cell in worksheet
Ctrl Home
Print file
Ctrl P
Save workbook
Ctrl S
Select current region
Ctrl Shift *
Extend last worksheet cell
Ctrl Shift End
Find previous match
Ctrl Shift F4
Extend first cell
Ctrl Shift Home
Toggle Autofilter
Ctrl Shift L
Select cells with comments
Ctrl Shift O
Extend last cell down
Ctrl Shift down-arrow
Extend last cell left
Ctrl Shift left-arrow
Extend last cell right
Ctrl Shift right-arrow
Extend last cell up
Ctrl Shift up-arrow
Select all precedents
Ctrl Shift {
Select column differences
Ctrl Shift |
Select all dependents
Ctrl Shift }
Select entire column
Ctrl Space
select table column
Ctrl Space
insert table
Ctrl T
Paste content from clipboard
Ctrl V
Cut selected cells
Ctrl X
Redo Last action
Ctrl Y
Undo last action
Ctrl Z
Select direct precedents
Ctrl [
Select row differences
Ctrl \
Select direct dependents
Ctrl ]
Move to bottom edge of data region
Ctrl down-arrow
Move one word left
Ctrl left-arrow
Move to left edge of data region
Ctrl left-arrow
Move active cell clockwise in selection
Ctrl period
Move one word right
Ctrl right-arrow
Move to right edge of data region
Ctrl right-arrow
Move to top edge of data region
Ctrl up-arrow
Create new workbook
Ctrl, N
Open workbook
Ctrl, O
Move one screen down
PgDn
Move one screen up
PgUp
Move one cell right
right-arrow
Toggle add to selection mode
shift F8
Move one cell up
up-arrow
Move one cell left
left-arrow
Same selection in next column
no shortcut in windows
Activate access keys
Alt
Select visible cells only
Alt ;
Create embedded chart
Alt F1
Close Excel
Alt F4
Move one screen right
Alt PgDn
Move one screen left
Alt PgUp
Activate filter
Alt down-arrow
Same selection in previous column
no shortcut in windows
Turn End mode on
End
Confirm control change
Enter
Move active cell down in selection
Enter
Cancel entry
Esc
cancel selection
Esc
Get help on selected control
F1
Open help
F1
Create chart in new worksheet
F11
Save as
F12
Edit the active cell
F2
Toggle extend selection mode
F8
Move to beginning of row
Home
Select active cells only
Shift Backspace
Add adjacent cells to selection
Shift Click
Move active cell up in selection
Shift Enter
Insert or edit comment
Shift F2
Find next match
Shift F4
Extend selection to start of row
Shift Home
Extend selection down one screen
Shift PgDn
Extend selection up one screen
Shift PgUp
Select entire row
Shift Space
Select table row
Shift Space
Move active cell left in a selection
Shift Tab
Extend selection by one cell down
Shift down-arrow
Extend selection by one cell left
Shift left-arrow
Select one character left
Shift left-arrow
Extend selection by one cell right
Shift right-arrow
Select one character right
Shift right-arrow
Extend selection by one cell up
Shift up-arrow
Activate or open selected control
Space
Move active cell right in a selection
Tab
Move to next ribbon control
Tab
Move one cell down
down-arrow