Shortcut Keys
Alt + ' | Displays the Style dialog box. |
Alt + Enter | Enters a carriage return in a cell. |
Ctrl + 1 | Displays the Format Cells dialog box. |
Ctrl + Shift + - | Removes All the borders from the selection. |
Ctrl + Shift + ' | Applies the Time format "hh:mm" to the selection. |
Ctrl + Shift + 1 | Applies the Comma separated format "#,##0.00" to the selection. |
Ctrl + Shift + 4 | Applies the Currency format "£#,##0.00" to the selection. |
Ctrl + Shift + 5 | Applies the Percentage format "0%" to the selection. |
Ctrl + Shift + 6 | Applies the Exponential format "#,##E+02" to the selection. |
Ctrl + Shift + 7 | Applies a Thin Black Border around the outside of the selected cells. |
Ctrl + Shift + # | Applies the General format to the selection. |
Ctrl + B | Toggles bold on the current selection. |
Ctrl + I | Toggles italics on the current selection. |
Ctrl + U | Toggles underlining on the current selection. |
Alt + Enter | Enters a carriage return in a cell. |
Alt + 0162 | Enters the Cent ¢ character. |
Alt + 0163 | Enters the Pound £ character. |
Alt + 0165 | Enters the Yen ¥ character. |
Alt + 0128 | Enters the Euro character. |
Alt + ' | Displays the Style dialog box. |
Ctrl + 1 | Displays the Format Cells dialog box. |
Ctrl + Shift + 1 | Comma separated, 2 decimal places format |
Alt + H, K | Comma separated format |
Alt + H, 0 | Increase the decimal places for more precision |
Alt + H, 9 | Decrease the decimal places for less precision |
Alt + H, B, R | Adds a Right border to the current selection. |
Alt + H, B, L | Adds a Left border to the current selection. |
Alt + H, B, P | Adds a Top border to the current selection. |
Alt + H, B, O | Adds a Bottom border to the current selection. |
Alt + H, B, A | Adds All the borders to the current selection. |
Alt + H, B, N | Removes All the borders from the selection. |
Alt + ' Displays the Style dialog box. |
Alt + Enter Enters a carriage return in a cell. |
Ctrl + 1 Displays the Format Cells dialog box. |
Ctrl + Shift + - Removes All the borders from the selection. |
Ctrl + Shift + ' Applies the Time format "hh:mm" to the selection. |
Ctrl + Shift + 1 Applies the Comma separated format "#,##0.00" to the selection. |
Ctrl + Shift + 4 Applies the Currency format "£#,##0.00" to the selection. |
Ctrl + Shift + 5 Applies the Percentage format "0%" to the selection. |
Ctrl + Shift + 6 Applies the Exponential format "#,##E+02" to the selection. |
Ctrl + Shift + 7 Applies a Thin Black Border around the outside of the selected cells. |
Ctrl + Shift + # Applies the General format to the selection. |
Ctrl + B Toggles bold on the current selection. |
Ctrl + I Toggles italics on the current selection. |
Ctrl + U Toggles underlining on the current selection. |
Alt + Enter Enters a carriage return in a cell. |
Alt + 0162 Enters the Cent ¢ character. |
Alt + 0163 Enters the Pound £ character. |
Alt + 0165 Enters the Yen ¥ character. |
Alt + 0128 Enters the Euro character. |
Alt + ' Displays the Style dialog box. |
Ctrl + 1 Displays the Format Cells dialog box. |
Ctrl + Shift + 1 Comma separated, 2 decimal places format |
Alt + H, K Comma separated format |
Alt + H, 0 Increase the decimal places for more precision |
Alt + H, 9 Decrease the decimal places for less precision |
Alt + H, B, R Adds a Right border to the current selection. |
Alt + H, B, L Adds a Left border to the current selection. |
Alt + H, B, P Adds a Top border to the current selection. |
Alt + H, B, O Adds a Bottom border to the current selection. |
Alt + H, B, A Adds All the borders to the current selection. |
Alt + H, B, N Removes All the borders from the selection. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext