Forum Discussion
Can not insert new rows in a page
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. Th...
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.