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