I'm trying to update a spreadsheet that I've been using for some time. All I want to do is insert rows (which I've done many times before), but now it comes up with a message "Filled cells cannot be shifted beyond the sheet". I don't know what this means.
Please can some kind person tell me in simple steps how to fix this, as I'm not very technically minded? Many thanks!
[Solved] Spreadsheet Error Message
[Solved] Spreadsheet Error Message
Last edited by robleyd on Fri Oct 19, 2018 12:48 am, edited 2 times in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Reason: Tagged [Solved] [robleyd, Moderator]
Open Office 4.1.3. on Windows 10
Re: Spreadsheet Error Message
You have probably inadvertently entered something in the last row so that when you try to insert a row there is no room for that information to be shifted down. Press the key combination CTRL END (both keys pressed at once) to go to the last used row and last used column. You should find that you are in the last row of the spreadsheet. If there is nothing in that cell, press CTRL LEFT_ARROW to move to the first occupied cell in that row. Delete or move whatever is there.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Spreadsheet Error Message
Brilliant, all sorted! Many thanks for the quick response.
Open Office 4.1.3. on Windows 10