Excel worksheet shortcut

Worksheet

Insert new worksheet

Shift + F11

Go to next worksheet

Ctrl + PgDn

Go to previous worksheet

Ctrl + PgUp

Rename current worksheet

Alt + O , H R

Delete current worksheet

Alt + E , L

Move current worksheet

Alt + E , M

Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split

F6 OR Shift + F6

Select adjacent worksheets

Ctrl + Shift + PgUp/PgDn

Select non-adjacent worksheets

Ctrl + Click

Toggle scroll lock

ScrLk

Toggle full screen

Ctrl + Shift + F1

Print

Ctrl + P

Open print preview window

Ctrl + F2

Set print area

Alt + P , R S

Clear print area

Alt + P , R C

Zoom in

Ctrl + Mouse Wheel Up

Zoom out

Ctrl + Mouse Wheel Down

Protect sheet

Alt + R , P S

 

Worksheet

Insert new worksheet

Shift + F11

Go to next worksheet

Ctrl + PgDn

Go to previous worksheet

Ctrl + PgUp

Rename current worksheet

Alt + O , H R

Delete current worksheet

Alt + E , L

Move current worksheet

Alt + E , M

Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split

F6 OR Shift + F6

Select adjacent worksheets

Ctrl + Shift + PgUp/PgDn

Select non-adjacent worksheets

Ctrl + Click

Toggle scroll lock

ScrLk

Toggle full screen

Ctrl + Shift + F1

Print

Ctrl + P

Open print preview window

Ctrl + F2

Set print area

Alt + P , R S

Clear print area

Alt + P , R C

Zoom in

Ctrl + Mouse Wheel Up

Zoom out

Ctrl + Mouse Wheel Down

Protect sheet

Alt + R , P S