Excel Pro Trick: Insert Subtotals in Excel FAST for each Category with Go To Special Tool + Auto SUM

Рет қаралды 92,164

Жыл бұрын

While working with data divided in categories, finding sum is often not straightforward. If data is not ready to accept subtotals, it will be even more difficult to insert subtotals for each category in Excel.
In this Excel video tutorial we are learning how to insert Subtotals for each category quickly using Excel Go To Special tool and Auto Sum shortcut.
This video is loaded with shortcuts to add subtotals, sum category values and format data in Excel!
Lets Excel!
For more Excel tips, tricks and tutorials don't forget to subscribe to @Learn Excel to excel YT channel.
Learn #Excel your way:
===================
Website: learnexceltoexcel.com/
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#excelsubtotal #excelgotospecial #exceltutorial #exceltips

Пікірлер: 21

@mdratanmia4804 Жыл бұрын

Your all videos are so important

@LearnExceltoexcel Жыл бұрын

Thank you! Glad you find them helpful

@parikannappan1580 3 ай бұрын

The problem with shorts is am not able to expand the video to full screen

@NURULISLAM-bq7br Жыл бұрын

Amazing!!!

@naingtun6620 Жыл бұрын

Thank for your sharing

@LearnExceltoexcel Жыл бұрын

My pleasure

@piktogor Жыл бұрын

😮 very cooool)) 👍🏻

@tumitshriwas 4 ай бұрын

Solide

@user-rl4mm8vk8s 5 ай бұрын

You are soooo goood. Please I need your help for setting a formula....I keep sending my request to different person but no one help

@CHME9ME9 5 ай бұрын

Or just use pivot table

@2Sage-7Poets Жыл бұрын

nice..

@LearnExceltoexcel Жыл бұрын

🤩

@ilove80100 6 ай бұрын

If you have a number matrix and you want to transfer it to another paper, but each row is four rows away from the other, how do we do it?

@abhishekgautam6734 Жыл бұрын

can't we do it in pivot table?

@LearnExceltoexcel Жыл бұрын

Just like any other stuff in Excel that can be done in multiple ways, pivot table is one way especially for the kind of data we have in this example. But change the structure and pivot tables will not be possible.

@DHoe-cn6bg 6 ай бұрын

😂

@DHoe-cn6bg 6 ай бұрын

POV „Du schießt mit Kanonen auf Spatzen“

@prabuubarp3840 Жыл бұрын

how to press three key at a time

@LearnExceltoexcel Жыл бұрын

For example if you have CTRL+SHIFT+F3 to press... Then press CTRL and SHIFT key together, and while holding them pressed down, hit F3 key! Same is the case with other key combos

@prabuubarp3840 Жыл бұрын

@@LearnExceltoexcel in video show alt+H+O+I ?