Appendix B. Keyboard shortcuts

This list of shortcuts is a comprehensive list derived from Microsoft Excel 2013 Help. Some of the shortcuts might not be available in every edition of Excel 2013.

Ctrl combination shortcut keys

Key

Description

Ctrl+Shift+(

Unhides any hidden rows within the selection.

Ctrl+Shift+&

Applies the outline border to the selected cells.

Ctrl+Shift+_

Removes the outline border from the selected cells.

Ctrl+Shift+~

Applies the General number format.

Ctrl+Shift+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

Ctrl+Shift+%

Applies the Percentage format with no decimal places.

Ctrl+Shift+^

Applies the Scientific number format with two decimal places.

Ctrl+Shift+#

Applies the Date format with the ...

Get Microsoft Excel 2013: Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.