Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 365 and Office Professional Plus 2013. If you don't see the Inquire tab in Excel, do the following 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

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

Important: You may want to make a backup copy of your file before cleaning the excess cell formatting, because there are certain cases where this process may make your file increase in size, and there is no way to undo the change.

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×