Insert Subtotal Using ONLY Keyboard... NO MOUSE #tips #excel #short #short #shortvideo #how

preview_player
Показать описание
Learn how to insert subtotal in Excel. I will demonstrate wow do I write a subtotal formula in Excel? I will also show you how do you insert subtotals using the sum function in a table. And provide answers to what is the shortcut for auto subtotal in Excel? And at the end of it all, you will be able to to answer the question to is there a subtotal function in Excel?

Here are the steps outlined in my video.

Fill Blank Cells
1) Ctrl + A
2) Alt + HFDSK + Enter
3) =
4) Up arrow
5) Ctrl + Enter

Calculate Subtotal
1) Ctrl + A
2) Alt + AZOB
3) Tabs (5 times)
4) Enter

Navigate To Last Row
Ctrl + Arrow Down

Navigate To First Row
Ctrl + Arrow Up

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google
Рекомендации по теме
Комментарии
Автор

Can u show us how to highlight the subtotal of specific location for example the subtotal of Newyork through conditional formatting or by any other methods

mos
Автор

Hi. How can I insert the additional data after that?

ngocdanthuynguyen