Subscribe in a readerStyles in Excel
How styles work
A style is just a set of cell formatting settings which has been given a name. All cells to which a style has been applied look the same formatting-wise. When you change a part of a style, all cells to which that style has been applied change their formatting accordingly.
Use of styles takes some getting accustomed to, but may bring you great advantage. Imagine showing your nicely formatted sheet to your boss. Then your boss asks you if you could please change all input cells to having a light-yellow background fill, instead of a dark yellow one. For a large model, this may imply a huge amount of work. Would you have used styles, then it would have been a matter of seconds.
Styles are in fact an addition. Cell formatting is the sum of the applied style and all modifications to individual formatting elements on top of that style. What parts of the formatting options are included in a style is determined during the definition of the style (See screenshot below).
Access the style dialog by choosing Format, Style... from Excel 97-2003's menu:
Excel 97-2003: Styles can be accessed from the Format menu
In Excel 2007 you may access the style dialog from the Home Tab, Styles group, Cell Styles button:
Excel 2007/2010: Styles are accessed from the Home tab, Styles group
The following dialog comes up in Excel 2003 when you click the style... button:
The Styles dialog screen for Excel 97-2003
Excel 2007/2010 enable you to access the styles by clicking the dropdown next to the styles gallery. Excel 2007 and 2010 has a slightly different screen to create a new style however (if you click the New Style option in the style gallery):
Style dialog for Excel 2007/2010
When you apply a style to a cell followed by another style, the end result will be an addition of the selected parts of both styles. What the end result of such an addition of styles will be, depends on which elements of both styles have been selected as being part of the style (this will be discussed later). Theoretically, this would have enabled us to use cascading styles, but unfortunately Excel does not keep a record of the order of applied styles. Only the last style is remembered. Also, styles can not be derived from other styles whilst maintaining a link to the parent style. Changes to the "original" style are not reflected in the "child" styles.
Comments
All comments about this page:
Comment by: Mahmood Anwar (3/7/2010 9:08:30 PM)I had 88 data and I applied style # 11. After that I added more clients and data. Now I want to combine both so that I can sort them. It does not allow me to delete the first syle and restyle or merge the top one to the bottom no style data. Thanks,
Comment by: Jan Karel Pieterse (3/7/2010 11:20:27 PM)Hi Mahmood,
Are you sure the new lines have become part of your table?
You can try by converting the table to a range and then converting the range back to a table.
Comment by: arun (7/14/2010 4:10:26 PM)I am working styles in excel.Some styles are getting added to the work book like 20%-Accent1,20%-Accent2.
I never added these styles in my work book.Is there any way we can check unused styles.So i can remove the styles.
Comment by: Jan Karel Pieterse (7/15/2010 4:56:47 AM)Hi Uran,
Those Accent styles are built-in styles as of Excel 2007, My guess is you cannot remove them.
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.