1. Home
  2. MS Office
  3. How to instantly clear rules from entire sheet in excel 2010

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.

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

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

2 Comments

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