alt+= to activate subtotal function

[lezawang]

Hi
I was reading the article below and the author said using Alt+= to activate the subtotal function?
Why subtotal function has short key? do other functions have short cut keys? thank you.

https://yodalearning.com/tutorials/subtotal-excel-formula-excel-advanced-filter-trick/

 

[Fazza]

it is explained/answered in the article you linked to

We use Alt + = shortcut key for the sum. Excel is smart. It knows that the data is filtered and you will be working with your Filtered data and that’s why it is showing subtotal excel formula.

 

[lezawang]

I missed that! thank you very much.