10 Microsoft Excel shortcuts to learn in order to increase productivity at 👇
Retweet if you find it helpful ⚡️
1) AutoSum: Alt + =
2) Create pivot table: Alt + N, V
3) Insert todays date: Ctrl + ;
Retweet if you find it helpful ⚡️
1) AutoSum: Alt + =
2) Create pivot table: Alt + N, V
3) Insert todays date: Ctrl + ;
4) Spelling & grammar check: F7
5) Filter Data: Ctrl + Shift + L
6) Currency format: Ctrl + Shift + $
7) Percentage format: Ctrl + Shift + %
8a) Delete row: Ctrl + -
8b) Add row: Ctrl + +
9) To find: Shift + F5
10) Save workbook: Ctrl + S
5) Filter Data: Ctrl + Shift + L
6) Currency format: Ctrl + Shift + $
7) Percentage format: Ctrl + Shift + %
8a) Delete row: Ctrl + -
8b) Add row: Ctrl + +
9) To find: Shift + F5
10) Save workbook: Ctrl + S
1) To insert AutoSum formula:
Alt + =
Alt + =
2) To create pivot table:
Alt + N, V
Alt + N, V
3) To open spelling & grammar check:
F7
F7
4) To insert todays date:
Ctrl + ;
Ctrl + ;
5. To activate the filter:
Ctrl + Shift + L
Ctrl + Shift + L
6) To apply the currency format:
Ctrl + Shift + $
Ctrl + Shift + $
7) To apply the percent format:
Ctrl + Shift + %
Ctrl + Shift + %
8a) To delete a row:
Ctrl + -
Ctrl + -
8b) To add a row:
Ctrl + +
Ctrl + +
9) To find:
Shift + F5
Shift + F5
10) To save workbook:
Ctrl + S
Ctrl + S
Loading suggestions...