Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

  1. Select the cells or range of cells to add borders.

  2. On the Home tab, select Borders button icon Borders, and choose from the following: 

    • Select a predefined border such as All borders button All borders. 

    • Select Draw border button Draw Border or  Draw border grid button Draw Border Grid and drag your cursor to add borders.

    • Select All borders button More Borders to create custom borders.

    • To erase all or some borders, select  Erase border button Erase Border and drag the cursor over the areas to erase.

    • Choose Line color button Line Color or Line Style to change line color or line type and thickness. 

For more info, see Apply or remove cell borders on a worksheet.

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center