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.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext