Microsoft Excel Can't insert new cells

excel excel-formula excel-2010
kayyowens picture kayyowens · Oct 13, 2016 · Viewed 89.9k times · Source

I am receiving an error saying:

Microsoft Excel can't insert new cells because it would push non empty cells off the end of the worksheet.

This happens when I try to insert a new row of data. I need to keep all of the data on the sheet I already have. I only have 56 rows, so I think I should be able to add more...

Answer

MattB picture MattB · Oct 13, 2016

Excel has a limited number of rows and columns (which varies with version).

To find your last cell with data in it, click on any cell and then press Ctrl+End. This will then take you to the furthest from A1 which has content. You'll need to remove what is there to add extra rows.

Related questions

Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

Read More
Ignore Duplicates and Create New List of Unique Values in Excel

I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows: Column A Column B a a a b b c c c …

Read More
Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details. Something like this A B q123 as124 as124 gh456 ff45 q123 dd1 dd2 xx2 xx3 xx4 …

Read More