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.

Trainings

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

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
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.


 


Comments

All comments about this page:


Comment by: Mark Allen (11/19/2009 8:00:40 PM)

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 (11/20/2009 4:08:21 AM)

Hi Mark,

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

 


Comment by: Ren Leng Ren (6/23/2017 3:43:54 AM)

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: 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].