How to reset the last cell in Excel (XSFormatCleaner)

This is basically a copy of the Microsoft support pages here and here.

Microsoft Excel saves only the part of each worksheet that is in use, meaning the section that contains data or formatting. Sometimes the last cell of a worksheet may be beyond the range of your actual used data. This issue may cause you to have a larger file size than neccesary, you may print extra pages, you may receive "Out of Memory" error messages, or you may experience other unusual behavior. Clearing the excess rows and columns to reset the last cell can help to resolve these issues.

Note You can locate the last cell of the active worksheet by pressing CTRL+SHIFT+END.

The primary reason of including this here is the fact that not reseting the last cell can slow down Spreadsheet Compare and result in Excel becoming unresponsive.

The Add-In can be downloaded from the sites above, or here: XSFormatCleaner.xla. Place the xla file in the XLSTART folder of Excel (i.e. C:\Program Files\Microsoft Office\Office12\XLSTART).