Shortcut Keys

Alt + 'Displays the (Format > Style) dialog box.
Alt + EnterEnters a carriage return in a cell.
Ctrl + 1Displays the (Format > Cells) dialog box.
Ctrl + Shift + 7Applies the outline border 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 + 1Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + 4Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + 5Applies the Percentage format "0%" to the selection.
Ctrl + Shift + 6Applies the Exponential format "#,##E+02" to the selection.
Ctrl + Shift + #Applies the General format to the selection.
Alt + EnterEnters a carriage return in a cell.
Alt + 0162Enters the Cent ¢ character.
Alt + 0163Enters the Pound £ character.
Alt + 0165Enters the Yen ¥ character.
Alt + 0128Enters the Euro € character.
Alt + H, KComma separated format
Alt + 'Displays the Style dialog box.
Ctrl + 1Displays the Format Cells dialog box.
Ctrl + Shift + 1Comma separated, 2 decimal places format



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext