50 IMPORTANT EXCEL SHORTCUT KEYS
| SHORTCUT | ACTION |
| CTRL + B | BOLD TEXT |
| CTRL + U | UNDERLINE |
| CTRL + SHIFT + # | APPLY THE DATE FORMAT |
| CTRL + SHIFT + @ | APPLY THE TIME FORMAT |
| CTRL + SHIFT + U | EXPAND OR COLLAPSE THE FORMULA BAR |
| CTRL + SHIFT + $ | APPLY THE CURRENCY FORMAT |
| CTRL + SHIFT +% | APPLY THE PERCENTAGE FORMAT |
| ALT + H,B,C | CHANGE CELL COLOR |
| CTRL + SHIFT + I | APPLY THE COMMA FORMAT |
| CTRL + SHIFT + & | APPLY THE OUTLINE BORDER |
| CTRL + SHIFT +_ | REMOVE THE OUTLINE BORDER |
| CTRL + SHIFT ++ | INSERT A NEW ROW OR COLUMN |
| CTRL + – | DELETE A ROW OR COLUMN |
| CTRL + SHIFT + F | OPEN THE FONT DIALOG BOX |
| ALT + H,M,C | MERGE & CENTER CELLS |
| ALT +H,O,R | RENAME SHEET |
| ALT +H,O,W | COLUMN WIDTH |
| ALT + H, O, H | COLUMN HIGHT |
| ALT + H,E,A | CLEAR ALL |
| ALT + H, B ,A | ADD ALL BORDER |
| CTRL + SHIFT +^ | APPLY THE SCIENTIFIC NUMBER FORMAT |
| ALT + H,B,N | REMOVE BORDER |
| ALT + H, B, P | ADD TOP BORDER |
| ALT + H,B, T | THICK OUTSIDE BORDER |
| ALT + H,B,B | ADD BOTTOM BORDER |
| ALT +H,B,L | ADD LEFT BORDER |
| ALT +H, B,R | ADD RIGHT BORDER |
| ALT +H,B,S | ADD OUTSIDE BORDERS |
| ALT +H,B,M | OPEN MORE BORDERS OPTION |
| ALT + A | GO TO THE DATA TAB |
| ALT + F | OPEN THE FILE TAB MENU |
| ALT + H | GO TO THE HOME TAB |
| CTRL + SHIFT + ~ | APPLY THE GEN |
| CTRL +TAB | SWITCH BETWEEN OPEN WORKBOOKS |
| ALT +M | GO TO THE FORMULA TAB |
| ALT +N | OPEN THE INSERT TAB |
| ALT + P | GO TO THE PAGE LAYOUT TAB |
| ALT + Q | GO TO THE SEARCH BAR |
| ALT + R | GO TO THE REVIEW TAB |
| ALT + W | GO TO THE VIEW TAB |
| ALT + X | GO TO THE ADD –INS TAB |
| ALT + Y | GO TO THE HELP TAB |
| F1 | OPEN THE HELP PANE |
| SHIFT + F9 | CALCULATE ACTIVE WORKSHEETS |
| SHIFT + F3 | INSERT A FUCTION |
| ALT + F1 | CREATE AN EMBEDDED BAR CHART BASED ON SELECTED DATA |
| ALT + F11 | OPEN THE MICROSOFT VBA EDITOR |
| CTRL + F1 | SHOW OR HIDE THE RIBBON |
