Excel provides different ways to add, change, and remove cell borders. Some border formatting options take only a single click.
Apply a predefined cell border
On a sheet, select the cell or range of cells where you want to add or change the borders.
On the Home tab, in the Font group, select the arrow next to Border
, and then select the cell border that you want to apply.Tip
To add or remove parts of a border, select More Borders at the bottom of the menu. Under Border, select the borders that you want to add or remove.
Remove all cell borders
- Select the cell or range of cells where you want to remove the borders.
- On the Home tab, in the Font group, select the arrow next to Border
, and then select No Border.
Create a custom border
Use cell styles to create a custom border that you can easily apply over and over again.
On the Home tab, in the Styles group, select Cell Styles, and then select New Cell Style.
In the Style name box, type a name for your new cell style.
Select Format.
Do any of the following:
To Do this Choose a custom border line style On the Border tab, under Line Style, select the line style that you want to apply. Under Border, select the specific pieces of the cell border to apply the line style to. Choose a custom border line color On the Border tab, under Line Color, select the color that you want to apply. Under Border, select the specific pieces of the cell border to apply the color to. Select OK to confirm the format of your new style.
Select OK to save your new style.
Tip
To apply your new cell style, select the cells that you want to change. Then, on the Home tab, select Cell Styles, and select the style.
See also
Show or hide gridlines on a worksheet
Highlight patterns and trends with conditional formatting in Excel for Mac