Microsoft Office Tutorials and References
In Depth Information
A P P E N D I X B
■ ■ ■
What follows is a list of selected Excel 2010 keyboard shortcuts, culled from Microsoft’s more
comprehensive listing(you can view all the shortcuts by tapping F1–itself a shortcut–calling up Excel’s
2010 help component, and clicking the Keyboard Shortcut link). I’ve added explanatory comments
where I thought they’d help.
Remember that you can activate ribbon and button group commands by pressing the ALT key,
which instates what Excel calls Key Tips atop the ribbon:
These too could qualify as keyboard shortcuts (see Chapter 1).
By definition, a shortcut offers swifter way to execute a command that would otherwise be carried
out a bit more slowly with the mouse – and that’s often true, considering a) where your hands are
currently positioned and b) that you can actually remember the shortcut. If you can’t, the time you spend
looking it up defeats the purpose, and you’ll wind up with a longcut instead. And because shortcuts are
so numerous, you’re not likely to commit too many to memory. There’s nothing wrong with that, but
learning the ones that do work for you can indeed save you time and streamline your work routine. So
Control Key Combinations
CTRL+SHIFT+) Unhides any hidden columns within the selection.
Unhides any hidden rows within the selection.
Applies the General number format.
Applies the Currency format with two decimal places (negative numbers in parentheses).
Applies the Percentage format with no decimal places.
Applies the Number format with two decimal places, thousands separator, and minus sign (-
) for negative values.
Enters the current time; that is, the actual time as data – not a formula result.