help with insert a row error message

%3CLINGO-SUB%20id%3D%22lingo-sub-1629966%22%20slang%3D%22en-US%22%3Ehelp%20with%20insert%20a%20row%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629966%22%20slang%3D%22en-US%22%3E%3CP%3EHELP!%26nbsp%3B%20please%20see%20pic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20doing%20simple%20EXCEL%20spreadsheets%20for%20years%20and%20I've%20never%20seen%20this%20error%20message%20before%20and%20I%20can't%20figure%20out%20how%20to%20fix%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20I'm%20doing%20is%20trying%20to%20insert%20a%20new%20row%20and%20it%20keeps%20saying%20this.%20I've%20tried%20doing%20it%20all%20over%20the%20spreadsheet%20on%20different%20rows%20thinking%20that%20it%20was%20related%20to%20just%20one%20row%20but%20it's%20doing%20it%20every%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22unnamed%20(1).jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216186i56BAA3315985E6AE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22unnamed%20(1).jpg%22%20alt%3D%22unnamed%20(1).jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1629966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1630186%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20insert%20a%20row%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1630186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780307%22%20target%3D%22_blank%22%3E%40LoriFuller13%3C%2FA%3E%26nbsp%3BTry%20selecting%20all%20rows%20below%20you%20last%20row%20and%20delete%20them.%20Save%20and%20close%20the%20file.%20Then%20reopen.%20Does%20it%20fix%20the%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2096099%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20insert%20a%20row%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BNO%20IT%20DIDNT%20HELP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

HELP!  please see pic.

 

I've been doing simple EXCEL spreadsheets for years and I've never seen this error message before and I can't figure out how to fix it.

 

All I'm doing is trying to insert a new row and it keeps saying this. I've tried doing it all over the spreadsheet on different rows thinking that it was related to just one row but it's doing it every time. 

 

thanksunnamed (1).jpg 

5 Replies

@LoriFuller13 Try selecting all rows below you last row and delete them. Save and close the file. Then reopen. Does it fix the problem?

 

@Riny_van_Eekelen NO IT DIDNT HELP

 

Try Clear/All from the Editing group on the Home tab. Even if the contents of the cell are deleted, you can still get that error if the cells have formatting applied to them.

Convert it into table and then try, if possible share the workbook @LoriFuller13 

I tried this also and still get the same error message. Still need help with this.