Excel Study · Module 1: First steps
Class 2SUM & the AutoSum shortcut
Basics1:33 videoFree
Add a whole column in Excel with =SUM(B2:B7) — the colon means "to", so B2:B7 is every cell from B2 to B7. Faster still: AutoSum. Press Alt + = on Windows (Shift + Cmd + T on a Mac) and Excel writes the SUM formula for you.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, I have monthly sales in cells B2 to B7. Write a formula that adds them all up.
The answer that works
✓ checked in Excel=SUM(B2:B7)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.