[Solved] Filled Cells cannot be shifted beyond the sheet

[Sharkman]

Hi All.
Need some help please.
I started a sheet and have 247 rows and 9 columns.
I saved the file. On opening it again, I am trying to insert more rows and I get an error saying "Filled Cells cannot be shifted beyond the sheet".
How can I clear this and add more rows please?

Thanks

[Sharkman]

Re the above, I solved the issue by copying all the data to sheet 2 and than deleted sheet 1.

Thank you.

[Lupp]

Go to cell A248 and use Ctrfl+Shift+End to see the actually used area of the sheet.
You surely will find that you once filled at least one cell far below of the 247 rows you filled advertently. Check and clear the range you don't need before you insert your new rows in the place you want them.
If you actually need rows near the bottom for special reasons, there is no way. Insertion of rows tries to shift everything below down, and the error message is telling you if that can't be done.

[Sharkman]

Thank you. Will remember this.