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...
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).
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).