1. Home
  2. MS Office

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.


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


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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.