Excel Keyboard Shortcuts

Cheat sheet guide

Excel shortcuts worth learning first

This page collects 128 searchable Excel keyboard shortcuts across 5 categories. Start with the shortcuts for Workbook & Files, Navigation, Editing, Formulas, then print the cheat sheet once the important ones are worth keeping nearby.

Create new workbookCtrlN
Move one cell up↑
Edit active cellF2
Start formula=
BoldCtrlB
Open workbookCtrlO

Workbook & Files

13 shortcuts

Create new workbook

CtrlN

Ctrl+N · Cmd+N

Open workbook

CtrlO

Ctrl+O · Cmd+O

Save workbook

CtrlS

Ctrl+S · Cmd+S

Print workbook

CtrlP

Ctrl+P · Cmd+P

Close workbook

CtrlW

Ctrl+W · Cmd+W

Open workbook statistics

CtrlShiftG

Ctrl+Shift+G

Open the macro manager

AltF8

Alt+F8 · Opt+F8

Open the VBA editor

AltF11

Alt+F11 · Opt+F11

Create a workbook from a template

—

Cmd+Shift+P

Save the workbook under a new name

—

Cmd+Shift+S

Insert another worksheet

—

Shift+F11

Toggle full-screen view

—

Cmd+Ctrl+F

Hide the Excel application

—

Cmd+H

Navigation

31 shortcuts

Move one cell up

↑

Move one cell down

↓

Move to edge of data region

CtrlArrow

Go to cell A1

CtrlHome

Ctrl+Home · Fn+Ctrl+←

Go to last used cell

CtrlEnd

Ctrl+End · Fn+Ctrl+→

Next worksheet

CtrlPageDown

Ctrl+PageDown · Fn+Ctrl+↓

Previous worksheet

CtrlPageUp

Ctrl+PageUp · Fn+Ctrl+↑

Move to the previous cell or control

ShiftTab

Shift+Tab

Move one cell left

←

Move one cell right

→

Select through the last used cell

CtrlShiftEnd

Ctrl+Shift+End

Scroll down one screen

PageDown

PageDown

Scroll right one screen

AltPageDown

Alt+PageDown · Opt+PageDown

Scroll up one screen

PageUp

PageUp

Scroll left one screen

AltPageUp

Alt+PageUp · Opt+PageUp

Move to the next cell or control

Tab

Tab

Zoom in on the worksheet

CtrlAlt=

Ctrl+Alt+=

Zoom out on the worksheet

CtrlAlt-

Ctrl+Alt+-

Cycle object display modes

Ctrl6

Ctrl+6

Show or hide outline symbols

Ctrl8

Ctrl+8

Add the next worksheet to the selection

CtrlShiftPageDown

Ctrl+Shift+PageDown

Add the previous worksheet to the selection

CtrlShiftPageUp

Ctrl+Shift+PageUp

Toggle extend-selection mode

F8

Add a separate range to the selection

ShiftF8

Shift+F8

Select the entire column

CtrlSpace

Ctrl+Space

Select the entire row

ShiftSpace

Shift+Space

Select all worksheet objects

CtrlShiftSpace

Ctrl+Shift+Space

Select through the start of the worksheet

CtrlShiftHome

Ctrl+Shift+Home

Select the current data region

CtrlShift8

Ctrl+Shift+8

Move to the next corner of the selection

—

Ctrl+.

Editing

46 shortcuts

Edit active cell

F2

F2 · Ctrl+U

Fill down

CtrlD

Ctrl+D · Cmd+D

Fill right

CtrlR

Ctrl+R · Cmd+R

Insert current date

Ctrl;

Ctrl+;

Insert current time

CtrlShift;

Ctrl+Shift+; · Cmd+;

Undo

CtrlZ

Ctrl+Z · Cmd+Z

Redo

CtrlY

Ctrl+Y · Cmd+Y

Cut selected cells

CtrlX

Ctrl+X · Cmd+X

Copy selected cells

CtrlC

Ctrl+C · Cmd+C

Paste into selected cells

CtrlV

Ctrl+V · Cmd+V

Open cell validation choices

Alt↓

Alt+↓

Add or edit a cell note

ShiftF2

Shift+F2

Add or reply to a threaded comment

CtrlShiftF2

Ctrl+Shift+F2 · Cmd+Shift+F2

Insert blank cells

CtrlShift+

Ctrl+Shift++ · Ctrl+Shift+=

Delete selected cells

Ctrl-

Ctrl+- · Cmd+-

Open Paste Special

CtrlAltV

Ctrl+Alt+V · Cmd+Ctrl+V

Insert a hyperlink

CtrlK

