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.
Alt + '
Displays the Style dialog box.
Alt + Enter
Enters a carriage return in a cell.
Ctrl + 1
Displays 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 + 1
Applies the Comma separated format "#,##0.00" to the selection.
Ctrl + Shift + 4
Applies the Currency format "£#,##0.00" to the selection.
Ctrl + Shift + 5
Applies the Percentage format "0%" to the selection.
Ctrl + Shift + 6
Applies the 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.
Ctrl + 1
Displays the Format Cells dialog box.
Ctrl + Shift + 1
Comma separated, 2 decimal places format
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, B, R
Adds a Right border to the current selection.
Alt + H, B, L
Adds a Left border to the current selection.
Alt + H, B, P
Adds a Top border to the current selection.
Alt + H, B, O
Adds a Bottom border to the current selection.
Alt + H, B, A
Adds All the borders to the current selection.
Alt + H, B, N
Removes All the borders from the selection.

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