In Excel: find the cause before retrying — if Excel says it "cannot shift nonblank cells off of the worksheet", clear everything below your data (select the first empty row, Ctrl+Shift+Down, Home ▸ Clear ▸ Clear All) and save; if Insert is greyed out, the sheet is protected (Review ▸ Unprotect Sheet).
On this page7
Read the message: "cannot shift nonblank cells off of the worksheet" means something sits at the bottom edge; a greyed-out Insert means protection.
Press Ctrl+End to see where Excel thinks the used range ends.
If it is far below your data, select the first empty row, press Ctrl+Shift+Down, then Home ▸ Clear ▸ Clear All (or delete those rows).
Save the workbook so Excel resets the used range, then try Insert again.
If Insert is greyed out, choose Review ▸ Unprotect Sheet (you may need the password), insert, and protect again with "Insert rows" allowed if others need it.
If a second table sits directly below the one you are editing, move it or insert whole sheet rows instead of table rows.
What this does
Inserting a row pushes every row below it down by one. Excel refuses when that push would lose something: a worksheet has a fixed last row, so if any cell in that last row holds a value or formatting, there is nowhere to move it and Excel stops with the message about shifting nonblank cells off the worksheet. The other common block is protection — on a protected sheet the Insert commands are disabled unless insertion was explicitly allowed when protecting. Inserting inside an Excel table can also be refused when the shift would move cells of another table below it. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. For “microsoft excel can't insert new cells”, 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 workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A sheet has data in A1:F300, but at some point a formula in column G was filled all the way down to row 1,048,576, the last row of the sheet. Right-click ▸ Insert returns the "cannot shift nonblank cells" message. Select row 301, press Ctrl+Shift+Down to extend to the last row, choose Home ▸ Clear ▸ Clear All, save the workbook, and Insert works again. Ctrl+End now lands near F300 instead of the bottom of the sheet. A sheet that silently refuses to grow blocks every routine update. The cause is almost always one of a few structural conditions, and checking them in order is faster than rebuilding the workbook. 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
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “microsoft excel can't insert new cells”: 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
- Deleting only the visible empty rows while a value or formula far below them keeps the last row occupied.
- Retrying Insert before saving — the used range is often only recalculated after a save.
- Assuming the file is corrupt when the sheet is simply protected.
- Clearing contents (Delete key) when the blocker is formatting; Clear All removes both.
Frequently asked questions
Why does Excel say it cannot shift nonblank cells off the worksheet?
Because the last row (or last column, for column inserts) contains a value or formatting, so the rows being pushed down would fall off the sheet. Clear everything below your real data and save.
Why is Insert greyed out?
Most often the worksheet is protected. Unprotect it from the Review tab; when protecting again you can tick "Insert rows" to allow it.
Is this the same problem when I cannot insert cells or columns?
Yes. Columns are blocked by content or formatting in the last column, cells by whichever edge the shift moves toward; the fix is the same clear-and-save.
Other ways people ask this
This is also commonly searched as “microsoft excel cant insert new cells” and “microsoft excel can't insert new cells because it would push”. 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. “microsoft excel cant insert new cells”, “microsoft excel can't insert new cells because it would push” all point at the one operation explained on this page, which is why they all lead here.