ms excel

Top 5 MS Excel Shortcuts you probably didn't know

Great Learning

June 22, 2022

Arrow

ALT + =

1

Save a significant amount of time by auto-summing the whole column in a jiffy. Use this at the bottom of big list of numbers and watch it give you th results immediately.

Ctrl + Shift + L

2

If you are a regular Excel user, you would use the filters option frequently. This shortcut will quickly help you turn the filter On/Off and help save a lot of time.

Ctrl + Tilde(~) Key

3

This shortcut will help you in showing the formulas on the page. It will be a great help if you are analysing and comparing formulas that are being used on the sheet.

Alt + A + M

4

If you are someone who works on removing duplicates a lot, this shortcut is just the right choice for you. This will toggle a Remove Duplicates Box using which you can remove the duplicates.

Ctrl + Alt + V 

5

This shortcut is especially helpful when you are looking to paste text  without formatting. It will save you a lot of time if you paste as values a lot.

Looking to improve your Excel skills? Check out these top free Excel courses by Great Learning Academy & upskill today!

Learning Excel boosts your career prospects and employability exponentially