Excel Keyboard Shortcuts

Excel Keyboard Shortcuts thumbnail
Jump to:
Formatting Shortcuts | Navigation and Display Shortcuts | Formulas and Functions Shortcuts

Selection and Editing

Adds other nonadjacent cells or ranges to the selection

ShiftF8

Adds to the selection (toggle)

ShiftF8

Cancels the editing

Esc

Deletes all characters from the cursor to the end of the line

CtrlDelete

Deletes the character to the left of the cursor

Backspace

Deletes the character to the right of the cursor

Delete

Open the shortcut menu

ShiftF10

Edits a cell comment

ShiftF2

Edits the active cell

F2

Same as clicking the Edit Menu and selecting Copy

CtrlC

Same as clicking the Edit Menu and selecting Copy

CtrlInsert

Same as clicking the Edit Menu and selecting Cut

CtrlX

Same as clicking the Edit Menu and selecting Fill Down

CtrlD

Same as clicking the Edit Menu and selecting Fill Right

CtrlR

Same as clicking the Edit Menu and selecting Find

CtrlF

Same as clicking the Edit Menu and selecting Paste

CtrlV

Same as clicking the Edit Menu and selecting Paste

ShiftInsert

Same as clicking the Edit Menu and selecting Replace

CtrlH

Same as clicking the Edit Menu and selecting Undo

AltBackspace

Same as clicking the Edit Menu and selecting Undo

CtrlZ

Same as clicking the Edit Menu and selecting New

CtrlN

Same as clicking the Edit Menu and selecting Open

CtrlO

Same as clicking the Edit Menu and selecting Print

CtrlP

Same as clicking the Edit Menu and selecting Save

CtrlS

Same as clicking the Format Menu and selecting Style

Alt'

Same as clicking the Insert Menu and selecting Hyperlink

CtrlK

Exits the program

AltF4

Expands the selection in the direction indicated

Shiftarrow key

Expands the selection to the beginning of the current row

ShiftHome

Extends the selection as navigation keys are used

F8

Repeats the last Find (Find Next)

ShiftF4

Formatting

Adds border to outline

CtrlShift&

Adds the comma format with two decimal places

CtrlShift!

Adds the currency format with two decimal places

CtrlShift$

Adds the date format (day, month, year)

CtrlShift#

Adds the general number format

CtrlShift~

Adds the percent format with no decimal places

CtrlShift%

Adds the time format (hour, minute, a.m./p.m.)

CtrlShift@

Sets or removes boldface

CtrlB

Sets or removes italic

CtrlInsert

Sets or removes strikethrough

Ctrl5

Sets or removes underlining

CtrlU

Removes all borders

CtrlShift_

Navigation and Display

Closes the window

CtrlF4

Cycles through the ways to display objects

Ctrl6

Defines a name

CtrlF3

Global calculation

CtrlAltF9

Hides columns

Ctrl0(zero)

Hides rows

Ctrl9

Inserts a chart sheet

AltF1

Inserts a new worksheet

AltShiftF1

Inserts a new worksheet

ShiftF11

Opens and Displays the Creates Names dialog box

CtrlShiftF3

Opens and Displays the Find dialog box

ShiftF5

Opens and Displays the Format dialog box for the selected object

Ctrl1

Opens and Displays the Go To dialog box

F5

Opens and Displays the Macro dialog box

AltF8

Opens and Displays the What's This cursor

ShiftF1

Opens and Displays Visual Basic Editor

AltF11

Prompts Open command

CtrlF12

Prompts Print command

CtrlShiftF12

Prompts Save As command

AltF2

Prompts Save As command

F12

Prompts Save command

AltShiftF2

Prompts Spelling command

F7

Makes the menu bar active

F10

Maximizes or restores the workbook window

CtrlF10

Minimizes the workbook

CtrlF9

Moves down one screen

PgDn

Moves one screen to the left

AltPgUp

Moves one screen to the right

AltPgDn

Moves the cell pointer left to the preceding cell in the selection

ShiftTab

Moves the cell pointer right to the next cell

Tab

Moves the cell pointer to the next corner of the current cell range

Ctrl.(period)

Moves the cell pointer up to the preceding cell in the selection

ShiftEnter

Moves the cursor one character in the direction of the arrow

Arrow keys

Moves the cursor one word to the left

Ctrlleft arrow

Moves the cursor one word to the right

Ctrlright arrow

Moves the cursor to the end of the line

End

Opens and Displays Help or the Office Assistant

F1

Begins editing the active cell

F2

Pastes a name into a formula

F3

Repeats the last action

F4

Moves to the next pane

F6

Extends the selection as navigation keys are used

F8

Calculates all sheets in all open workbooks

F9

Makes the menu bar active

F10

Creates a chart

F11

Issues Save As command

F12

Moves to the beginning of the row

Home

Moves to the edge of a data block

Ctrlarrow key

Moves to the first cell in the worksheet (A1)

CtrlHome

Moves to the last active cell of the worksheet

CtrlEnd

Moves to the lower-left cell displayed in the window

End*

Moves to the next sheet

CtrlPgDn

Moves to the next window

CtrlF6

Moves to the next window

CtrlTab

Moves to the previous pane of a window that has been split

ShiftF6

Moves to the previous sheet

CtrlPgUp

Moves to the previous window

CtrlShiftTab

Moves to the previous workbook window

CtrlShiftF6

Moves to the upper-left cell displayed in the window

Home*

Moves up one screen

PgUp

Resizes the window

CtrlF8

Restores the window size

CtrlF5

Scrolls left, right, up or down one cell

Arrow keys

Scrolls to display the active cell

CtrlBackspace

Selects all

CtrlA

Selects the active cell in a range selection

ShiftBackspace

Selects the block of data surrounding the active cell

Ctrl*

Selects the entire column(s) in the selected range

CtrlSpace

Selects the entire row(s) in the selected range

ShiftSpace

Selects the entire worksheet

CtrlShiftSpace

Starts a new line in the current cell

AltEnter

Toggles the display of outline symbols

Ctrl8

Toggles the display of the standard toolbar

Ctrl7

Unhides columns

CtrlShift)

Unhides rows

CtrlShift(

Formulas and Functions

Enters the current date

Ctrl;

Enters the current time

CtrlShift:

Inserts the AutoSum formula in an empty cell

Alt=

Pastes a function into a formula

ShiftF3

Prompts for a range or range name to select

CtrlG

Automatically SUM a column

Alt=Enter

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Related Excel® Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories