Shortcut | Usage | Further explanations |
Ctrl+A | Select All | To select all items in view |
Ctrl+B | Bold | To bold selected items |
Ctrl+C | Copy | To copy selected items |
Ctrl+D | Fill Down | |
Ctrl+F | Find | To find words or letters in current work |
Ctrl+G | Go to | To locate and go to certain word or letter in current work |
Ctrl+H | Replace | To replace certain word with another in current work |
Ctrl+I | Italic | To make the highlighted word turn italic |
Ctrl+K | Insert Hyperlink | To insert hyperlink into a text/image |
Ctrl+N | Insert Hyperlink | To open a new workbook in Excel |
Ctrl+O | Open | To re-open an existing earlier closed work |
Ctrl+P | To print work being done | |
Ctrl+R | Fill Right | To fill item to right cells subsequently |
Ctrl+S | Save | To save the work being done |
Ctrl+U | Underline | To underline selected item |
Ctrl+V | Paste | To paste ealier copied or selected item |
Ctrl W | Close | To close open work |
Ctrl+X | Cut | To cut selected itme |
Ctrl+Y | Repeat | To move forward again after moving back on an action |
Ctrl+Z | Undo | To move back to previous action |
F1 | Help | To seek for help (online) |
F2 | Edit | |
F3 | Paste Name | |
F4 | Repeat last action | While typing a formula, switch between absolute/relative refs |
F5 | Go to | Locate a word or text |
F6 | Next Pane | Choose the next pane (in series of music, video etc) |
F7 | Spell check | |
F8 | Extend mode | |
F9 | Recalculate all workbooks | |
F10 | Activate Menu bar | |
F11 | New Chart | |
F12 | Save As | |
Ctrl+: | Insert Current Time | |
Ctrl+; | Insert Current Date | |
Ctrl+” | Copy Value | Copy Value from Cell Above |
Ctrl+’ | Copy Value | Copy Formula from Cell Above |
Shift+F1 | What’s This? | |
Shift+F2 | Edit cell comment | |
Shift+F3 | Paste function into formula | |
Shift+F4 | Find Next | |
Shift+F5 | Find | |
Shift+F6 | Previous Pane | Choose the previous pane (in series of music, video etc) |
Shift+F8 | Add to selection | |
Shift+F9 | Calculate active worksheet | |
Shift+F10 | Display shortcut menu | |
Shift+F11 | New worksheet | |
Ctrl+F3 | Define name | |
Ctrl+F4 | Close | |
Ctrl+F5 | Restore window size | |
Ctrl+F6 | Next workbook window | |
Shift+Ctrl+F6 | Previous workbook window | |
Ctrl+F7 | Move window | |
Ctrl+F8 | Resize window | |
Ctrl+F9 | Minimize workbook | |
Ctrl+F10 | Maximize or restore window | |
Ctrl+F11 | Inset 4.0 Macro sheet | |
Ctrl+F1 | File Open | Open an existing file |
Alt+F1 | Insert Chart | To insert chart in a worksheet (Excel) |
Alt+F2 | Save As | To save a work (for the first time) |
Alt+F4 | Exit | To close open work |
Alt+Down arrow | Display AutoComplete list | |
Alt+’ | Format Style dialog box | |
Ctrl+Shift+~ | General format | |
Ctrl+Shift+! | Comma format | |
Ctrl+Shift+@ | Time format | |
Ctrl+Shift+# | Date format | |
Ctrl+Shift+$ | Currency format | |
Ctrl+Shift+% | Percent format | |
Ctrl+Shift+^ | Exponential format | |
Ctrl+Shift+& | place border | Place outline border around selected cells |
Ctrl+Shift+_ | Remove outline border | |
Ctrl+Shift+* | Select current region |
Notes:
1. Some keys or combination of keys may perform different function from what is above, that depends on the package you are using.
2. Start practicing the short cut one after the other so as not to
forget. Cramming them without use may not help.
3. You need to enrol in our computer institute now (if you have not). Click here to read more about our institute
Some short keys still missing? Or some not correct? Try giving us more through the reply space below.