Cell Formatting

The key combinations that allow you to apply formatting options quickly are listed in the following table.

Shortcut Description
CTRL+1 Opens the Format Cells dialog.
CTRL+SHIFT+F Opens the Format Cells dialog with the active Font tab.
CTRL+B or CTRL+2 Applies or removes bold formatting.
CTRL+I or CTRL+3 Applies or removes italic formatting.
CTRL+U or CTRL+4 Applies or removes underlining.
CTRL+5 Applies or removes strikethrough.
CTRL+SHIFT+7 Applies the outline border to the selected cell or cell range.
CTRL+SHIFT+MINUS (-) Removes the outline border from the selected cell or cell range.
CTRL+SHIFT+1 Applies the Number format with two decimal places.
CTRL+SHIFT+2 Applies the Time format.
CTRL+SHIFT+3 Applies the Date format.
CTRL+SHIFT+4 Applies the Currency format.
CTRL+SHIFT+5 Applies the Percentage format.
CTRL+SHIFT+6 Applies the Scientific number format.
CTRL+T Opens the Create Table dialog.