Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Remove Formatting in Excel 2013

This video explains how to clear formatting in Excel.

Editing files can be complicated if a previous user has added formatting such as highlighted cells, filters, or font changes. To clear formatting, highlight the row, column or range of cells you want to change and go to the Home tab. In the Editing group, click on Clear and then select Clear Formats from the dropdown menu.