Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Speed up your file

FastExcel
The best tool to optimise your Excel model!
Home > English site > Articles > Styles in Excel > Deviate from a style
Deze pagina in het Nederlands

Styles in Excel

Deviate from a style

If you have applied a style to a set of cells and you change a formatting element of one of those cells, then modifications to that particular element of the style will no longer be applied to the modified cell.

So after changing a font attribute (like Bold) of a cell, changing the font attributes of the style will update all cells, except the one you just modified:

Series of cells with one style, 1 cell deviates from that style.

Series of cells with one style, 1 cell deviates from that style.

You can restore the style to a deviating cell by selecting the cell and choosing the style from the style dropdown and clicking "No" on the subsequent question Excel 97 - 2003 will ask you (See below) . Note that Excel 2010 (and 2013 and 2007) never asks you this question and performs the same action as when you click "No" . See the previous page to find out what clicking Yes or no causes Excel to do.

Confirm to Excel how it must apply the style

Confirm to Excel how it must apply the style


 


Comments

All comments about this page:


Comment by: Jan Woellhaf (3/7/2013 1:28:03 AM)

Re: Deviate from a style.

I spent several hours trying to discover why some cells changed when I changed their style and others didn't. Wish I'd encountered your comment sooner! Excellent site. Thanks.

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].