Skip to main content

Using Cell Styles for Easier Formatting

Cell styles combine a number of different formatting aspects that can include number format, text alignment, font and font size, borders, fills, and protection status. Named cell styles make it easy to apply a set of predefined formatting options to a cell or range.

Applying styles

  1. Select a cell or range that you want to apply styles.
  2. Choose Home > Styles > Cell Styles.
  3. Move your mouse over the style choices, the selected cell or range temporarily displays the style. When you see a style you like, click it to apply the style to the selection.
    Applying styles

Creating new styles

You can create a custom cell style to quickly format your worksheet:

  1. Select a cell, and apply all the formatting that you want to include in the new style.
  2. Choose Home > Styles > Cell Styles > New Cell Style.
  3. Excel displays a Style dialog based on the current cell format, along with a suggested name for that style.
  4. Enter a new style name in the Style Name field.
  5. (Optional) If you don't want the style to include one or more format categories, remove the check.
  6. Click OK to create the style and to close the dialog box.
  7. The new custom style is available when you choose Home > Styles > Cell Styles.

Modifying an existing style

By default, all cells use the Normal style. If you modify the Normal style, all cells that haven't been assigned a different style will reflect the new formatting.

Here is a quick example of how you can use cell styles to change the default font style used in the current workbook:

  1. Choose Home > Styles > Cell Styles. Excels displays the list of styles for the active workbook.
  2. Right-click Normal and choose Modify. Excel opens the Style dialog box, with the current settings for the Normal style.
  3. Click the Format button. Excel displays the Format Cells dialog box.
  4. Click the Font tab, and choose the font and size that you want as the default.
  5. Click OK to return to the Style dialog box. Notice that the Font item displays the font choice you made.
  6. Click OK again to close the Style dialog box.
  7. The font for all cells that use the Normal style changes to the font that you specified.

Merging styles from other workbooks

Custom styles are available only in the workbook in which they were created. If you want to use it in another workbook, you can merge these styles from the workbook you created before.

  1. Open the workbook that contains the styles that you want to merge.
  2. Open a new workbook or an existing workbook, then choose Home > Styles > Cell Styles > Merge Styles.
  3. Excel displays the Merge Styles dialog box that shows a list of all open workbooks.
  4. Select the workbook that contains the styles you want to merge and click OK.
  5. Excel copies custom styles from the workbook that you selected into the active workbook.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>