300 Excel keyboard shortcuts for PC and Mac in 2016

Source By: exceljet.net

Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. See also: The 54 Excel shortcuts you really should know and Excel shortcuts on the Mac.

Download PDF Laminated card Video Training

File

Create new workbook

CtrlN

⌘N

Open workbook

CtrlO

⌘O

Save workbook

CtrlS

⌘S

Save as

F12

⌘⇧S

Print file

CtrlP

⌘P

Open print preview window

CtrlF2

Close current workbook

CtrlF4

⌘W

Close Excel

AltF4

⌘Q

Ribbon

Expand or collapse ribbon

CtrlF1

⌘⌥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

General

Open help

F1

⌘/

Undo last action

CtrlZ

⌘Z

Redo last action

CtrlY

⌘Y

Copy selected cells

CtrlC

⌘C

Repeat last action

F4

⌘Y

Cut selected cells

CtrlX

⌘X

Paste content from clipboard

CtrlV

⌘V

Display the Paste Special dialog box

CtrlAltV

⌃⌘V

Display find and replace

CtrlF

⌘F

Display find and replace, replace selected

CtrlH

⌃H

Find previous match

CtrlShiftF4

⌘⇧G

Find next match

ShiftF4

⌘G

Create embedded chart

AltF1

Fn⌥F1

Create chart in new worksheet

F11

FnF11

Toggle Autofilter

CtrlShiftL

⌘⇧F

Activate filter

Alt↓

⌥↓

Insert table

CtrlT

⌃T

Select table row

ShiftSpace

⇧Space

Select table column

CtrlSpace

⌃Space

Select table

CtrlA

⌘A

Drag and Drop

Drag and cut

drag

drag

Drag and copy

Ctrldrag

⌥drag

Drag and insert

Shiftdrag

⇧drag

Drag and insert copy

CtrlShiftdrag

⌥⇧drag

Drag to worksheet

Altdrag

⌘drag

Drag to duplicate worksheet

Ctrldrag

⌥drag

Navigation

Move one cell right

→

→

Move one cell left

←

←

Move one cell up

↑

↑

Move one cell down

↓

↓

Move one screen right

AltPgDn

Fn⌥↓

Move one screen left

AltPgUp

Fn⌥↑

Move one screen up

PgUp

Fn↑

Move one screen down

PgDn

Fn↓

Move to right edge of data region

Ctrl→

⌃→

Move to left edge of data region

Ctrl←

⌃←

Move to top edge of data region

Ctrl↑

⌃↑

Move to bottom edge of data region

Ctrl↓

⌃↓

Move to beginning of row

Home

Fn←

Move to last cell in worksheet

CtrlEnd

Fn⌃→

Move to first cell in worksheet

CtrlHome

Fn⌃←

Turn End mode on

End

Fn→

Selection

Select entire row

ShiftSpace

⇧Space

Select entire column

CtrlSpace

⌃Space

Select entire worksheet

CtrlA

⌘A

Add adjacent cells to selection

ShiftClick

⇧Click

Add non-adjacent cells to selection

CtrlClick

⌘Click

Same selection in next column

⌥Tab

Same selection in previous column

⌥⇧Tab

Move right between non-adjacent selections

CtrlAlt→

⌃⌥→

Move left between non-adjacent selections

CtrlAlt←

⌃⌥←

Toggle add to selection mode

ShiftF8

Fn⇧F8

Cancel selection

Esc

Esc

Active Cell

Select active cell only

ShiftBackspace

⇧Delete

Show the active cell on worksheet

CtrlBackspace

⌘Delete

Move active cell clockwise in selection

Ctrl.

⌃.

Move active cell down in selection

Enter

Return

Move active cell up in selection

ShiftEnter

⇧Return

Move active cell right in a selection

Tab

Tab

Move active cell left in a selection

ShiftTab

⇧Tab

Extend Selection

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

CtrlShift→

⌃⇧→

Extend the selection to the last cell left

CtrlShift←

⌃⇧←

Extend the selection to the last cell up

CtrlShift↑

⌃⇧↑

Extend the selection to the last cell down

CtrlShift↓

⌃⇧↓

Extend selection up one screen

ShiftPgUp

Fn⇧↑

Extend selection down one screen

ShiftPgDn

