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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “add multiple cells in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. 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. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
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. Here is the takeaway for “add multiple cells in excel”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.
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
This is also commonly searched as “how to add in multiple cells excel”, “how do you add multiple cells in excel”, “how do i add multiple cells in excel” and “excel formula to add multiple cells”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to add in multiple cells excel”, “how do you add multiple cells in excel”, “how do i add multiple cells in excel” all point at the one operation explained on this page, which is why they all lead here.