Subscribe in a readerStyles 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 2007: Click the Home tab, click the Cell Styles button in the Styles group).
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:
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:
- By clicking "OK"; The currently selected (or added) style will be modified/created and the currently selected cells will have that style applied.
- By clicking "Add" and subsequently clicking Close: The style will be updated/added, but not applied to the current selection.
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 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?
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.