Appendix A. Keyboard Shortcuts

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

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 ...

Get Microsoft® Excel® 2010: 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.