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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×