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
TAB

Move to a previous button

SHIFT TAB
SPACE

Accept and Confirm

ENTER
RETURN

Get help

F1

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
TAB

Move active cell Left in a selection

SHIFT TAB
TAB

General - Excel Shortcuts

Open Help

F1
/

Undo last action

CTRL Z
Z

Redo last action

CTRL Y
Y

Copy selected cells

CTRL C
C

Repeat last action

F4
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
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

F8
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

F2
^ U

Insert OR Edit Comment

SHIFT F2
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

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
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
TAB

Cancel and close the dialog box

ESC
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
SPACE

Formulas - Excel Shortcuts

Toggle Absolute & Relative references

F4
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

F9
Fn F9

Calculate active worksheet

SHIFT F9
Fn F9

Force calculate all worksheets

CTRL ALT F9

Evaluate part of a formula

F9
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

F3

Pivot Table - Excel Shortcuts

Select entire pivot table

CTRL A
A

Toggle pivot table field checkbox

SPACE
SPACE

Group pivot table items

ALT SHIFT
K

Ungroup pivot table items

ALT SHIFT
J

Hide pivot table item

CTRL
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

F6
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

F7
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
?
5% Discount
No prize
30% Discount
Almost!
10% Discount
Almost
70% Discount
No luck today
Almost!
50% Discount
No prize
Unlucky
Get your chance to win a price! on Excel Mastery Program Bundle
Enter your email address and spin the wheel. This is your chance to win amazing Upto 70% discounts!
Our in-house rules:
  • One game per user
  • Cheaters will be disqualified.