Another selection of keyboard shortcuts. Press Control and the following symbols:
` – Toggles between displaying cell values and formulas in the current worksheet.
~ – Cell format is General.
! – Cell format is Number with two decimal places, commas, and minus symbol for negative values.
@ – Cell format is Time hour and minute, and AM or PM.
# – Cell format is Date (dd-mmm-yy).
$ – Cell format is Currency (with 2 decimal places and negatives in brackets).
% – Cell format is Percentage (with no decimal places).
^ – Cell format is Exponential with two decimal places.
& – Adds outline border on selected cells.
* – Selects the range of cells around the active cell.
( – Unhides all hidden rows in the selection.
) – Unhides all hidden columns in the selection.
– – Delete the selected cells.
_ – Removes outline border on selected cells.
+ – Insert cells.
; – Enters the current date.
: – Enters the current time.
‘ – Copies a formula from the cell above.
” – Copies the value from the cell above.