Clear Formatting in Excel

[Josh Doten]

Where is the Clear Formatting button located at in Excel? It doesn't appear
to be visible on the Home Ribbon like it is in Word.

 

[Mike H]

Hi,

Maybe your looking for:-

Home Tab|Styles|Conditional formatting|Clear rules
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Jacob Skaria]

Check out this link for help on 2003 to 2007

http://office.microsoft.com/assista...t=788&type=flash&CTT=11&Origin=HA101491511033

 

[Diabolo_Devil]

Try:

Home Tab > Editing Section (Far Right) > Clear > Clear Formats

 

[Gord Dibben]

Home Tab>Editing section>Lower left Icon dropdown>Clear Formats

If you want the Icon on the QAT go to Button>Excel Options>Customize>Choose
Commands from>Home Tab.

Scroll down to Clear Formats and add to QAT


Gord Dibben MS Excel MVP