Error message when inserting rows

users
#1

Hello,

I am trying to use the "insert rows above" function to insert around 70 rows at a time.

I keep getting the following error: "Filled cells cannot be shifted beyond the sheet." Closing the sheet and program and re-opening does not resolve the issue.

Spreadsheet is not very big and there appears to be thousands of rows available.

LibreOffice: Version: 4.4.5.2
Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
Locale: en_US

Windows 8.1

Any ideas?

#2

Would that insertion push your sheet to more than 1M rows?

#3

Ctrl+End jumps to the last cell which is the bottom-right corner of the
sheet's used range.
There you might find some orphane data which would be pushed beyonds the
sheet border.

#4

Control End worked great. Found invisible stuff way at the end of the sheet. Thank-you!