200 MS Excel Shortcuts for Windows & Mac

I hope you must have learned Excel Shortcut Keys or at least you must have found your daily used shortcut which can be used in your daily life. There is also a Huge list of Excel Formula Shortcuts. This is based on our experience with consulting and interacting with 30,000+ students in the classroom sessions.

There are many more function keys in Excel 2007, Excel 2010 Excel 2016. But the running Basic Excel shortcuts keys which come in our daily use and save time in our daily routines are included.

File - Excel Shortcuts

Create new workbook

CTRL N

⌘ N

Open workbook

CTRL O

⌘ O

Save workbook

CTRL S

⌘ S

Save as

F12

⌘ ⇧ S

Print Excel sheet

CTRL P

⌘ P

Open print preview window

CTRL F2

Close current window

CTRL W

⌘ W

Close Excel

ALT F4

⌘ Q

Ribbon - Excel Shortcuts

Expand or collapse

CTRL F1

⌘ ⌥ R

Excel hot keys

ALT

Move to Next Ribbon Control

TAB

Move to a previous button

SHIFT TAB

SPACE

Accept and Confirm

ENTER

RETURN

Get help

Active Cell - Excel Shortcuts

Select active cell only

SHIFT BACKSPACE

⇧ DELETE

Show active cell on a 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

Move active cell Left in a selection

SHIFT TAB

⇧ TAB

General - Excel Shortcuts

Open Help

⌘ /

Undo last action

CTRL Z

⌘ Z

Redo last action

CTRL Y

⌘ Y

Copy selected cells

CTRL C

⌘ C

Repeat last action

⌘ Y

Cut selected cells

CTRL X

⌘ X

Paste content from clipboard

CTRL V

⌘ V

Display Paste Special

ALT E S

⌘ ^ V

Display Find and Replace

CTRL F

⌘ F

Find with Replace selected

CTRL H

^ H

Find previous match

CTRL SHIFT F4

⌘ ⇧ G

Find next match

SHIFT F4

⌘ G

Create Embedded Chart

ALT F1

Fn ⌥ F1

Create chart in new worksheet

F11

Fn F11

Toggle auto filter

CTRL SHIFT L

⌘ ⇧ F

Activate filter Dropdown

ALT ↓

⌥ ↓

Insert table

CTRL T

^ T

Select table row

SHIFT SPACE

⇧ SPACE

Select table column

CTRL SPACE

^ SPACE

Select table

CTRL A

⌘ A

Selection - Excel Shortcuts

Select entire row

SHIFT SPACE

⇧ SPACE

Select entire column

CTRL SPACE

^ SPACE

Select entire worksheet

CTRL A

⌘ A

Toggle add to selection mode

SHIFT F8

Fn ⇧ F8

Cancel selection

ESC

Navigation - Excel Shortcuts

Move one cell right

→

Move one cell left

←

Move one cell up

↑

Move one cell down

↓

Move one screen Right

ALT Pg Dn

Fn ⌥ ↓

Move one screen left

ALT Pg Up

Fn ⌥ ↑

Move one screen up

Pg Up

Fn ↑

Move one screen down

Pg Dn

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

CTRL END

Fn ^ →

Move to first cell in worksheet

CTRL HOME

Fn ^ ←

Turn End mode on

END

Fn →

Number Formatting - Excel Shortcuts

Apply general format

CTRL SHIFT ~

^ ⇧ ~

Apply Currency Format

CTRL SHIFT $

^ ⇧ $

Apply Percentage Format

CTRL SHIFT %

^ ⇧ %

Apply Scientific Format

CTRL SHIFT ^

^ ⇧ ^

Apply Date Format

CTRL SHIFT #

^ ⇧ #

Apply Time Format

CTRL SHIFT @

^ ⇧ @

Apply Number Format

CTRL SHIFT !

^ ⇧ !

Extend Selection (ES) - Excel Shortcuts

ES by One Cell Right

SHIFT →

⇧ →

ES by One Cell Left

SHIFT ←

⇧ ←

ES by One cell Up

SHIFT ↑

⇧ ↑

ES by One Cell Down

SHIFT ↓

⇧ ↓

ES to the last Cell Right

CTRL SHIFT →

^ ⇧ →

ES to the last Cell Left

CTRL SHIFT ←

^ ⇧ ←

