AutoSum in Excel: Total Ek Click Mein — Shortcut, Formula & Fixes (2026)

AutoSum in Excel explained — Alt+= shortcut, SUM formula, multiple columns total and not-working fixes. Excel me total kaise kare — complete step-by-step guide.

Excel Oct 15, 2026 0 8 Add to Reading List

AutoSum in Excel: Total Ek Click Mein — Shortcut, Formula & Fixes (2026)

AutoSum is Excel's fastest way to total numbers — one click (or one shortcut) and Excel writes the SUM formula for you. No typing, no selecting ranges manually.

This guide covers the AutoSum button, the Alt+= shortcut, summing rows and columns together, and what to do when AutoSum stops working — for Windows, Mac and Excel mobile.

What Is AutoSum in Excel?
Method 1: AutoSum Button (Home Tab)
Method 2: Alt + = Shortcut (Fastest)
Method 3: Total Multiple Columns at Once
AutoSum on Excel Mobile & Mac
AutoSum Not Working? Common Fixes
SUM vs AutoSum vs SUBTOTAL — Difference
Frequently Asked Questions
Conclusion

What Is AutoSum in Excel?

AutoSum automatically detects the numbers above or beside your cell and inserts a =SUM() formula. It's the quickest way to total marks, sales, expenses or any column of numbers.

Example: numbers in B2:B10 → click B11 → AutoSum → Excel writes =SUM(B2:B10) and shows the total.

Hindi: AutoSum ka matlab — Excel khud SUM formula likh dega. Numbers ke neeche click karo, AutoSum dabao, total ready!

Method 1: AutoSum Button (Home Tab)

Select the empty cell just below your numbers (or to the right, for a row)
Go to the Home tab
Click AutoSum (Σ) in the Editing group
Excel highlights the range it detected — check it's correct
Press Enter — total done!

Tip: AutoSum also lives under Formulas → AutoSum, and its dropdown gives Average, Count, Max, Min too.

Method 2: Alt + = Shortcut (Fastest)

Click the cell below (or beside) your numbers
Press Alt + =
Excel instantly inserts =SUM(range) with the range pre-selected
Press Enter — done!

This shortcut works in Excel on Windows — it's the fastest way professionals total data.

Method 3: Total Multiple Columns at Once

Want to total several columns in one shot?

Select the data range including the empty total row below (e.g., B2:E10 → select B2:E11)
Press Alt + =
Excel drops a SUM into every column's total cell — all totals at once!

Same trick works for rows: select the data plus the empty total column on the right, then Alt+=.

AutoSum on Excel Mobile & Mac

Excel Mobile app: tap the cell → tap ƒx (Functions) → SUM → select range → ✓
Excel on Mac: Cmd + Shift + T inserts AutoSum, or use Home → Σ button
Google Sheets: Σ icon in toolbar or =SUM() formula — same logic

AutoSum Not Working? Common Fixes

Numbers stored as text — the biggest culprit! Numbers aligned left with a green triangle = text. Fix: select them → click the warning icon → "Convert to Number"
Blank cells inside the range — AutoSum stops at the first empty cell; select the range manually
Hidden/filtered rows — AutoSum may skip them; use SUBTOTAL for filtered data
Formula shows instead of result — cell format is Text; change to General and re-enter
Sheet protected — unprotect the sheet first

SUM vs AutoSum vs SUBTOTAL — Difference

| Function | Use When |

|---|---|

| AutoSum | Quick one-click total — inserts SUM for you |

| =SUM() | Manual control — any cells/ranges you pick |

| =SUBTOTAL(9,...) | Filtered tables — counts only visible rows |

| =SUMIF / SUMIFS | Total only matching conditions (e.g., one month) |

Frequently Asked Questions

What is the AutoSum shortcut in Excel?

Alt + = on Windows. On Mac, use Cmd + Shift + T or the Σ button on the Home tab.

Excel mein total kaise kare?

Numbers ke neeche wali cell pe click karo → Alt + = dabao → Enter. AutoSum khud formula likh dega.

Why is my AutoSum not working?

Usually numbers are stored as text (left-aligned, green triangle). Convert them to numbers. Blank cells in the range also break detection — select the range manually.

Can AutoSum total a row instead of a column?

Yes — click the empty cell to the right of the row's numbers and press AutoSum/Alt+=. Excel detects horizontal numbers too.

How do I total only filtered (visible) rows?

Use =SUBTOTAL(9, range) — it ignores hidden and filtered-out rows, unlike SUM.

Does AutoSum work in Google Sheets?

Yes — the Σ icon in the toolbar or typing =SUM( works the same way.

Conclusion

AutoSum is the fastest total in Excel: click below your numbers → Alt + = → Enter. For multiple columns, select everything including the blank total row and press Alt+= once — all totals done in one shot.

???? Video Tutorial: [Embed YouTube video — Excel Tips #08]