@exceldictionary: 👉🏼 DM me 'WIZARD' and I'll send you my FREE Excel shortcut guide   How to fill every subtotal row at once in Excel ⚡   Adding a SUM formula to each total row one at a time is slow, and it's easy to miss a row or select the wrong range.Two shortcuts can do every total in one go.   Press Ctrl + A to select your table, then Ctrl + G and Alt + S to open Go To Special, choose Blanks and click OK. Now press Alt + =, and Excel adds a SUM to every empty total row at once, each one covering only the rows above it.   It's perfect for quarterly reports, monthly sales tables, budgets and any table broken into sections with subtotals.   I'm teaching people how to actually use AI and Excel to automate their workflows and become the most productive version of themselves at work.   Follow @exceldictionary for daily Excel + AI tips.

Excel Dictionary

Open In TikTok:

Region: US

Friday 13 November 2026 17:00:22 GMT