ES to the last Cell Up

CTRL SHIFT ↑

^ ⇧ ↑

ES to the Last Cell Down

CTRL SHIFT ↓

^ ⇧ ↓

ES Up One Screen

SHIFT Pg Up

Fn ⇧ ↑

ES Down One Screen

SHIFT Pg Dn

Fn ⇧ ↓

ES Right One Screen

ALT SHIFT Pg Dn

Fn ⇧ ⌥ ↓

ES Left One Screen

ALT SHIFT Pg Up

Fn ⇧ ⌥ ↑

ES to Start of Row

SHIFT HOME

Fn ⇧ ←

ES to the First Cell in the worksheet

CTRL SHIFT HOME

Fn ^ ⇧ ←

ES to the last cell in the Worksheet

CTRL SHIFT END

Fn ^ ⇧ →

Toggle ES Mode

Fn F8

Select Special - Excel Shortcuts

Display ‘Go To’ Dialog Box

CTRL G

^ G

Select Row Differences

CTRL \

^ \

Select Column Differences

CTRL SHIFT |

^ ⇧ |

Select Cells with Comments

CTRL SHIFT O

Fn ^ ⇧ O

Select Current Region

CTRL A

⌘ A

Select Current Array

CTRL /

^ /

Select Direct Precedents

CTRL [

^ [

Select All Precedents

CTRL SHIFT {

^ ⇧ {

Select Direct Dependents

CTRL ]

^ ]

Select All Dependents

CTRL SHIFT }

^ ⇧ }

Select Visible Cells Only

ALT ;

⌘ ⇧ Z

Cell Edit Mode - Excel Shortcuts

Edit the Active Cell

^ U

Insert OR Edit Comment

SHIFT F2

Fn ⇧ F2

Cancel Entry

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

CTRL SHIFT →

^ ⇧ →

Select to Beginning of cell

SHIFT HOME

Fn ⇧ ←

Select to End of the Cell

SHIFT END

Fn ⇧ →

Delete Character to the Left of Cursor

BACKSPACE

DELETE

Delete Character to the Right of Cursor

DELETE

Fn DELETE

Start a new line in the same cell

ALT ENTER

^ ⌥ RETURN

Entering Data - Excel Shortcuts

Enter and Move down

ENTER

RETURN

Enter and Move up

SHIFT ENTER

⇧ RETURN

Enter and Move right

TAB

Enter and Move left

SHIFT TAB

⇧ TAB

Enter same data in multiple cells

CTRL ENTER

^ RETURN

Insert Current Date

CTRL ;

^ ;

Insert current time

CTRL SHIFT :

⌘ ;

Fill down from cell above

CTRL D

^ D

Fill right from cell left

CTRL R

^ R

Copy formulas from cell above

CTRL ‘

^ ‘

Copy value from cell above

CTRL SHIFT “

^ ⇧ “

Add Hyperlink

CTRL K

⌘ K

Display auto complete list

ALT ↓

⌥ ↓

Flash Fill

CTRL E

Formatting - Excel Shortcuts

Format (almost) anything

CTRL 1

⌘ 1

Display format cells font tab

CTRL SHIFT F

^ ⇧ F

Apply or Remove bold formatting

CTRL B

⌘ B

Apply or Remove italic formatting

CTRL I

⌘ I

Apply or Remove Underscoring

CTRL U

⌘ U

Toggle strike through formatting

CTRL 5

⌘ ⇧ X

Align Center

ALT H A C

⌘ E

Align Left

ALT H A L

⌘ L

Align Right

ALT H A R

⌘ R

Indent

ALT H 6

^ ⌥ TAB

Remove Indent

ALT H 5

^ ⌥ ⇧ TAB

Increase font size one step

ALT H FG

⌘ ⇧ >

Decrease font size one step

ALT H FK

⌘ ⇧ <

Borders - Excel Shortcuts

Add Border Outline

CTRL SHIFT &

⌘ ⌥ 0

Add OR Remove Border Right

ALT R

⌘ ⌥ →

Add OR Remove Border Left

ALT L

⌘ ⌥ ←

Add OR Remove Border Top

ALT T

⌘ ⌥ ↑

Add OR Remove Border Bottom

ALT B

⌘ ⌥ ↓

Add OR Remove Border Upward Diagonal

ALT D

