Genius World Excel
Genius World Excel
75 More Excel Short Keys
| No. | Shortcut | Action |
|---|---|---|
| 1 | Ctrl + A | Select Current Data Region |
| 2 | Ctrl + B | Bold |
| 3 | Ctrl + C | Copy |
| 4 | Ctrl + D | Fill Down |
| 5 | Ctrl + E | Flash Fill |
| 6 | Ctrl + F | Find |
| 7 | Ctrl + G | Go To |
| 8 | Ctrl + H | Find & Replace |
| 9 | Ctrl + I | Italic |
| 10 | Ctrl + J | Line Break in Find/Replace |
| 11 | Ctrl + K | Insert Hyperlink |
| 12 | Ctrl + L | Create Table |
| 13 | Ctrl + M | New Worksheet |
| 14 | Ctrl + N | New Workbook |
| 15 | Ctrl + O | Open Workbook |
| 16 | Ctrl + P | |
| 17 | Ctrl + Q | Quick Analysis |
| 18 | Ctrl + R | Fill Right |
| 19 | Ctrl + S | Save |
| 20 | Ctrl + T | Create Table |
| 21 | Ctrl + U | Underline |
| 22 | Ctrl + V | Paste |
| 23 | Ctrl + W | Close Workbook |
| 24 | Ctrl + X | Cut |
| 25 | Ctrl + Y | Redo |
| 26 | Ctrl + Z | Undo |
| 27 | Ctrl + 1 | Format Cells |
| 28 | Ctrl + 2 | Bold Format |
| 29 | Ctrl + 3 | Italic Format |
| 30 | Ctrl + 4 | Underline Format |
| 31 | Ctrl + 5 | Strikethrough |
| 32 | Ctrl + 6 | Show/Hide Objects |
| 33 | Ctrl + 8 | Show/Hide Outline Symbols |
| 34 | Ctrl + 9 | Hide Rows |
| 35 | Ctrl + 0 | Hide Columns |
| 36 | Ctrl + Shift + $ | Currency Format |
| 37 | Ctrl + Shift + % | Percentage Format |
| 38 | Ctrl + Shift + ^ | Scientific Format |
| 39 | Ctrl + Shift + # | Date Format |
| 40 | Ctrl + Shift + @ | Time Format |
| 41 | Ctrl + Shift + ! | Number Format |
| 42 | Ctrl + Shift + & | Apply Outline Border |
| 43 | Ctrl + Shift + _ | Remove Outline Border |
| 44 | Ctrl + Shift + + | Insert Cells/Rows/Columns |
| 45 | Ctrl + Shift + ~ | General Format |
| 46 | Ctrl + Shift + 1 | Number Format |
| 47 | Ctrl + Shift + 2 | Time Format |
| 48 | Ctrl + Shift + 3 | Date Format |
| 49 | Ctrl + Shift + 4 | Currency Format |
| 50 | Ctrl + Shift + 5 | Percentage Format |
| 51 | Ctrl + Shift + 6 | Scientific Format |
| 52 | Ctrl + Shift + 7 | Apply Outline Border |
| 53 | Ctrl + Shift + 8 | Show Outline Symbols |
| 54 | Ctrl + Shift + 9 | Unhide Rows |
| 55 | Ctrl + Shift + ( | Unhide Rows |
| 56 | Ctrl + Shift + ) | Unhide Columns |
| 57 | Ctrl + Shift + F3 | Create Names from Labels |
| 58 | Ctrl + Shift + F | Font Dialog |
| 59 | Ctrl + Shift + P | Font Size |
| 60 | Ctrl + Shift + U | Expand Formula Bar |
| 61 | Ctrl + Arrow Key | Jump to Edge of Data Region |
| 62 | Ctrl + Shift + Arrow Key | Select to Edge of Data Region |
| 63 | Ctrl + Home | Go to Cell A1 |
| 64 | Ctrl + End | Go to Last Used Cell |
| 65 | Ctrl + Page Up | Move to Previous Sheet |
| 66 | Ctrl + Page Down | Move to Next Sheet |
| 67 | Ctrl + Space | Select Entire Column |
| 68 | Ctrl + Shift + Space | Select Current Region |
| 69 | Ctrl + Backspace | Scroll Active Cell into View |
| 70 | Ctrl + Delete | Delete Text to End of Line in Cell |
| 71 | Ctrl + Enter | Fill Selected Cells with Current Entry |
| 72 | Ctrl + Shift + Enter | Enter Array Formula (legacy Excel) |
| 73 | Ctrl + ; | Insert Current Date |
| 74 | Ctrl + Shift + : | Insert Current Time |
| 75 | Ctrl + ' | Copy Formula from Cell Above |