to prevent possible loss of data,mocrosoft office excel cannot shift nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing CTRL+END, and delete or dear all in cell between the last cell and the end of your data . then select cell a1 and save your workbook to reset ithe last cell used.
Or,you can move the data to a new location and try again