Function Keys:
| Key | Function |
|---|---|
| F2 | Edit Selected Cells |
| F4 | Repeat last action |
| F7 | Spell Check |
| F11 | Create chart from selected data |
| Alt+Shift+F1 | Insert New worksheet |
| Shift+F3 | Open Excel Formula window |
| Shift+F5 | Open Search box |
| Ctrl+F3 | Open Excel Name Manager |
| Ctrl+F9 | Minimize current window |
| Ctrl+F10 | Maximize currently selected window |
| Ctrl+F6 | Switch between open workbook/window |
Hotkeys with Alphabets:
| Key | Function |
|---|---|
| Ctrl+A | Select all cells |
| Ctrl+B | Bold selected cells |
| Ctrl+C | Copy |
| Ctrl+D | To fill content down |
| Ctrl+I | Italic selected cells |
| Ctrl+K | Insert Hyperlink |
| Ctrl+P | To print |
| Ctrl+R | To fill content right |
| Ctrl+U | Underline selected cells |
| Ctrl+Z | To Undo last action |
Hotkeys with Numbers:
| Key | Function |
|---|---|
| Ctrl+1 | To format cells |
| Ctrl+2 | To Bold |
| Ctrl+3 | To Italic |
| Ctrl+4 | To Underline |
| Ctrl+5 | To Strike cells |
| Ctrl+Shift+1 | Comma Format |
| Ctrl+Shift+2 | Time Format |
| Ctrl+Shift+3 | Date Format |
| Ctrl+Shift+4 | Currency Format |
| Ctrl+Shift+5 | Percentage Format |
| Ctrl+Shift+6 | Scientific Format |
Others:
| Key | Function |
|---|---|
| Ctrl+; | To enter Current Date |
| Ctrl+Shift+; | To enter Current Time |
| Ctrl+' | To insert value of above cell |
| Ctrl+Home | To move to cell A1 |
| Ctrl+Space | To select entire columns |
| Shift+Space | To select entire rows |
| Ctrl+Arrows | Move to next sections |
| Ctrl+Tab | Move between excel files |
| Ctrl+PageUp | Move up to worksheet of same document |
| Ctrl+PageDown | Move down to worksheet of same document |
| Alt+= | To create sum formula for all above cells |
| Ctrl+- | To delete selected row/column |