Can not insert new rows in a page

%3CLINGO-SUB%20id%3D%22lingo-sub-1516709%22%20slang%3D%22en-US%22%3ECan%20not%20insert%20new%20rows%20in%20a%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516709%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20insert%20a%20row%20in%20a%20page%20and%20excel%20shows%20me%20the%20next%20message%3C%2FP%3E%3CP%3E%22Microsoft%20excel%20can%20not%20insert%20new%20cells%20because%20it%20would%20push%20nos%20empty%20cell%20off%20the%20end%20of%20the%20worksheet.%20These%20cells%20might%20appear%20empty%20but%20have%20blank%20values%2C%20some%20formatting%20or%20a%20formula%26gt%3BDelete%20enough%20rows%20or%20columns%20to%20make%20room%20for%20what%20you%20want%20to%20insert%20and%20then%20try%20again%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomebody%20can%20you%20help%20me%3F%3C%2FP%3E%3CP%3ETna%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516745%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20insert%20new%20rows%20in%20a%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725954%22%20target%3D%22_blank%22%3E%40Maria1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDelete%20all%20rows%2Fcolumns%20below%20and%20to%20the%20right%20of%20your%20%22real%22%20work%20space.%20Save%20the%20workbook%20and%20re-open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%26nbsp%3Bwant%20to%20check%20things%20out%20before%20and%20after%20performing%20the%20above%20steps%2C%20you%20can%20click%20%22Workbook%20Statistics%22%20(MS365%20subscribers)%20on%20the%20Review%20ribbon%20(or%20in%20the%20bottom%20left%20corner%20of%20the%20Excel%20window).%20Check%20the%20%22End%20of%20sheet%22.%20You%20might%20see%20a%20reference%20to%20%26nbsp%3Bthe%20highest%20possible%20row%20(1048576)%20and%2For%20column%20(XFD).%26nbsp%3BAlternatively%2C%20press%20F5%2C%20Special...%2C%20Last%20cell.%20This%20will%20take%20you%20to%20what%20Excel%20sees%20as%20the%20last%20cell%20in%20your%20sheet.%20Do%20the%20same%20after%20deleting%20empty%20rows%20and%20columns%2C%20close%20and%20re-open%20and%20check%20what%20the%20end%20of%20sheet%20(last%20cell)%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516748%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20insert%20new%20rows%20in%20a%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516748%22%20slang%3D%22en-US%22%3EThe%20last%20row%20of%20your%20spreadsheet%20contains%20data.%20If%20Excel%20were%20to%20insert%20a%20row%20then%20you%20could%20lose%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EOr%2C%20maybe%20you%20selected%20an%20entire%20column%20when%20applying%20cell%20formatting%20or%20color%20and%20Excel%20simply%20thinks%20you've%20filled%20an%20entire%20column%20with%20information.%20In%20which%20case%2C%20you%20cannot%20just%20delete%20the%20cells%2C%20but%20you%20must%20clear%20the%20formatting%20also.%20If%20this%20is%20the%20case%2C%20select%20the%20cells%20that%20have%20formatting%2C%20but%20no%20actual%20data%20and%20click%20the%20%22Clear%20All%22%20button%20(on%20the%20Home%20tab%20under%20the%20Editing%20group%20to%20the%20far%20right).%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi everybody.

 

I can not insert a row in a page and excel shows me the next message

"Microsoft excel can not insert new cells because it would push nos empty cell off the end of the worksheet. These 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"

 

Somebody can you help me?

Tna 

2 Replies
Highlighted

@Maria1972 

Delete all rows/columns below and to the right of your "real" work space. Save the workbook and re-open.

 

If you want to check things out before and after performing the above steps, you can click "Workbook Statistics" (MS365 subscribers) on the Review ribbon (or in the bottom left corner of the Excel window). Check the "End of sheet". You might see a reference to  the highest possible row (1048576) and/or column (XFD). Alternatively, press F5, Special..., Last cell. This will take you to what Excel sees as the last cell in your sheet. Do the same after deleting empty rows and columns, close and re-open and check what the end of sheet (last cell) again.

 

 

 

 

The last row of your spreadsheet contains data. If Excel were to insert a row then you could lose data.

Or, maybe you selected an entire column when applying cell formatting or color and Excel simply thinks you've filled an entire column with information. In which case, you cannot just delete the cells, but you must clear the formatting also. If this is the case, select the cells that have formatting, but no actual data and click the "Clear All" button (on the Home tab under the Editing group to the far right).