Ctrl+K · Cmd+K

Check worksheet spelling

F7

Open Quick Analysis for selected cells

CtrlQ

Ctrl+Q

Create a table from cells

CtrlL

Ctrl+L · Cmd+T

Paste Special dialog: all content and formatting

A

Paste Special dialog: formulas only

F

Paste Special dialog: values only

V

Paste Special dialog: formatting only

T

Paste Special dialog: comments and notes

C

Paste Special dialog: validation settings

N

Paste Special dialog: all except borders

X

Paste Special dialog: column widths

W

Paste Special dialog: formulas and number formats

R

Paste Special dialog: values and number formats

U

Insert a line break inside a cell

AltEnter

Alt+Enter · Cmd+Opt+Return

Fill the selection with the current entry

CtrlEnter

Ctrl+Enter · Cmd+Return

Finish entry and move to the cell above

ShiftEnter

Shift+Enter

Cancel the current cell entry

Esc

Esc

Finish entry and move to the cell below

Enter

Enter

Run Flash Fill for the current column

CtrlE

Ctrl+E

Copy the value from the cell above

CtrlShift'

Ctrl+Shift+'

Create a chart inside the worksheet

AltF1

Alt+F1

Create a separate chart sheet

F11

F11

Open the Power Query editor

AltF12

Alt+F12 · Opt+F12

Stop an external-data refresh

Esc

Esc

Refresh external data in this worksheet

CtrlF5

Ctrl+F5

Refresh external data in the workbook

CtrlAltF5

Ctrl+Alt+F5

Group selected cells

—

Cmd+Shift+K

Ungroup selected cells

—

Cmd+Shift+J

Open the Sort dialog

—

Cmd+Shift+R

Formulas

20 shortcuts

Start formula

=

AutoSum

Alt=

Alt+= · Cmd+Shift+T

Show formulas

Ctrl`

Ctrl+`

Calculate worksheets

F9

Insert function

ShiftF3

Shift+F3

Copy the formula from the cell above

Ctrl'

Ctrl+'

Toggle formula-checking tips

CtrlAltP

Ctrl+Alt+P · Ctrl+Opt+P

Expand or collapse the formula bar

CtrlShiftU

Ctrl+Shift+U

Move to the end of formula-bar text

CtrlEnd

Ctrl+End

Select formula-bar text through the end

CtrlShiftEnd

Ctrl+Shift+End

Calculate only the active worksheet

ShiftF9

Shift+F9

Force calculation of all open workbooks

CtrlAltF9

Ctrl+Alt+F9

Recheck dependencies and recalculate all cells

CtrlAltShiftF9

Ctrl+Alt+Shift+F9 · Ctrl+Opt+Shift+F9

Open function arguments after a function name

CtrlA

Ctrl+A

Insert function argument names

CtrlShiftA

Ctrl+Shift+A

Cycle absolute and relative formula references

F4

F4 · Cmd+T

Open the list of defined names

F3

Open the Define Name dialog

—

Cmd+F3

Create names from the selection

—

Cmd+Shift+F3

Formatting

18 shortcuts

Bold

CtrlB

Ctrl+B · Cmd+B

Italic

CtrlI

Ctrl+I · Cmd+I

Underline

CtrlU

Ctrl+U · Cmd+U

Format cells dialog

Ctrl1

Ctrl+1 · Cmd+1

Apply percent format

CtrlShift%

Ctrl+Shift+%

Open font settings for cells

CtrlShiftF

Ctrl+Shift+F

Toggle strikethrough in cells

Ctrl5

Ctrl+5 · Shift+Cmd+X

Add an outside cell border

CtrlShift7

Ctrl+Shift+7 · Cmd+Opt+0

Remove outside cell borders

CtrlShift-

Ctrl+Shift+- · Cmd+Opt+-

Apply General number formatting

CtrlShift`

Ctrl+Shift+`

Apply currency formatting

CtrlShift4

Ctrl+Shift+4

Apply scientific number formatting

CtrlShift6

Ctrl+Shift+6

Apply date formatting

CtrlShift3

Ctrl+Shift+3

Apply time formatting

CtrlShift2

Ctrl+Shift+2

Apply a two-decimal number format

CtrlShift1

Ctrl+Shift+1

Center cell contents

—

Cmd+E

Align cell contents to the left

—

Cmd+L

Open the cell-style editor

—

Shift+Cmd+L

Documentation check for this addition

99 additional actions were checked against the official documentation on 2026-11-03. Existing actions were retained. These are documentary checks, not tests in installed applications. A dash means this batch does not provide a verified binding for that system. Context such as PDF viewer, text field or address bar is part of the action.

Excel