Excel Quick Shortcuts – Formatting

excellogoIn this article we once again consider some key tips utilising keyboard shortcuts, this time in relation to formatting.

There are many possible number formats, all of which can be accessed through the Format cells dialog box. There are however some preformatted options that can readily be accessed using keyboard shortcuts. In many cases these are enough to meet the needs of many a worksheets. The table below lists the shortcuts for applying number formats to a cell or range.

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, and year.
Ctrl + Shift + @ Applies the Time format with the hour and minute, and AM or PM.
Ctrl + Shift + ! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Formatting isn’t just about the numbers, it’s about how the worksheet looks overall. The following table lists some quick shortcuts to apply other formatting to data in any cell.

Ctrl + 2 Applies or removes bold formatting.
Ctrl + 3 Applies or removes italic formatting.
Ctrl + 4 Applies or removes underlining.
Ctrl + 5 Applies or removes strikethrough.

Of course there is a lot more formatting available, either though the ribbons, or the Format Cells dialog box, use Ctrl + 1 to show the Format cells Dialog ox

You’ll find these work in both Office 2007 and 2010. More quick shortcuts coming soon.

Leave a Reply

Your e-mail address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.