[Solved] Trying to Insert Row: "Filled cells cannot be

[JohnTN]

Just trying to insert a row in a spreadsheet and get a message: "Filled cells cannot be shifted beyond the sheet". Open Office 3.1.0.

If I go to the bottom of the spreadsheet with empty rows it will let me insert a row. I am trying to insert a new name and address in an alphabetical listing.

John

[RusselB]

First suggestion is that you upgrade your version of OpenOffice. 3.1.0 is very old and may not have all of the abilities available in later versions.
That said, what row do you get if you use Ctrl+End? That will be the bottom row and right most column of your spreadsheet.
I don't have a copy of 3.1.0, but in 4.1.6, you can have 1,048,576 rows.
Since your task is to put in new information in alphabetical order, you could just enter the information, then sort the spreadsheet using the name column (I'm guessing) as the primary sort key.

[JohnTN]

I will try updating and using sort as a last resort but I don't think the version is the problem. This spreadsheet was copied from another sheet that contained addresses for 2018 and the 2018 sheet will let me add rows. This years sheet (a copy of 2018 sheet renamed for 2019) will let me add rows on other tabs in the spreadsheet but not on the one tab that contains the list of address (about 150 rows of addresses). If I go to row 151 which contains no data it will let me insert a row above 151.

John

[JohnTN]

Another test I tried. I want to insert a row above the current row 20. I tried deleting the contents of row 20 so there were no entries in that row and then inserting a row above it but still got same message. FYI, there are 65,536 rows in my spreadsheet, all below row 150 are empty, as far as I know.
John

[RoryOF]

To move quicky to the last cell with content, try Ctrl End. It may be that a cell has a pace or a full stop in it.

[JohnTN]

Solved. Somehow there was one column that had data copied into it all the way to the bottom of the sheet. When I deleted all this extraneous data it freed up the sheet to let me insert rows.

John