In Excel: to insert blank cells, select where they go and press Ctrl+Shift++ then choose the shift direction — to add cell values together, use =SUM(A1:A10) or =A1+A2.
On this page7
To insert: select the same number of cells as you want to add, in the place they should appear.
Press Ctrl+Shift++ or use Home ▸ Cells ▸ Insert ▸ Insert Cells.
Choose "Shift cells right" or "Shift cells down" — or Entire row / Entire column to avoid misaligning the table.
To sum: click the cell below or beside the numbers and press Alt+= for an automatic =SUM over the adjacent range.
Check the proposed range before pressing Enter; AutoSum stops at the first blank cell.
For non-adjacent cells, write =SUM(A1:A10, C1:C10) or Ctrl-click each range while the formula is open.
What this does
"Add cells" means two different things and it is worth separating them. Inserting cells pushes the existing ones down or right: select the cells, press Ctrl+Shift++ (or Home ▸ Insert ▸ Insert Cells), and pick "Shift cells right" or "Shift cells down". This is the operation that can misalign a table, because it moves only part of a row. Summing cells adds their values: =SUM(A1:A10) for a range, =A1+A2 for two, =SUM(A1:A10, C1:C10) for two separate ranges, and =SUM(Jan:Dec!B4) for the same cell across sheets. If the sum returns 0, the cells are text, not numbers. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “add cells together in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
To push B5:B9 down by three rows without touching the neighbouring columns: select B5:B7, press Ctrl+Shift++, choose "Shift cells down", OK. To insert whole rows instead — usually what you actually want — select the row numbers first and the dialog does not appear. To total a column: click below it and press Alt+= for =SUM(A2:A20), then Enter. If that returns 0, select the range and check the status bar: if Sum is missing and only Count shows, the values are text. It is the most-asked beginner question in Excel precisely because the phrase is ambiguous, and the two answers — inserting and summing — have almost nothing in common. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.
In Google Sheets
Excel's 3-D references that span several sheets, such as =SUM(Jan:Dec!B4), are not supported in Google Sheets; there you add the sheets individually, for example =SUM(Jan!B4, Feb!B4, Mar!B4). Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. The short version of “add cells together in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.
Common mistakes
- Inserting cells with a shift direction when whole rows or columns were meant, which knocks one part of the table out of alignment with the rest.
- Trusting AutoSum's proposed range, which stops at the first blank row and silently omits the rest.
- Summing a column of numbers stored as text and getting 0 — the status bar shows Count but no Sum when that is the cause.
- Including the total cell inside its own
SUMrange, which creates a circular reference. - Adding cells one by one with
=A1+A2+A3+…where=SUM(A1:A20)keeps working when rows are inserted.
Frequently asked questions
How do I add cells in Excel?
To insert blank cells, select the position and press Ctrl+Shift++, then choose the shift direction. To add values together, use =SUM(A1:A10) or press Alt+= for AutoSum.
What is the shortcut for AutoSum?
Alt+= — it inserts =SUM over the adjacent range of numbers. Always check the range it proposed before pressing Enter.
Why does my SUM return 0?
The values are text rather than numbers. Select them and look at the status bar: if it shows Count but no Sum, convert them with Data ▸ Text to Columns ▸ Finish, or multiply by 1.
How do I add cells from different sheets?
Use a 3-D reference for the same cell across a run of sheets: =SUM(Jan:Dec!B4). For arbitrary cells, =Sheet1!B4+Sheet2!C7 works too.
Other ways people ask this
On the way here you may have searched this as “add excel cells together”, “how do you add cells together in excel” and “how to add 2 cells together in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “add excel cells together”, “how do you add cells together in excel”, “how to add 2 cells together in excel” all point at the one operation explained on this page, which is why they all lead here.