How To Instantly Clear Rules From Entire Sheet In Excel 2010

If your Excel 2010 spreadsheet contains a lot of conditional formatting rules, it may look a bit untidy. Excel offers a simple way to remove all the rules applied over the sheet. This post covers how to remove rules with a single click.

Head over to Home tab, under Conditional Formatting options, from Clear Rules sub-menu, click Clear Rules from Entire Sheet.

745d1276195437howinstantlyclearrulesentiresheet How To Instantly Clear Rules From Entire Sheet In Excel 2010View in gallery

This will clear all the rules that you’ve applied over the sheet.

  • Taz

    wow Thanks! this was simple..

  • Will corman

    how do i clear the conditional formatting from the entire workbook and not just one sheet.