Fn⇧↓

Extend selection right one screen

AltShiftPgDn

Fn⇧⌘↓

Extend selection left one screen

AltShiftPgUp

Fn⇧⌘↑

Extend selection to start of row

ShiftHome

Fn⇧←

Extend selection to first cell in worksheet

CtrlShiftHome

Fn⌃⇧←

Extend selection to last cell in worksheet

CtrlShiftEnd

Fn⌃⇧→

Toggle extend selection mode

F8

FnF8

Select Special

Display 'Go To' dialog box

CtrlG

⌃G

Select cells with comments

CtrlShiftO

Fn⌃⇧O

Select current region around active cell

CtrlShift*

⇧⌃Space

Select current region

CtrlA

⌘A

Select current array

Ctrl/

⌃/

Select row differences

Ctrl\

⌃\

Select column differences

CtrlShift|

⌃⇧|

Select direct precedents

Ctrl[

⌃[

Select all precedents

CtrlShift{

⌃⇧{

Select direct dependents

Ctrl]

⌃]

Select all dependents

CtrlShift}

⌃⇧}

Select visible cells only

Alt;

⌘⇧Z

Cell edit mode

Edit the active cell

F2

⌃U

Insert or edit comment

ShiftF2

Fn⇧F2

Cancel entry

Esc

Esc

Select one character right

Shift→

⇧→

Select one character left

Shift←

⇧←

Move one word right

Ctrl→

⌃→

Move one word left

Ctrl←

⌃←

Select one word right

CtrlShift→

⌃⇧→

Select one word left

CtrlShift←

⌃⇧←

Select to beginning of cell

ShiftHome

Fn⇧←

Select to end of cell

ShiftEnd

Fn⇧→

Delete to end of line

CtrlDelete

⌃Delete

Delete character to the left of cursor

Backspace

Delete

Delete character to the right of cursor

Delete

FnDelete

Start a new line in the same cell

AltEnter

⌃⌥Return

Entering data

Enter and move down

Enter

Return

Enter and move up

ShiftEnter

⇧Return

Enter and move right

Tab

Tab

Enter and move left

ShiftTab

⇧Tab

Complete entry and stay in same cell

CtrlEnter

⌃Return

Enter same data in multiple cells

CtrlEnter

⌃Return

Insert current date

Ctrl;

⌃;

Insert current time

CtrlShift:

⌃⇧:

Fill down from cell above

CtrlD

⌃D

Fill right from cell left

CtrlR

⌃R

Copy formula from cell above

Ctrl'

⌃'

Copy value from cell above

CtrlShift"

⌃⇧"

Add hyperlink

CtrlK

⌘K

Display AutoComplete list

Alt↓

⌥↓

Flash fill

CtrlE

Formatting

Format (almost) anything

Ctrl1

⌘1

Display Format Cells with Font tab selected

CtrlShiftF

⌃⇧F

Apply or remove bold formatting

CtrlB

⌘B

Apply or remove italic formatting

CtrlI

⌘I

Apply or remove underscoring

CtrlU

⌘U

Apply or remove strikethrough formatting

Ctrl5

⌘⇧X

Add or remove the shadow font style

 

⌘⇧W

Add or remove the outline font style

 

⌘⇧D

Align center

AltHAC

⌘E

Align left

AltHAL

⌘L

Align right

AltHAR

⌘R

Indent

AltH6

⌃⌥Tab

Remove indent

AltH5

⌃⌥⇧Tab

Increase font size one step

AltHFG

⌘⇧>

Decrease font size one step

AltHFK

⌘⇧<

Number Formatting

Apply general format

CtrlShift~

⌃⇧~

Apply currency format

CtrlShift$

⌃⇧$

Apply percentage format

CtrlShift%

⌃⇧%

Apply scientific format

CtrlShift^

⌃⇧^

Apply date format

CtrlShift#

⌃⇧#

Apply time format

CtrlShift@

⌃⇧@

Apply number format

CtrlShift!

⌃⇧!

Borders

Add border outline

CtrlShift&

⌘⌥0

Add or remove border right

AltR

⌘⌥→

Add or remove border left

AltL

⌘⌥←

Add or remove border top

AltT

⌘⌥↑

Add or remove border bottom

AltB

⌘⌥↓

