Could be Formatting, Conditional Formatting or you might have inadvertently copied a formula down.

In each sheet, select the entire row after all the data. Press Shift End Down Arrow to select ALL the rows below the data and use the Delete Icon on the ribbon to delete them. Do the same with rows to the right of the real data.

Save, Close and Re-open the workbook ... you might want to check the file size in Windows Explorer first.


Regards, TMS