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.