Add OR Remove Border Horizontal Interior

ALT H

Remove Borders

CTRL SHIFT _

⌘ ⌥ _

Dialog Boxes - Excel Shortcuts

Move to Next Control

TAB

Cancel and close the dialog box

ESC

Toggle between open books

CTRL TAB

⇧ TAB

Move to previous tab

CTRL SHIFT TAB

^ ⇧ TAB

Accept and apply

ENTER

RETURN

Check and Uncheck box

SPACE

Formulas - Excel Shortcuts

Toggle Absolute & Relative references

⌘ T

Open Insert function dialog

SHIFT F3

Fn ⇧ F3

AutoSum selected cells

ALT =

⌘ ⇧ T

Toggle formulas on and off

CTRL ‘

^ ‘

Enter Array formula

CTRL SHIFT ENTER

^ ⇧ RETURN

Calculate worksheets

Fn F9

Calculate active worksheet

SHIFT F9

Fn ⇧ F9

Force calculate all worksheets

CTRL ALT F9

Evaluate part of a formula

Fn F9

Expand/Collapse formula bar

CTRL SHIFT U

^ ⇧ U

Display function arguments dialog box

CTRL A

^ A

Define name

CTRL F3

Fn ^ F3

Define names form lables

CTRL SHIFT F3

Fn ^ ⇧ F3

Paste name into formula

Pivot Table - Excel Shortcuts

Select entire pivot table

CTRL A

⌘ A

Toggle pivot table field checkbox

SPACE

Group pivot table items

ALT SHIFT →

⌘ ⇧ K

Ungroup pivot table items

ALT SHIFT ←

⌘ ⇧ J

Hide pivot table item

CTRL –

Create pivot chart on same worksheet

ALT F1

Open pivot table wizard

ALT D P

⌘ ⌥ P

Insert calculated field

CTRL SHIFT +

Create pivot chart on new worksheet

F11

Fn F11

Grid Operations - Excel Shortcuts

Display insert dialog box

CTRL SHIFT +

⌘ ⇧ +

Insert rows

CTRL SHIFT +

⌘ ⇧ +

Insert columns

CTRL SHIFT +

⌘ ⇧ +

Display delete dialog box

CTRL –

⌘ –

Delete rows

CTRL –

⌘ –

Delete columns

CTRL –

⌘ –

Delete cells

CTRL –

⌘ –

Delete contents of selected cells

DELETE

Fn DELETE

Hide columns

CTRL 0

^ 0

Hide rows

CTRL 9

^ 9

Unhide rows

CTRL SHIFT 9

^ ⇧ 9

Unhide columns

CTRL SHIFT 0

^ ⇧ 0

Group rows or columns

ALT SHIFT →

⌘ ⇧ K

Ungroup rows or columns

ALT SHIFT ←

⌘ ⇧ J

Open group dialog box

ALT SHIFT →

⌘ ⇧ K

Open ungroup dialog box

ALT SHIFT ←

⌘ ⇧ J

Hide or show outline symbols

CTRL 8

^ 8

Workbook - Excel Shortcuts

Insert new worksheet

SHIFT F11

Fn ⇧ F11

Go to next worksheet

CTRL Pg Dn

Fn ^ ↓

Go to previous worksheet

CTRL Pg Up

Fn ^ ↑

Move to next pane

Fn F6

Move to previous pane

SHIFT F6

Fn ⇧ F6

Go to next workbook

CTRL TAB

^ TAB

Go to previous workbook

CTRL SHIFT TAB

^ ⇧ TAB

Minimize current workbook window

CTRL F9

⌘ M

Maximize current workbook window

CTRL F10

Fn ^ F10

Toggle scroll lock

SCROLL LOCK

Fn ⇧ F14

Others - Excel Shortcuts

Open spelling dialog box

Fn F7

Open thesaurus dialog box

SHIFT F7

Fn ⇧ F7

Open macro dialog box

ALT F8

Fn ⌥ F8

Open VBA editor

ALT F11

Fn ⌥ F11

Duplicate object

CTRL D

⌘ D

Snap to grid

ALT

⌘

Hide or show objects

CTRL 6

^ 6

Display modify cell style

ALT ‘

⌘ ⇧ L

Display shortcuts menu

SHIFT F10

Fn ⇧ F10

Display control menu

ALT SPACE