Microsoft Excel hot keys


Moving

Shortcut

Description

Ctrl+End

to the last cell in data region

Ctrl+Home

to the A1

Home

to the first cell of the current row

F5

cell request to move

Alt+Tab

switch to another workbook

Alt+Shift+Tab

switch to another workbook

Ctrl+PgDn

switch to another sheet

Ctrl+PgUp

switch to another sheet

Ctrl+Tab

switch to the next window

Ctrl+Shift+Tab

switch to the previous window

Ctrl+G

"Go to" dialog

Tab

transition in cells

Selecting

Shortcut

Description

Shift + arrow

expand the selected area in a given direction

Shift + space

row selection

Ctrl + space

column selection

Ctrl + Shift + space

select entire table

Shift + Home

expand the selected area to the beginning of the row

Ctr l+ Shift + *

block of data around the active cell

F8

expansion of the selection mode

Ctrl + A

select all

Formating

Shortcut

Description

Ctrl+1

"Format cells" window

Ctrl+B

bold font style

Ctrl+I

italic font style

Ctrl+U

underlined font style

Ctrl+5

strikethrough font style

Ctrl+Shift+ ~

general format

Ctrl+Shift+ !

two decimal places format

Ctrl+Shift+ #

date format

Ctrl+Shift+ @

time format

Ctrl+Shift+ $

currency format

Ctrl+Shift+ %

percentage format

Ctrl+Shift+ &

insert a frame

Other

Shortcut

Description

Alt+F1

Insert a chart

Alt+Shift+F1

Insert a new sheet

F2

Edit the content of the active cell

Shift+F2

Edit comment

Shift+F5

Find and replace

F11

Create a chart