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 + # | Applies the Date format "dd-mmm-yy" to the selection. |
| 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 Number/Comma format "#,##0.00" to the selection. |
| Ctrl + Shift + 4 ($) | Applies the Currency format "£#,##0.00" to the selection (not Accounting format). |
| Ctrl + Shift + 5 (%) | Applies the Percentage format "0%" to the selection. |
| Ctrl + Shift + 6 (^) | Applies the Scientific/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. |
| Alt + D, E | Displays the Text to Columns dialog box. |
| 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, A, C | Aligns data in the middle of the cell. |
| Alt + H, B, A | Adds All the borders to the current selection. |
| Alt + H, B, L | Adds a Left border to the current selection. |
| Alt + H, B, N | Removes All the borders from the selection. |
| Alt + H, B, O | Adds a Bottom border to the current selection. |
| Alt + H, B, P | Adds a Top border to the current selection. |
| Alt + H, B, R | Adds a Right border to the current selection. |
| Alt + H, B, S | Applies a Thin Black Border around the Outside of the selected cells. |
| Alt + ' Displays the Style dialog box. |
| Alt + Enter Enters a carriage return in a cell. |
| Ctrl + 1 Displays the Format Cells dialog box. |
| Ctrl + # Applies the Date format "dd-mmm-yy" to the selection. |
| 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 Number/Comma format "#,##0.00" to the selection. |
| Ctrl + Shift + 4 ($) Applies the Currency format "£#,##0.00" to the selection (not Accounting format). |
| Ctrl + Shift + 5 (%) Applies the Percentage format "0%" to the selection. |
| Ctrl + Shift + 6 (^) Applies the Scientific/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. |
| Alt + D, E Displays the Text to Columns dialog box. |
| 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, A, C Aligns data in the middle of the cell. |
| Alt + H, B, A Adds All the borders to the current selection. |
| Alt + H, B, L Adds a Left border to the current selection. |
| Alt + H, B, N Removes All the borders from the selection. |
| Alt + H, B, O Adds a Bottom border to the current selection. |
| Alt + H, B, P Adds a Top border to the current selection. |
| Alt + H, B, R Adds a Right border to the current selection. |
| Alt + H, B, S Applies a Thin Black Border around the Outside of the selected cells. |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext