Clean excess cell formatting on a worksheet

 Important    This feature isn’t available in Office on a Windows RT PC. Inquire is only available in the Office Professional Plus and Office 365 Professional Plus editions. Read Excel 2010 workbooks with Power Pivot don't work in some versions of Excel 2013. Want to see what version of Office you're using?

Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't being used (especially entire rows and columns) can cause your workbook's file size to grow quickly. This can slow down not just Excel, but the overall performance of your computer when you have an excessively formatted worksheet open. Excessive formatting can also cause printing problems in Excel.

Use the Clean Excess Cell Formatting command, available on Excel's Inquire tab in Microsoft Office Professional Plus 2013. To see the Inquire tab in Excel, you need to enable the Inquire add-in:

  1. Click File > Options > Add-Ins.
  2. Make sure COM Add-ins is selected in the Manage box, and click Go.

Manage COM Add-ins

  1. In the COM Add-Ins box, check Inquire, and then click OK.
    The Inquire tab should now be visible in the ribbon.

To remove the excess formatting in the current worksheet, do the following:

  1. On the Inquire tab, click Clean Excess Cell Formatting.

    Clean Excess Cell Formatting
  2. Choose whether to clean only the active worksheet or all worksheets. After excess formatting has been cleared, click Yes to save changes to the sheets or No to cancel.

How cleaning affects conditional formatting

Cleaning excess formatting works by removing cells from the worksheet that are beyond the last cell that isn't blank For example, if you apply conditional formatting to an entire row, but your data goes out only to column V, the conditional formatting may be removed from columns beyond column V.

To learn more about how to fix other problems caused by excessive formatting , see the Microsoft Support article How to reset the last cell in Excel.

Applies to:
Excel 2013, Office 365 Enterprise, Office 365 Enterprise admin, Office 365 Midsize Business, Office 365 Midsize Business admin