Create and apply a border cell style

If you frequently use a specific border style in your workbook, you can create a custom border style button and use it to apply the custom border style quickly.

  1. Click Home > Cell Styles.

    Notes: If you don't see Cell Style, click the Morearrow in the cell style gallery.

    More button in the Style gallery

  2. Pick New Cell Style.

    New cell style option
  3. In the Style name box, type a name for the new border style.

  4. Click Format.

  5. Click Border and pick a line style.

  6. To change the line color, click color box, and pick a color.

    Format cell style

  7. Click one of the Presets or to customize borders for specific cell sides, under Border click the individual border buttons.

    Note: To undo a border, click the border button again.

  8. You can preview the border style in the Border diagram. If the border style meets your needs, click OK.

  9. Click OK to close the Style box.

    Your custom cell style button appears in the gallery. Like the FancyBorderStyle button in this picture.

    Cell Style gallery

Apply or remove a custom border style

After you create a border cell style, here's how you can use it:

  • To apply the custom border style, select the cells that you want to add borders to, and then click your custom cell style button.

  • To remove a custom border style, select the cells with the border and click Normal.

Change formatting for a custom border cell style

Here's how you can modify the custom border cell style in a workbook:

Note: Changing a cell style affects all cells that have that style in the workbook.

  1. Right-click the cell style button and pick Modify.

    modifying a cell style

  2. Click Format and make any format changes.

More on cell borders

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×