SUBTOTAL in Excel
Excel Shortcut That Saves Hours — Article Excel Subtotal Shortcut — Quick Guide A short, practical write-up with the demonstration embedded. Perfect for finance and data users who want instant subtotals without typing formulas. What this tip does Instead of inserting SUM formulas row by row, you can use Excel's built-in Subtotal feature to produce grouped totals instantly. This speeds up repetitive expense and product reports and helps you drill down into grouped rows with a single click. How to use (quick steps) Select your data (top to bottom). Tip: Ctrl + Shift then arrow keys to expand the selection quickly. Open the Subtotal dialog: press Alt then A then B . Choose the column to group by, pick the function (SUM by default), and confirm. Excel adds subtotal rows and a summary at the bottom. ...