Microsoft Excel cannot add new cells? Check out these tips

by Teodor Nechita
Teodor Nechita
Teodor Nechita
Software Managing Editor
Eager to help those in need, Teodor writes articles daily on subjects regarding Windows, Xbox, and all things tech-related. When not working, you may usually find him either... read more
Affiliate Disclosure
microsoft excel cannot add new cells
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

The Microsoft Office Suite is a host of programs that covers pretty much all of the most basic needs you may have when working in an office environment.

You have your dedicated program that handles text documents, another program that does presentations, etc.

You even have a program specially made to act like a spreadsheet, called Microsoft Excel, which can handle information that spans hundreds of cells of data.

However, some users have reported that sometimes they get an error message in Microsoft Excel where it states that the program cannot add any more cells.

Just FYI, I had the same problem occur when trying to insert a column. […]
The full error message I was getting was:
Microsoft Excel
can’t insert new cells because it would push non-empty cells off the end of the worksheet. These cells might appear empty but have blank values, some formatting, or a formula. Delete enough rows or columns to make room for what you want to insert and then try again.

Steps to follow if Microsoft Excel can’t add any new cells

Thankfully, unlike many other messages that you would normally receive, this one pretty much comes with an explanation as to why it is happening.

Apparently, the error message only happens when you have an entire row merged.

This means that when inserted the content in the workbook (most probably via Copy/ Paste), you somehow have added content on the last row of the sheet.

Because of this, you will need to clear that content before you can add new rows.

This doesn’t mean that you have to delete the data in the cells, but rather the formatting you may have copied along with the values.

  1. Select all the data that was copied
  2. Find the Clear tool on the toolbar
  3. Open the drop-down menu and select Clear Formats

microsoft excel cannot add new cells clear formats

After following these steps, you should be able to insert data without any further issues. More so, to avoid any similar problems, do not paste data in a spreadsheet using Ctrl + V.

Instead, do the following:

  1. Right-click on an open area of the spreadsheet
  2. Select Paste Special
  3. Select Values
  4. Press OK

By following all of the steps mentioned above, you should be able to insert cells in an Excel worksheet without any more issues.

If you have any other suggestions or questions, don’t hesitate to leave them in the comments section below.


idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: