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

OR

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

OR

Go to Home > Cells > Format > Format Cells

OR

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