How to remove borders in Excel

You can watch a video tutorial here.

Excel provides many options for formatting worksheets. One of the options is to create or remove a border for cells or a table. When copying and pasting data within the sheet, by default the formatting also gets pasted. If the source cell has a border, the destination cell will have a border too. In this case, it may be required to remove the border from the cell.

Option 1 – Using the preset option 

Step 1 – Choose the button on the ribbon

  • Select the area for which the border has to be removed
  • On the Home menu, click the Borders button on the Font section
  • On the drop-down menu, select No Borders

Step 2 – Check the result

  • Check that the borders have been removed

Option 2 – Using the Format Cells option

Step 1 – Open the Format Cells window 

  • Select the area for which the border has to be removed
  • Open the Format Cells  window by right-clicking, to open the context menu, and selecting Format Cells
  • Alternatively, open the window using the menu Home > Cells > Format > Format Cells

Step 2 – Choose the borders to be removed

  • Go to the Border tab
  • Remove the borders by clicking the preview diagram or the border buttons

Step 3 – Check the result

  • Depending on the requirement, any or all of the borders can be removed