Voir iotafinance en FrançaisYou are viewing the English version of iotafinance.comIotafinance auf Deutsch sehen
Icon for the financial resource section

Keyboard shortcuts in Excel for Windows

EDITING

Add current date
Ctrl  +  Shift  +   .

Add current time
Ctrl  +  Shift  +   :

Copy
Ctrl  +   C

Copy formula from the cell above into the active cell
Ctrl  +   '

Copy value from the cell above into the active cell
Ctrl  +  Shift  +  


Define a name for a cell
Ctrl  +   F3

Display shortcut menu
Shift  +   F10

Edit active cell
F2

Fill down
Ctrl  +   D

Fill right
Ctrl  +   R

Insert a function
Shift  +   F3

Insert a threaded comment
Ctrl  +  Shift  +   F2

Insert column left to the selected column
Ctrl  +   +

Insert or edit cell comments
Shift  +   F2

Insert row above the selected row
Ctrl  +   +

Insert worksheet
Shift  +   F11

Open dialog to insert a hyperlink
Ctrl  +   K

Open the list of validation choices on a cell that uses data validation
Alt  +   Arrow down

Paste
Ctrl  +   V

Paste name into formula
F3

Paste special
Alt  ,   E   ,   S

Start new line within cell
Alt  +   Enter

Sum selected cells
Alt  +   =

Table creation dialog
Ctrl  +   T

Toggle references
F4

FORMATTING

Apply currency format with two decimal places
Ctrl  +   $

Apply date format
Ctrl  +  Shift  +   #

Apply general number format
Ctrl  +  Shift  +   ~

Apply number format with two decimal places
Ctrl  +  Shift  +   !

Apply outline border to selected cell(s)
Ctrl  +  Shift  +   &

Apply percentage format with no decimal places
Ctrl  +  Shift  +   %

Apply scientific number format
Ctrl  +  Shift  +   ^

Bold characters
Ctrl  +   2

Bold characters
Ctrl  +   B

Display format cells menu
Ctrl  +   1

Font formatting dialog
Ctrl  +  Shift  +   P

Italic characters
Ctrl  +   3

Italic characters
Ctrl  +   I

Remove outline border from selected cell(s)
Ctrl  +  Shift  +   _

Strikethrough
Ctrl  +   5

Underline text
Ctrl  +   4

Underline text
Ctrl  +   U

NAVIGATE

Display «Go to» dialog box
F5

Move one cell down

Move one cell to the left

Move one cell to the right

Move one cell to the right in a worksheet
Tab

Move one cell up

Move one screen height down in a worksheet

Move one screen height up in a worksheet

Move one screen width to the left in a worksheet
Alt  +   Page Up

Move one screen width to the right in a worksheet
Alt  +   Page Down

Move to left edge of current data region
Ctrl  +   Arrow left

Move to lower edge of current data region
Ctrl  +   Arrow down

Move to previous cell in worksheet or previous option in dialog
Shift  +   Tab

Move to right edge of current data region
Ctrl  +   Arrow right

Move to the beginning of the worksheet
Ctrl  +   Home

Move to the last (respectively first) nonblank cell above the currently selected cell
End   ,   Arrow up

Move to the last (respectively first) nonblank cell below the currently selected cell
End   ,   Arrow down

Move to the last (respectively first) nonblank cell to the left of the currently selected cell
End   ,   Arrow left

Move to the last (respectively first) nonblank cell to the right of the currently selected cell
End   ,   Arrow right

Move to the lowest and rightmost cell of the range of cells used
Ctrl  +   End

Move to the next sheet in the workbook
Ctrl  +   Page Up

Move to the previous sheet in the workbook
Ctrl  +   Page Down

Move to upper edge of current data region in worksheet
Ctrl  +   Arrow up

FILES

Close the active workbook
Ctrl  +   W

Create a new workbook
Ctrl  +   N

Display «Save as » dialog box
F12

Open workbook
Ctrl  +   O

Save file
Ctrl  +   S

DISPLAY

Display or hide grouping controls
Ctrl  +   8

Expand or collapse the ribbon
Ctrl  +   F1

Hide column(s)
Ctrl  +   0

Hide row
Ctrl  +   9

Switch between hiding an displaying objects on the worksheet
Ctrl  +   6

Zoom in
Ctrl  +  Alt  +   =

Zoom out
Ctrl  +  Alt  +   -

SELECTION

Cycle through floating objects, such as shapes, text boxes or images
Ctrl  +  Alt  +   5

Extend current selection by one cell or row downwards
Shift  +   Arrow down

Extend current selection by one cell or row to the left
Shift  +   Arrow left

Extend current selection by one cell or row to the right
Shift  +   Arrow right

Extend current selection by one cell or row to the top
Shift  +   Arrow up

Extend selection to the lowest and rightmost cell of the range of cells used
Ctrl  +  Shift  +   End

Group active worksheet with worksheet to the left
Ctrl  +  Shift  +   Page Up

Group active worksheet with worksheet to the right
Ctrl  +  Shift  +   Page Down

Select entire column
Ctrl  +   Space

Select entire row
Shift  +   Space

Select entire sheet
Ctrl  +   A

Select range of non-empty cells around the active cell
Ctrl  +  Shift  +   *

OTHERS

Calculate all worksheets on all open workbooks
F9

Check spelling in the active worksheet or selected range
F7

Close Excel
Ctrl  +   F4

Display workbook statistics
Ctrl  +  Shift  +   G

Find
Ctrl  +   F

Find and replace
Ctrl  +   H

Insert chart
F11

Print preview
Ctrl  +   F2

Repeat last command or action
Ctrl  +   Y

Undo last command or action
Ctrl  +   Z