Can't add new raws in Excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1570229%22%20slang%3D%22en-US%22%3ECan't%20add%20new%20raws%20in%20Excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570229%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20started%20getting%20this%20error%20message%20in%20some%20Excel%20sheets%20(not%20all)%2C%20every%20time%20I%20wanted%20to%20add%20a%20new%20raw%20in%20my%20sheet.%3C%2FP%3E%3CP%3EThe%20error%20message%20says%3A%3C%2FP%3E%3CP%3E%22So%20that%20data%20doesn't%20get%20lost%2C%20you%20cannot%20move%20cells%20with%20data%20outside%20the%20Excel%20sheet.%20Mark%20another%20place%20to%20bring%20in%20new%20cells%2C%20or%20delete%20data%20from%20the%20end%20of%20the%20Excel%20sheet.%3C%2FP%3E%3CP%3EIf%20you%20don't%20have%20data%20in%20cells%20that%20could%20be%20moved%20outside%20the%20Excel%20sheet%2C%20you%20can%20then%20reset%20which%20cells%20Excel%20treats%20as%20empty%20or%20full.%20You%20do%20that%20by%20clicking%20Ctrl%2BEnd%20and%20going%20to%20the%20last%20cell%20with%20input.%20Delete%20this%20cell%20and%20all%20cells%20between%20this%20cell%20and%20the%20last%20cell%20with%20you%20data%20and%20columns.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcuse%20my%20translation%2C%20my%20original%20message%20was%20in%20Swedish...But%20hopefully%20you%20get%20the%20point.%3C%2FP%3E%3CP%3EI%20have%20done%20what%20it%20says%20and%20nothing%20happens%2C%20it%20doesn't%20work.%20I%20have%20deleted%20all%20cells%20and%20columns%20and%20saved%20and%20closed%20down%20the%20file%20and%20reopened%2C%20without%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20out%20here.%3C%2FP%3E%3CP%3E-%20How%20can%20I%20add%20new%20raws%2C%20despite%20this%20error%20message%3F%3C%2FP%3E%3CP%3E-%20Why%20am%20I%20getting%20this%20message%20suddenly%3F%20(I%20have%20never%20gotten%20this%20message%20before%3F!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20screen%20shot%20of%20the%20error%20message%2C%20in%20Swedish.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Hosssam_0-1596706916078.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210596i2F648EA177019848%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Hosssam_0-1596706916078.png%22%20alt%3D%22Hosssam_0-1596706916078.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBR%2C%20Hossam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1570229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570866%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20add%20new%20raws%20in%20Excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570866%22%20slang%3D%22en-US%22%3E-%20Scroll%20to%20what%20you%20think%20is%20the%20last%20used%20row.%3CBR%20%2F%3E-%20Select%20all%20rows%20beneath%20that%20row%20and%20delete%20them%3CBR%20%2F%3E-%20Repeat%20for%20the%20last%20used%20column%3CBR%20%2F%3E-%20Save%20(a%20copy%20of)%20your%20file%3CBR%20%2F%3E-%20Now%20try%20adding%20a%20row.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I started getting this error message in some Excel sheets (not all), every time I wanted to add a new raw in my sheet.

The error message says:

"So that data doesn't get lost, you cannot move cells with data outside the Excel sheet. Mark another place to bring in new cells, or delete data from the end of the Excel sheet.

If you don't have data in cells that could be moved outside the Excel sheet, you can then reset which cells Excel treats as empty or full. You do that by clicking Ctrl+End and going to the last cell with input. Delete this cell and all cells between this cell and the last cell with you data and columns."

 

Excuse my translation, my original message was in Swedish...But hopefully you get the point.

I have done what it says and nothing happens, it doesn't work. I have deleted all cells and columns and saved and closed down the file and reopened, without success.

 

Can someone please help out here.

- How can I add new raws, despite this error message?

- Why am I getting this message suddenly? (I have never gotten this message before?!)

 

 

Here is a screen shot of the error message, in Swedish.

Hosssam_0-1596706916078.png

 

BR, Hossam

1 Reply
- Scroll to what you think is the last used row.
- Select all rows beneath that row and delete them
- Repeat for the last used column
- Save (a copy of) your file
- Now try adding a row.