Format number as Percentage
Ctrl+Shift+%
As easy as that! This keyboard short cut will format the selected cells as percentages to 2 deciamal places. It is the same as clicking the % button on the format toolbar, but much quicker
Copy & paste
The keyboard shortcuts for copy and paste are:
- Copy Ctrl+C
- Cut Ctrl+X
- Paste Ctrl+V
Ctrl+V gives you to the option of repeating the operation, i.e. the clipboard is not emptied. If you paste using Enter you are not able to repeat the operation. This is like pressing Ctrl+V and then Esc
the end game
Just as pressing Ctrl+Home will return to A1 from any cell on the sheet. pressing Ctrl+End will take you to the end point in any sheet
