Shortcut Keys

Alt + 'Displays the Style dialog box.
Alt + EnterEnters a carriage return in a cell.
Ctrl + 1Displays the Format Cells dialog box.
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 + 7Applies a Thin Black Border around the outside of the selected cells.
Ctrl + Shift + #Applies the General format to the selection.
Ctrl + BToggles bold on the current selection.
Ctrl + IToggles italics on the current selection.
Ctrl + UToggles underlining on the current 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 + 'Displays the Style dialog box.
Ctrl + 1Displays the Format Cells dialog box.
Ctrl + Shift + 1Comma separated, 2 decimal places format
Alt + H, KComma separated format
Alt + H, 0Increase the decimal places for more precision
Alt + H, 9Decrease the decimal places for less precision
Alt + H, B, RAdds a Right border to the current selection.
Alt + H, B, LAdds a Left border to the current selection.
Alt + H, B, PAdds a Top border to the current selection.
Alt + H, B, OAdds a Bottom border to the current selection.
Alt + H, B, AAdds All the borders to the current selection.
Alt + H, B, NRemoves All the borders from the selection.

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