Problem with Excel Formatting and inserting new rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2248755%22%20slang%3D%22en-US%22%3EProblem%20with%20Excel%20Formatting%20and%20inserting%20new%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2248755%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20at%20least%2010%20empty%20rows%20at%20the%20bottom%20of%20my%20worksheet%20to%20allow%20more%20information%20to%20be%20added.%20I%20did%20something%20and%20now%20when%20I%20try%20to%20add-in%20new%26nbsp%3Brows%20I%20get%20this%20error%20message%20%22Microsoft%20Excell%20can't%20insert%20new%20cells%20because%20it%20would%20push%20non-empty%20cells%20off%20the%20end%20of%20the%20worksheet.%26nbsp%3B%20These%20non-empty%20cells%20might%20appear%20empty%20but%20have%20blank%20values%2C%20some%20formatting%2C%20or%20a%20formula.%26nbsp%3B%20Delete%20enough%20rows%20or%20columns%20to%20make%20room%20for%20what%20you%20want%20to%20insert%20and%20then%20try%20again.%22%26nbsp%3B%20I%20have%20tried%20to%20remove%20formulas%20and%20I%20don't%20see%20where%20any%20are%20added.%26nbsp%3B%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2248755%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
New Contributor

I have at least 10 empty rows at the bottom of my worksheet to allow more information to be added. I did something and now when I try to add-in new rows I get this error message "Microsoft Excel can't insert new cells because it would push non-empty cells off the end of the worksheet.  These non-empty cells might appear empty but have blank values, some formatting, or a formula.  Delete enough rows or columns to make room for what you want to insert and then try again."  I have tried to remove formulas and I don't see where any are added.  Please help.

5 Replies
I found my answer. I'm all set

@Lynn23 

With your permission, please add a / this file (without sensitive data).

So you can exclude a lot in advance without causing a lot of writing traffic.

Explain your plan or problem on the basis of this file. this way you will come to a solution proposal that might suit you much faster and better.

 

Thank you for you all understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Thank you for your quick reply. I found my solution and It worked great. The solution was fairly simple. You click on the last cell outside of your worksheet then hit Ctrl+Shift+Down Arrow. Then while holding down the Ctrl+Shift keys you right-click. Then hit Delete, then Entire Row. This solved my problem. I found that I had added a formula on row 106,562.
I am glad for you that you could find a solution to your problem.

I wish you continued success with Excel.

Nikolino
I know I don't know anything (Socrates)
Ooh, thank you! I get this problem all the time! I will try out your solution next time.