1
Ctrl + ↓ → move to empty cellNavigate to the cell where the total should appear
Jump to the empty cell at the end of a column or row with Ctrl+↓ to land in position instantly.
AutoSumAlt+=totals
Streamline Totals with AutoSum (Alt+=)
You do not need to type the function name just to get a total. Making Alt+= a habit takes a significant load off everyday aggregation tasks.
Shortcuts you will master in this article
Alt + = / Ctrl + Shift + ↓ / Ctrl + D
Typing SUM by hand every time accumulates small but real losses
SUM is one of the most frequently used functions in Excel. The higher the frequency, the more value a shortcut that reduces entry cost delivers.
Alt+= also infers the range automatically, which makes it especially well matched to summary columns and summary rows.
How to use AutoSum
Deciding where to place the total cell first makes everything much smoother.
2
Alt + =Auto-insert a SUM formula
Infers the surrounding range and inserts the sum formula for you.
3
EnterConfirm the formula
That is all it takes to insert the total in most cases.
4
Ctrl + D / Ctrl + RExtend similar totals down or across
Makes building totals across multiple columns even faster.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Situations where Alt+= is most useful
Column-end totals, row-end totals, and monthly summaries are the best use cases.
Always verify that the inferred range matches your intent.
When applying the same formula to multiple locations, combine with F4 or fill shortcuts for further efficiency.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Alt + = | AutoSum |
Ctrl + D | Fill Down |
Ctrl + R | Fill Right |
Frequently Asked Questions
Q. Alt+= selected a range I did not intend.
A. The inference can be thrown off by gaps or unrelated data nearby. Check and correct the range after insertion.
Q. Can I use it for functions other than SUM?
A. Alt+= itself is designed for SUM, but it is a powerful entry point for aggregation workflows.
Q. Does it work for horizontal totals too?
A. Yes. Running it in the cell at the end of a row often infers the horizontal range correctly.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →