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