Clear Formatting in Excel

J

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.
 
M

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.
 
G

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
 
Top