Microsoft Excel shortcuts you must learn🧑💻
A thread🧵
Retweet if you find useful :)
1) AutoSum: Alt + =
2) Create pivot table: Alt + N, V
3) Insert todays date: Ctrl + ;
A thread🧵
Retweet if you find useful :)
1) AutoSum: Alt + =
2) Create pivot table: Alt + N, V
3) Insert todays date: Ctrl + ;
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
In addition, you can also practice from below image to increase your productivity.
In addition, you can also look at 40 more short cuts from below thread👇
tinyurl.com
I hope thread was useful:)
tinyurl.com
I hope thread was useful:)
Loading suggestions...