Shortcut Keys

Alt + 'Displays the Style dialog box.
Alt + EnterEnters a carriage return in a cell.
Ctrl + 1Displays the Format Cells dialog box.
Ctrl + #Applies the Date format "dd-mmm-yy" 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 + 1 (!)Applies the Number/Comma format "#,##0.00" to the selection.
Ctrl + Shift + 4 ($)Applies the Currency format "£#,##0.00" to the selection (not Accounting format).
Ctrl + Shift + 5 (%)Applies the Percentage format "0%" to the selection.
Ctrl + Shift + 6 (^)Applies the Scientific/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 + 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.
Alt + D, EDisplays the Text to Columns dialog box.
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, A, CAligns data in the middle of the cell.
Alt + H, B, AAdds All the borders to the current selection.
Alt + H, B, LAdds a Left border to the current selection.
Alt + H, B, NRemoves All the borders from the selection.
Alt + H, B, OAdds a Bottom border to the current selection.
Alt + H, B, PAdds a Top border to the current selection.
Alt + H, B, RAdds a Right border to the current selection.
Alt + H, B, SApplies a Thin Black Border around the Outside of the selected cells.
Alt + '
Displays the Style dialog box.
Alt + Enter
Enters a carriage return in a cell.
Ctrl + 1
Displays the Format Cells dialog box.
Ctrl + #
Applies the Date format "dd-mmm-yy" 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 + 1 (!)
Applies the Number/Comma format "#,##0.00" to the selection.
Ctrl + Shift + 4 ($)
Applies the Currency format "£#,##0.00" to the selection (not Accounting format).
Ctrl + Shift + 5 (%)
Applies the Percentage format "0%" to the selection.
Ctrl + Shift + 6 (^)
Applies the Scientific/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.
Alt + D, E
Displays the Text to Columns dialog box.
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, A, C
Aligns data in the middle of the cell.
Alt + H, B, A
Adds All the borders to the current selection.
Alt + H, B, L
Adds a Left border to the current selection.
Alt + H, B, N
Removes All the borders from the selection.
Alt + H, B, O
Adds a Bottom border to the current selection.
Alt + H, B, P
Adds a Top border to the current selection.
Alt + H, B, R
Adds a Right border to the current selection.
Alt + H, B, S
Applies a Thin Black Border around the Outside of the selected cells.

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