The Subtotal command will appear grayed out if you are working with an Excel table. To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal.

May 9, 2024 · In this instructive session, I’ll demonstrate 4 methods on how to make subtotal and grand total in Excel with the necessary explanation.

Sep 22, 2025 · Learn how to subtotal in Excel using simple methods ranging from manual Excel functions to Excel VBA-based automation. When you analyze a large dataset in Excel, you might …

Aug 4, 2025 · That’s where Excel’s **Subtotal feature** comes in handy. It automatically calculates subtotals for grouped data and even creates collapsible sections for easy navigation. In this guide, …

On the Data tab, in the Outline group, click Subtotal to outline your data. Explanation: in this example, Excel automatically added 5 SUBTOTAL functions (B6, B9, B13, B19 and B20).

Jul 11, 2024 · Learn how to create subtotals in Excel with our step-by-step guide. Perfect for beginners looking to organize and summarize their data efficiently.

Jan 29, 2025 · Excel’s Subtotal feature is here to rescue you from endless scrolling and formula errors. This article shows you step-by-step how to use Subtotal in Excel to organize and analyze your data …

May 28, 2025 · When you apply a filter to your data or manually hide certain rows, SUBTOTAL() automatically adjusts its calculation to include only the visible cells. This behavior makes it an …

Mar 20, 2023 · The tutorial explains how to use the Excel Subtotal feature to automatically sum, count or average different groups of cells. You will also learn how to display or hide the subtotal details, copy …

Feb 16, 2025 · In this short video, you'll see the steps for creating subtotals with the Microsoft Excel Subtotal command. Also, discover how to prevent the problem of duplicate grand totals. The written …