ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Clear Formatting in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/259029-clear-formatting-excel.html)

Josh Doten[_2_]

Clear Formatting in Excel
 
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

Clear Formatting in Excel
 
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.


"Josh Doten" wrote:

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.


Jacob Skaria

Clear Formatting in Excel
 
Check out this link for help on 2003 to 2007

http://office.microsoft.com/assistan...HA101491511033

--
Jacob


"Josh Doten" wrote:

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.


Diabolo_Devil[_2_]

Clear Formatting in Excel
 
Try:

Home Tab Editing Section (Far Right) Clear Clear Formats

---------------

"Josh Doten" wrote:

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.


Gord Dibben

Clear Formatting in Excel
 
Home TabEditing sectionLower left Icon dropdownClear Formats

If you want the Icon on the QAT go to ButtonExcel OptionsCustomizeChoose
Commands fromHome Tab.

Scroll down to Clear Formats and add to QAT


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 07:11:02 -0700, Josh Doten
wrote:

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.




All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com