Insert Subtotal From Ribbon - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

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 Out Blanks "Branch/Location"  1) Select cells in A2 to A27  2) Ctrl + G  3) Special  4) Blanks  5) Ok  6) =A2 and then press Ctrl + Enter   Calculate Subtotal  1) Select A1 to C27  2) Data ~ Outline ~ Subtotal  3) "At each change in" set to "Branch/Location"  4) "Use function" set to "Sum"  5) Check on "Sales"  6) OK    🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗  Insert Subtotal - Excel Tips and Tricks  https://youtube.com/shorts/Z3kbz5hdYQk?feature=share     How do I write a subtotal formula in Excel?,How do you insert subtotals using the sum function in a table?,What is the shortcut for auto subtotal in Excel?,Is there a subtotal function in Excel?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00I recently made a video on how to insert subtotal to your dataset table like this.

00:04Links to the video is in the description.

00:06Nonetheless, an individual has suggested an alternate method for computing the subtotal.

00:10Here's a step-by-step guide for that approach.

00:12First, you're going to select all the branch and location from A2 to A27.

00:16Press Ctrl G and you're going to select a special button here.

00:20Select blanks and click OK.

00:22This is going to select all your blanks.

00:24Now you're going to type the formula equal A2 and you're going to press Ctrl and Enter

00:28on your keyboard and this is going to populate all your blank spaces.

00:32Now select the complete data set from A1 all the way down to C27.

00:36Then you go to the data pull down menu here and go outline and click on subtotal.

00:41At each change, you're going to select branch and location and for function, I'm going to

00:45use sum because I'm going to use subtotal.

00:47And then over here, I'm going to subtotal the sales column only and click OK.

00:52Once that's done, you can see all the subtotals are calculated, including your grand total

00:57right at the bottom.

Insert Subtotal From Ribbon - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended