How to remove cell 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 cells for which the borders have to be removed
  • Go to Home > Font
  • Expand the Borders dropdown
  • Select No Borders

Step 2 – Check the result

  • The borders are removed from the cells

Option 2 – Use the Format Cells option

Step 1 – Open the Format Cells window

  • Right-click and select Format Cells  from the context menu


Go to Home > Number  and click on the arrow to expand the menu


Go to Home > Cells > Format > Format Cells


Press Ctrl+1

Step 2 – Choose the borders to be removed

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

Step 3 – Check the result

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