O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C: Microsoft Excel 2013 Common Keyboard Shortcuts

The follow table lists common keyboard shortcuts you can use in Excel 2013.

Function Shortcut
Switch between worksheet tabs, from left to right Ctrl + PgDn
Switch between worksheet tabs, from right to left Ctrl + PgUp
Select the region around the active cell (requires there to be content in the surrounding cells) Ctrl + Shift + *

or

Ctrl + * (from the number pad)

Insert the current time Ctrl + Shift + :
Insert the current date Ctrl + ;
Display the Insert dialog box Ctrl + Shift + +
Display the Delete dialog box Ctrl + -
Display the Format Cells dialog box Ctrl + 1
Select the entire worksheet Ctrl + A
Apply or remove bold formatting Ctrl + B
Apply ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required