How To Instantly Clear Rules From Entire Sheet In Excel 2010

Advertisement

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.

745d1276195437-how-instantly-clear-rules-entire-sheet-

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

Advertisement
  • Taz

    wow Thanks! this was simple..

  • Will corman

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