Most Valuable Professional

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

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Styles in Excel > Creating Styles
Deze pagina in het Nederlands

Styles in Excel

Creating styles

A convenient method to create a new style is by selecting a cell which has all formatting options in place which you want to incorporate in the new style. Select the cell and choose Format, Style... from the menu (for Excel 2010 (2007, 2013): Click the Home tab, click the Cell Styles button in the Styles group).

Styles dialog

The Styles dialog screen.

To create a new style, simply type its name in the box "Style name". By default, all formatting elements are checked. Remove the checkmarks for the formatting elements you want to omit from the style you are creating (The dialog shown above has the Number and Alignment elements turned off).

Use the "Modify..." button to adjust the elements to your needs. Excel will show the standard "Format cells " dialog screen:

Format cells dialog screen

The format cells dialog screen, as shown after clicking Modify... on the Style dialog.

Note, that the elements in the Style dialog are identical to the tabs on the Format Cells dialog.

Note: As soon as you change a formatting element on a tab that was not selected on the Style dialog, Excel will automatically check that element for you; it will become part of that style.

In Excel 2003, after modifying all settings you have two options to "save" the modifications to the style:

The cells that already have this style applied will of course be updated regardless whether method 1 or 2 is used.

In short: If you want to modify a style and apply it to the current selection, click OK. Otherwise, click Add and then Close.

Excel 2010 (and 2013 and 2007) defaults to the second option: the style dialog will update/add the style, but the style will not be applied to the selected cells.



All comments about this page:

Comment by: Mark Allen (19-11-2009 20:00:40)

When using linear programming how can you shade in the feasible region that conatains a diagonal line through certain cells.

Thank You
Mark Allen


Comment by: Jan Karel Pieterse (20-11-2009 04:08:21)

Hi Mark,

Do you mean you want a diagonal line to appear based on some condition?


Comment by: Ren Leng Ren (23-6-2017 03:43:54)

Good for me


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:

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

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

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.