Apply or remove cell borders

Excel 365 2013 2010 2007 2003
Exist several ways to apply or remove cell borders; you can choose anyone:

To apply cell borders:

   1.    On the Home tab, in the Font group, click the arrow next to Borders:

Font group in Excel 2016

Then choose a border style from the palette:

Border style list in Excel 2016

Click Line Color Line Color and then click the color that you want to use. Click the arrow next to Line Style Line Style and choose the style that you want to use:

Line Style list in Excel 2016

If you want to use another style of borders, choose the More Borders... button to open the Format Cells dialog box:

Format Cells in Excel 2016

Click the line style and color that you want, and then click one or more buttons to indicate the border placement.

   2.    Choose Format Cells... from the popup menu to open the Format Cells dialog box:

Cell popup in Excel 2016

Click the line style and color that you want, and then click one or more buttons to indicate the border placement.

Note: You also can use the next shortcut keys:

Alt+P   Apply or remove the top border.

Alt+B   Apply or remove the bottom border.

Alt+L   Apply or remove the left border.

Alt+R   Apply or remove the right border.

Alt+H   If cells in multiple rows are selected, apply or remove the horizontal divider.

Alt+V   If cells in multiple columns are selected, apply or remove the vertical divider.

Alt+D   Apply or remove the downward diagonal border.

Alt+U   Apply or remove the upward diagonal border.

To remove cell borders:

   1.    On the Home tab, in the Font group, click the arrow next to Borders and choose Erase Border Erase Border and then do one of the following:

  • To remove a single border, click that border with the eraser tool.
  • To remove more than one border, drag the eraser tool across the borders that you want to remove.

To stop erasing borders, click Erase Border on the Borders toolbar again, so that the eraser tool is no longer displayed.

   2.    Choose Format Cells... from the popup menu to open the Format Cells dialog box. Click one or more buttons to unselect the border placement.

Note: You also can use the next shortcut keys:

  Ctrl+Shift+_    Border lines off

  Ctrl+Shift+&    Border lines on

See also this tip in French: Appliquer ou supprimer des bordures de cellules.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.