Formatting

Alt + '	Displays the Style dialog box.
Ctrl + (# or ~)	Applies the Custom Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + @	Applies the Time format "hh:mm" to the selection in 24 hour notation.
Ctrl + Shift + (1 or !)	Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + (4 or $)	Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + (5 or %)	Applies the Percentage format "0%" to the selection.
Ctrl + Shift + (6 or ^)	Applies the Exponential format "#,##E+02" to the selection.
Ctrl + Shift + (# or ~)	Applies the General format to the selection.
Ctrl + Shift + (7 or &)	Applies the outline border to the selection.
Ctrl + Shift + (- or —)	Removes all the borders from the selection.

Alt + ' Displays the Style dialog box.
Ctrl + (# or ~) Applies the Custom Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + @ Applies the Time format "hh:mm" to the selection in 24 hour notation.
Ctrl + Shift + (1 or !) Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + (4 or $) Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + (5 or %) Applies the Percentage format "0%" to the selection.
Ctrl + Shift + (6 or ^) Applies the Exponential format "#,##E+02" to the selection.
Ctrl + Shift + (# or ~) Applies the General format to the selection.
Ctrl + Shift + (7 or &) Applies the outline border to the selection.
Ctrl + Shift + (- or —) Removes all the borders from the selection.