⌘+Shift+l | Display the Style dialog box |
⌘+1 | Display the Format Cells dialog box |
Ctrl+Shift+~ | Apply the general number format |
Ctrl+Shift+$ | Apply the currency format with two decimal places (negative numbers appear in red with parentheses) |
Ctrl+Shift+% | Apply the percentage format with no decimal places |
Ctrl+Shift+^ | Apply the exponential number format with two decimal places |
Ctrl+Shift+# | Apply the date format with the day, month, and year |
Ctrl+Shift+@ | Apply the time format with the hour and minute, and indicate A.M. or P.M. |
Ctrl+Shift+! | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values |
⌘+Option+0 (zero) | Apply the outline border around the selected cells |
⌘+Option+Arrow Right | Add an outline border to the right of the selection |
⌘+Option+Arrow Left | Add an outline border to the left of the selection |
⌘+Option+Arrow Up | Add an outline border to the top of the selection |
⌘+Option+Arrow Down | Add an outline border to the bottom of the selection |
⌘+Option+- | Remove outline borders |
⌘+b | Apply or remove bold formatting |
⌘+i | Apply or remove italic formatting |
⌘+u | Apply or remove underscoring |
⌘+Shift+x | Apply or remove strikethrough formatting |
Ctrl+9 | Hide rows |
Ctrl+Shift+( | Unhide rows |
Ctrl+0 (zero) | Hide columns |
Ctrl+Shift+) | Unhide columns |
⌘+Shift+w | Add or remove the shadow font style |
⌘+Shift+d | Add or remove the outline font style |
Ctrl+u | Edit the active cell |
Esc | Cancel an entry in the cell or the formula bar |
Delete | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents |
⌘+v | Paste text into the active cell |