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 the day, month, ...

Get Microsoft® Excel® 2010: Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.