Add or remove border upward diagonal

AltD

Add or remove border horizontal interior

AltH

Add or remove border vertical interior

AltV

Remove borders

CtrlShift_

⌘⌥_

Formulas

Toggle absolute and relative references

F4

⌘T

Open the Insert Function Dialog Box

ShiftF3

Fn⇧F3

Autosum selected cells

Alt=

⌘⇧T

Toggle formulas on and off

Ctrl`

⌃`

Insert function arguments

CtrlShiftA

⌃⇧A

Enter array formula

CtrlShiftEnter

⌃⇧Return

Calculate worksheets

F9

FnF9

Calculate active worksheet

ShiftF9

Fn⇧F9

Force calculate all worksheets

CtrlAltF9

Evaluate part of a formula

F9

FnF9

Expand or collapse the formula bar

CtrlShiftU

⌃⇧U

Display function arguments dialog box

CtrlA

⌃A

Define name

CtrlF3

Fn⌃F3

Define name using row and column labels

CtrlShiftF3

Fn⌃ShiftF3

Paste name into formula

F3

Accept function with autocomplete

Tab

↓Tab

Grid Operations

Display Insert Dialog box

CtrlShift+

⌃I

Insert rows

CtrlShift+

⌃I

Insert columns

CtrlShift+

⌃I

Display Delete dialog box

Ctrl-

⌃-

Delete rows

Ctrl-

⌃-

Delete columns

Ctrl-

⌃-

Delete cells

Ctrl-

⌃-

Delete contents of selected cells

Delete

FnDelete

Hide columns

Ctrl0

⌃0

Hide rows

Ctrl9

⌃9

Unhide rows

CtrlShift9

⌃⇧9

Unhide columns

CtrlShift0

⌃⇧0

Group rows or columns

AltShift→

⌘⇧K

Ungroup rows or columns

AltShift←

⌘⇧J

Open Group Dialog Box

AltShift→

⌘⇧K

Open Ungroup Dialog Box

AltShift←

⌘⇧J

Hide or show outline symbols

Ctrl8

⌃8

Pivot Tables

Select entire pivot table

CtrlA

⌘A

Toggle pivot table field checkbox

Space

Space

Group pivot table items

AltShift→

⌘⇧K

Ungroup pivot table items

AltShift←

⌘⇧J

Hide pivot table item

Ctrl-

Ctrl-

Create pivot chart on same worksheet

AltF1

Create pivot chart on new worksheet

F11

FnF11

Open pivot table wizard

AltDP

⌘⌥P

Workbook

Insert new worksheet

ShiftF11

fn⇧F11

Go to next worksheet

CtrlPgDn

Fn⌃↓

Go to previous worksheet

CtrlPgUp

Fn⌃↑

Move to next pane

F6

FnF6

Move to previous pane

ShiftF6

Fn⇧F6

Go to next workbook

CtrlTab

⌃Tab

Go to previous workbook

CtrlShiftTab

⌃⇧Tab

Minimize current workbook window

CtrlF9

⌘M

Maximize current workbook window

CtrlF10

fn⌃F10

Select adjacent worksheets

ShiftClick

⇧Click

Select non-adjacent worksheets

CtrlClick

⌘Click

Toggle scroll lock

ScrLk

Fn⇧F14

Dialog boxes

Move to next control

Tab

Tab

Move to previous control

ShiftTab

⇧Tab

Move to next tab

CtrlTab

⌃Tab

Move to previous tab

CtrlShiftTab

⌃⇧Tab

Accept and apply

Enter

Return

Check and uncheck box

Space

Space

Cancel and close the dialog box

Esc

Esc

Other

Open Spelling dialog box

F7

FnF7

Open Thesaurus dialog box

ShiftF7

Fn⇧F7

Open Macro dialog box

AltF8

Fn⌥F8

Open VBA Editor

AltF11

Fn⌥F11

Duplicate object

CtrlD

⌘D

Snap to grid

Alt

⌘

Hide or show objects

Ctrl6

⌃6

Display Modify Cell Style dialog box

Alt'

⌘⇧L

Display shortcut menu

ShiftF10

Fn⇧F10

Display control menu

AltSpace

?

Can we ask you a favor? Can you please share this page if it's useful to you? Thanks!