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
[Solved] Filled Cells cannot be shifted beyond the sheet
[Solved] Filled Cells cannot be shifted beyond the sheet
Last edited by Hagar Delest on Tue Aug 03, 2021 10:10 am, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
OpenOffice 4.1.10 on Windows 10 pro
Re: Locked Sheet.
Re the above, I solved the issue by copying all the data to sheet 2 and than deleted sheet 1.
Thank you.
Thank you.
OpenOffice 4.1.10 on Windows 10 pro
Re: Locked Sheet.
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.
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.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Filled Cells cannot be shifted beyond the sheet
Thank you. Will remember this.
OpenOffice 4.1.10 on Windows 10 pro