1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales 4.Click Ok 7. Click on the grouping feature 2 to look at the Region Subtotal 8. Then click a cell in Sales Rep and select Data->OutLine->SubTotal 9. In the SubTotal Window select 1.Each Change in: Sales Rep 2.Use function:Sum 3.Add subTotal to:Sales 4.Uncheck Replace current subtotal 4.Click Ok 10. Click on the grouping feature 4 to look at the Region cum SalesRep SubTotal Subtotal 11. To copy the SubTotal Cells to another Sheet follow the Below Steps. 12. Method 1: 13. HighLight Subtotal Cells. 14. Press F5 And Click Special in GoTo Window and select visible cell only. 15. Method 2: 16. HighLight Subtotal Cells. 17. In Home-> Find Button Click Go to Special and select visible cell only. 18. Method 3: 19. HighLight Subtotal Cells. 20. Press Ctrl+Semicolon. 21. After using any one method, copy the Cells and Paste in a new Sheet.
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.
Other worthwhile deals to check out:
- 97% off The Ultimate 2021 White Hat Hacker Certification Bundle
- 98% off The 2021 Accounting Mastery Bootcamp Bundle
- 99% off The 2021 All-in-One Data Scientist Mega Bundle
- 59% off XSplit VCam: Lifetime Subscription (Windows)
- 98% off The 2021 Premium Learn To Code Certification Bundle
- 62% off MindMaster Mind Mapping Software: Perpetual License
- 41% off NetSpot Home Wi-Fi Analyzer: Lifetime Upgrades
1 Comment
i have a test tomorrow . it was helpful, thank you.
Share Your Thoughts