Select all rows below of the last row in your spreadsheet. F:IV > Home tab > Editing group > Click "Clear all". Or simply type F5 > type the reference range, e.g. Select all columns to the right of the last column in your spreadsheet.
From the Inquire tab, you can analyze a workbook, see relationships between cells, worksheets, and other workbooks, and clean excess formatting from a worksheet. Excel's Inquire add-in In addition to the comparison features of Spreadsheet Compare, Excel 2013 has an Inquire add-in you can turn on that makes an "Inquire" tab available. Once editing is activated, enter the text you want to add or review the existing comment to make changes to it. Open the Review Tab and click the Edit Comment command under the commenting tools.
In the Within box, select either Workbook to search in all tabs or Sheet to look in the current worksheet only. This way, you will search for all possible Excel file formats including.