Adding row in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2478814%22%20slang%3D%22en-US%22%3EAdding%20row%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478814%22%20slang%3D%22en-US%22%3EWhen%20trying%20to%20add%20a%20row%20to%20a%20large%20worksheet%20I%E2%80%99m%20getting%20the%20message%20%E2%80%9CMicrosoft%20Excel%20can%E2%80%99t%20insert%20new%20cells%20because%20it%20would%20push%20Jon-empty%20cells%20off%20the%20end%20of%20the%20worksheet%E2%80%A6.%E2%80%9D%20I%20was%20adding%20several%20rows%20just%20before%20this%20and%20they%20mysteriously%20disappeared%20just%20before%20this%20occurred.%20I%E2%80%99ve%20tried%20several%20online%20suggestions.%20At%20one%20point%20I%20was%20able%20to%20add%20one%20row%20of%20info%20but%20now%20I%E2%80%99m%20back%20to%20square%20one.%20I%20am%20fairly%20new%20with%20excel%20and%20was%20starting%20to%20feel%20confident!%20Any%20help%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2478814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2482900%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20row%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2482900%22%20slang%3D%22en-US%22%3EHello%20Vherbert%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPerhaps%20you%20have%20a%20range%20of%20cells%20in%20or%20near%20row%201048576%20or%20column%20XFD%20that%20are%20not%20empty.%20Examine%20these%20areas.%20If%20you%20are%20sure%20that%20cells%20near%20the%20bottom%20or%20right%20of%20your%20worksheet%20should%20be%20empty%2C%20then%20I%20would%20suggest%20highlighting%20all%20rows%20or%20column%20below%20or%20to%20the%20right%20of%20your%20data%20and%20deleting%20these%20cells.%20Be%20sure%20to%20unhide%20all%20hidden%20cells%20by%20pressing%20Ctrl%20%2B%20A%20twice%20and%20then%20right-clicking%20to%20Unhide%20cells.%3C%2FLINGO-BODY%3E
Occasional Visitor
When trying to add a row to a large worksheet I’m getting the message “Microsoft Excel can’t insert new cells because it would push Jon-empty cells off the end of the worksheet….” I was adding several rows just before this and they mysteriously disappeared just before this occurred. I’ve tried several online suggestions. At one point I was able to add one row of info but now I’m back to square one. I am fairly new with excel and was starting to feel confident! Any help appreciated.
1 Reply
Hello Vherbert,

Perhaps you have a range of cells in or near row 1048576 or column XFD that are not empty. Examine these areas. If you are sure that cells near the bottom or right of your worksheet should be empty, then I would suggest highlighting all rows or column below or to the right of your data and deleting these cells. Be sure to unhide all hidden cells by pressing Ctrl + A twice and then right-clicking to Unhide cells.