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
Highlighted
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 

1 Reply
Highlighted

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