| Sr# | Description | Shortcuts |
|---|---|---|
| 1) | Add Pivot Table | ALT + N + V + ENTER |
| 2) | Auto Fit Column | ALT + O + C + A |
| 3) | Add SubTotal | ALT + A + B + ENTER |
| 4) | Remove SubTotal | ALT + A + B + ALT + R |
| 5) | Add Sheets | Shift + F11 |
| 6) | Delete Sheet |
ALT + E + L ALT + H + D + S |
| 7) | Paste Special | ALT + E + S |
| 8) | Rename Sheet | ALT + H + O + R |
| 9) | Remove Duplicates | ALT + A + M |
| 10) | Delimit Text |
ALT + A + E ALT + D + E |
| 11) | Filter Data |
CTRL + SHIFT+L ALT + D + F + F |
| 12) | Apply Table | CTRL + L |
| 13) | Add Grouping / Remove Grouping |
ALT + SHIFT + Right Arrow ALT + Shift + Left Arrow |
| 14) | Insert Comment | ALT + I + M |
| 15) | Freeze Panes | ALT + W + F + ENTER |
| 16) | Add / Remove GridLines | ALT + W + V + G |
| 17) | Record Macro | ALT + L + R |
| 18) | Insert Date | CTRL + ; |
| 19) | Select Entire Row | Shift + Space |
| 20) | Select Entire Column | Ctrl + Space |
| 21) | Add Row | Ctrl + + |
| 22) | Remove Row | Ctrl + - |
| 23) | Insert Time | Ctrl + Shift + ; |
| 24) | Apply Last Action | F4 |
| 25) | Save As | F12 |
| 26) | Paste Special Dialog Box | Ctrl + Alt + V |
| 27) | Move To Last Cell | Ctrl + End |
| 28) | Move To First Cell | Ctrl + Home |
| 29) | Select Visible Cells | ALT + ; |
| 30) | New Line In Same Cell | ALT + Enter |
| 31) | Fill Down | Ctrl + D |
| 32) | Fill Right | Ctrl + R |
| 33) | Format Anything | Ctrl + 1 |
| 34) | Align Center | ALT + H + A + C |
| 35) | Align Left | ALT + H + A + L |
| 36) | Increase Font Size | ALT + H + F + G |
| 37) | Decrease Font Size | ALT + H + F + K |
| 38) | Apply Percentage Format | Ctrl + Shift + % |
| 39) | Apply Date Format | Ctrl + Shift + # |
| 40) | Apply Number Format | Ctrl + Shift + ! |
| 41) | Add Border Outline | Ctrl + Shift + & |
| 42) | Open The Insert Function | Shift + F3 |
| 43) | Calculate Worksheets | F9 |
| 44) | Force Calculate All | Ctrl + Alt + F9 |
| 45) | Hide Columns | Ctrl + 0 |
| 46) | Hide Rows | Ctrl + 9 |
| 47) | Unhide Rows | Ctrl + Shift + F9 |
| 48) | Unhide Columns | Ctrl + Shift + 0 |
| 49) | Open Pivot Table Wizard | Alt + DP |
| 50) | Open Macro Dialog Box | Alt + F8 |
| 51) | Open VBA Editor | Alt + F11 |
| 52) | Apply Data Validation | Alt + A + V + V |
| 53) | Apply Sorting | Alt + D + S |