Contextures

Home > Skills > Shortcuts > Keyboard

Excel Keyboard Shortcuts

Get a list of Excel keyboard shortcuts, or use the interactive list, shown below. Also see the list of Top Excel Tips, shown below, to help you save time.

keyboard shortcuts for number format

Excel Shortcut Videos

Watch these short videos to see quick ways to get things done with Excel mouse and keyboard shortcuts.

Select a range of cells

Instead of dragging down a long list of data, click the first cell in the range that you want to select. Then, scroll down, press the Shift key, and click on the last cell that you want to select.

Navigate in a range of cells

In a large table, quickly move to the edge of the range with a double-click of the mouse, or a keyboard shortcut.

Copy Across in Filtered List

If you are copying and pasting in the same rows in a filtered list, you can use the shortcut Ctrl + R, to fill right, or use a Ribbon command to fill left

Create a Quick Chart

Use these Excel keyboard shortcuts to quickly create a chart from the selected data. Change the default settings to determine which chart type will be used.

Excel Shortcuts -- Top Tips

Navigate cells

  • Right .......... Tab
  • Start of worksheet ...... Ctrl + Home
  • End of worksheet  ...... Ctrl + End
  • Start of row .......... Home
  • Up/ down screen ... Page Up/ Down

Standard actions

  • Activate menus ........ F10
  • Save .......... Ctrl + S
  • Print .......... Ctrl + P
  • New workbook ..... Ctrl +
  • Open .......... Ctrl + O
  • Copy .......... Ctrl + C
  • Cut .......... Ctrl + X
  • Paste .......... Enter

Copy data

  • Fill down .......... Ctrl + D
  • Fill right .......... Ctrl + R
  • Copy formula above ...Ctrl + '
  • Copy value above ...... Ctrl + "

Format Numbers

  • General ...........Ctrl + ~
  • Currency .........Ctrl + $
  • Percentage ......Ctrl + %
  • Date (d, m, y) ..Ctrl + #

Select

  • Entire Column ...... Ctrl + space
  • Entire Row .......... Shift + space
  • Entire worksheet ..... Ctrl + A

Work in a range

  • Select the current range ...... Ctrl + *
  • Move to range border ....... Ctrl + arrow
  • Move down .......... Enter
  • Move up .......... Shift + Enter
  • Move right .......... Tab
  • Move left .......... Shift + Tab
  • Switch focus to the worksheet from
       range selector in dialog box....F6

Edit worksheet

  • Edit a cell .......... F2
  • Insert .......... Ctrl + +
  • Delete .......... Ctrl + -

Complete actions

  • Repeat last action ......... F4
  • Today’s date .......... Ctrl + ;
  • Chart selected data ....... F11

Apply Formatting

  • Format cells .......... Ctrl + 1
  • Remove borders ...... Ctrl + _

Interactive Excel Shortcuts Table

  • Click a heading cell, to sort by that column.
  • Change the number of items shown per page
  • Type in the Search box to filter the list.

Category

Hold

Press

Keyword

Result

Format Data

Ctrl

0

column

Hide columns

Format Data

Ctrl

1

format

Display the Format Cells dialog box

Format Data

Ctrl + Shift

2

time

Apply Time format

Format Data

Ctrl

5

strikethrough

Apply or remove strikethrough formatting

Select Cells

Ctrl

6

object

Alternate between hiding objects, displaying objects, and displaying placeholders for objects

Select Cells

Ctrl

7

toolbar

Show or hide the Standard toolbar

Outline Data

Ctrl

8

outline

Display or hide outline symbols

Format Data

Ctrl

9

row

Hide rows

Enter Data

Ctrl

'

copy

Copy formula from cell above

Format Data

Alt

'

style

Style dialog box

Format Data

Ctrl + Shift

'

number

Apply number format

Edit Data

Ctrl

-

delete

Delete selection

Format Data

Ctrl + Shift

-

border

Remove outline borders

Format Data

Ctrl + Shift

!

number

Apply Number format with 2 decimal places, thousands separator

Enter Data

Ctrl + Shift

"

copy

Copy value from cell above

Format Data

Ctrl + Shift

#

date

Apply the Date format with the day, month, and year

Format Data

Ctrl + Shift

$

currency

Apply Currency format

Format Data

Ctrl + Shift

%

percent

Apply Percentage format with no decimal places

Format Data

Ctrl + Shift

&

border

Apply the outline border

Format Data

Ctrl + Shift

(

row

Unhide rows

Format Data

Ctrl + Shift

)

column

Unhide columns

Select Cells

Ctrl + Shift

*

region

Select the current region

Move within Selection

Ctrl

