to prevent possible loss of data Excel connot shift nonblank cells off of the the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.
if you do not have data in cells that can be shifted off of the worksheet, you can reset which cells Excel considers nonblank. To do this,press CTR+END to locate the last nonblank cell on ther worksheet. Delete this c