.

move

Move clockwise to the next corner of the selection

Select Cells

Ctrl

/

array

Select current array

Enter Data

Ctrl + Shift

;

time

Enter the time

Enter Data

Ctrl

;

date

Enter the date

Select Cells

Alt

;

cells

Select visible cells in current selection

Select Cells

Ctrl

[

dependent

Select direct dependents

Select Cells

Ctrl + Shift

[

dependent

Select all dependents

Select Cells

Ctrl

\

difference

Select differences

Select Cells

Ctrl + Shift

\

unequal

Select unequal cells

Select Cells

Ctrl

]

precedent

Select direct precedents

Select Cells

Ctrl + Shift

]

precedent

Select all precedents

Format Data

Ctrl + Shift

^

number

Apply Exponential number format

Enter Data

Ctrl

`

formula

Toggle formula view

Edit Data

Ctrl + Shift

=

insert

Insert blank cells

Enter Data

Alt

=

AutoSum

Insert the AutoSum formula

Enter Data

Ctrl

A

formula

Display Formula Palette after typing function name in formula

Enter Data

Ctrl + Shift

A

formula

Insert the argument names and parentheses for a function after you type a function name in a formula

Select Cells

Ctrl

A

All

Select the entire worksheet

Enter Data

 

Arrow key

move

Move one character up, down, left, or right

Move and Scroll

Ctrl

Arrow key

move

Move to edge of current region

Move and Scroll

 

Arrow key

move

Move one cell up, down, left, or right

Select Cells

Ctrl + Shift

Arrow Key

select

Extend the selection to the last nonblank cell in the same column or row as the active cell

Select Cells

Shift

Arrow Key

select

Extend the selection by one cell

Format Data

Ctrl

B

bold

Apply or remove bold formatting

Enter Data

 

Backspace

delete

Delete character to left of insertion point, or delete selection

Move and Scroll

Ctrl

Backspace

scroll

Scroll to display the active cell

Select Cells

Shift

Backspace

select

Select only the active cell when multiple cells are selected

Edit Data

Ctrl

C

copy

Copy the selection

Enter Data

Ctrl

D

fill

Fill down

Enter Data

Ctrl

Delete

delete

Delete text to the end of the line

Enter Data

 

Delete

delete

Delete character to right of insertion point, or delete selection

Enter Data

Alt

Down Arrow

AutoComplete

Display the AutoComplete list

Move and Scroll

Ctrl

End

move

Move to the last cell on the worksheet

Select Cells

Ctrl + Shift

End

select

Extend the selection to the last used cell on the worksheet (lower-right corner)

Enter Data

Alt

Enter

line break

Start a new line in the same cell

Enter Data

Ctrl

Enter

fill

Fill the selected cell range with current entry

Enter Data

Ctrl + Shift

Enter

array

Enter formula as array formula

Enter Data

Shift

Enter

complete

Complete cell entry and move up in selection

Enter Data

 

Enter

complete

Complete cell entry and move down in selection

Enter Data

 

Esc

cancel

Cancel a cell entry

Menus

 

Esc

close

Close visible menu or submenu

Windows

Ctrl

Esc

Start

Show the Windows Start menu

Help

 

F1

Help

Open the Help Task pane

Menus

Shift

F10

shortcut

Show a shortcut menu

Menus

 

F10

menu

Make the menu bar active

Windows

Ctrl

F10

maximize

Maximize or restore the workbook window

Charts

 

F11

chart

Create a chart that uses the current range

Macros

Alt

F11

VBE

Display the Visual Basic Editor

Macros

Ctrl

F11

macro

Insert a Microsoft Excel 4.0 macro sheet

Worksheets

Shift

F11

worksheet

Insert a new worksheet

Workbook

Ctrl

F12

open

Display the Open dialog box

Workbook

 

F12

save as

Open the Save As dialog box

Workbook

Shift

F12

save

Save the file

Print

Ctrl + Shift

F12

print

Display the Print dialog box

Charts

Alt

F2

chart

Create a chart that uses the current range

Enter Data

Shift

F2

comment

Edit a cell comment

Enter Data

 

F2

edit

Edit the active cell and position the insertion point at the end of the line

Worksheets

Alt + Shift

F2

worksheet

Insert a new worksheet

Enter Data

Ctrl

F3

name

Define a name

Enter Data

Ctrl + Shift

F3

name

Create names from row and column labels

Enter Data

Shift

F3

function

Paste a function into a formula

Enter Data

 

F3

name

Paste defined name into formula

Enter Data

 

F4

repeat

Repeat the last action

Move and Scroll

Shift

F4

find

Repeat the last Find action (Find Next)

Windows

Ctrl

F4

close

Close the active workbook window

Move and Scroll

Shift

F5

find

Display the Find dialog box

Move and Scroll

 

F5

go to

Display the Go To dialog box

Windows

Ctrl

F5

restore

Restore the active workbook window size

Dialog Box

 

F6

dialog box

In a range selection box, switch focus to the worksheet

Move and Scroll

Ctrl

F6

window

Move to the next workbook or window

Move and Scroll

Ctrl+Shift

F6

window

Move to the previous workbook or window

Move and Scroll

Shift

F6

pane

Move to previous pane in workbook that has been split

Move and Scroll

 

F6

pane

Move to next pane in split workbook

Edit Data

 

F7

spell

Display the Spelling dialog box

Windows

Ctrl

F7

move

Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window

Macros

Alt

F8

macro

Display the Macro dialog box

Select Cells

Shift

F8

select

Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range

Select Cells

 

F8

select

Turn on extending a selection by using the arrow keys

Windows

Ctrl

F8

size

Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window

Enter Data

Ctrl + Alt

F9

calculate

Calculate all sheets in the active workbook

Enter Data

Shift

F9

calculate

Calculate the active worksheet

Enter Data

 

F9

calculate

Calculate all sheets in all open workbooks

Windows

Ctrl

F9

minimize

Minimize the workbook window to an icon

Move and Scroll

Ctrl

Home

move

Move to the beginning of the worksheet

Move and Scroll

 

Home

move

Move to the beginning of the row

Select Cells

Ctrl + Shift

Home

select

Extend the selection to the beginning of the worksheet

Select Cells

Shift

Home

select

Extend the selection to the beginning of the row

Format Data

Ctrl

I

italic

Apply or remove italic formatting

Enter Data

Ctrl

K

hyperlink

Insert a hyperlink

Move within Selection

Ctrl + Alt

Left Arrow

move

Move left between nonadjacent selections

Outline Data

Alt + Shift

Left Arrow

group

Ungroup rows or columns

Select Cells

Ctrl + Shift

O

comment

Select all cells with comments

Print

Ctrl

P

print

Display the Print dialog box

Move and Scroll

Alt

Page Down

move

Move one screen to the right

Move and Scroll

Ctrl

Page Down

move

Move to the next sheet in the workbook

Move and Scroll

 

Page Down

move

Move down one screen

Select Cells

Shift

Page Down

select

Extend the selection down one screen

Worksheets

Ctrl + Shift

Page Down

select

Select current and next sheet in workbook

Move and Scroll

Alt

Page Up

move

Move one screen to the left

Move and Scroll

Ctrl

Page Up

move

Move to the previous sheet in the workbook

Move and Scroll

 

Page Up

move

Move up one screen

Select Cells

Shift

Page Up

select

Extend the selection up one screen

Worksheets

Ctrl + Shift

Page Up

select

Select current and previous in workbook

Windows

Alt

Print Screen

copy

Copy the image of the active window to the Clipboard

Windows

 

Print Screen

copy

Copy the image of the screen to the Clipboard

Enter Data

Ctrl

R

fill

Fill to the right

Move within Selection

Ctrl + Alt

Right Arrow

move

Move right between nonadjacent selections

Outline Data

Alt + Shift

Right Arrow

group

Group rows or columns

Menus

Alt

Spacebar

menu

Show control menu

Select Cells

Ctrl

Spacebar

column

Select the entire column

Select Cells

Ctrl + Shift

Spacebar

objects

With an object selected, select all objects on a sheet

Select Cells

Shift

Spacebar

row

Select the entire row

Move and Scroll

Ctrl

Tab

window

Move to the next workbook or window

Move and Scroll

Ctrl+Shift

Tab

window

Move to the previous workbook or window

Move within Selection

Shift

Tab

left

Move left

Move within Selection

 

Tab

right

Move right

Windows

Alt

Tab

program

Switch to the next program

Windows

Alt + Shift

Tab

program

Switch to the previous program

Format Data

Ctrl

U

underline

Apply or remove an underline

Edit Data

Ctrl

V

paste

Paste the selection

Windows

Ctrl

W

close

Close the active workbook window

Edit Data

Ctrl

X

cut

Cut the selection

Enter Data

Ctrl

Y

repeat

Repeat the last action

Edit Data

Ctrl

Z

undo

Undo the last action

Download List of Shortcuts

1. Download the pdf file: Excel Tips and Keyboard Shortcuts.

2. Download the zipped Excel file: Excel keyboard shortcuts

Pivot Table Shortcuts

 

 

Last updated: May 10, 2023 12:32 PM