How to Delete a Border Line in Excel: Quick Steps and Fixes

How-to basics · Updated November 20, 2026

To delete a border line in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home > Borders ▼ > No Border to remove every cell border in the selection. To erase just one edge, open Format Cells and turn off that edge in the Border tab. If the line remains, it may be a gridline, conditional-formatting border, or shape rather than a regular cell border.

Removing a border changes the cells’ formatting, not their contents, formulas, or values. Before you start, decide whether you want to clear all borders from the selected cells or remove only a particular side. That distinction matters: No Border clears every border on the selection, while the Format Cells dialog lets you target individual edges.

What You’ll Need

  • A workbook open in Microsoft Excel. These directions use Excel for Microsoft 365 on Windows; the ribbon labels are similar in Excel for Mac and Excel for the web, with differences noted below.
  • The cell, range, or worksheet area where the line appears. If you are unsure which cells have the border, click a cell near the line and inspect its edges before making a larger selection.
  • Optional: a saved copy of the workbook if you are making broad formatting changes. Removing borders is usually reversible with Undo, but a copy is useful when changing a complex template or shared report.

Step-by-Step

  1. Select the cells with the border. Click one cell to work on just that cell, or drag across the range you want to change. To select a whole worksheet, click the Select All triangle at the top-left corner between the row numbers and column letters. You can also click a row number or column letter to select the entire row or column. Check the selection carefully: applying No Border to a large range can remove intentional borders as well as the line you meant to clear.
  2. Open the Borders menu. On the Home tab, find the Font group and click the small arrow beside the Borders button. The button’s icon may display the most recently used border, so use its dropdown arrow rather than simply clicking the main button. The dropdown contains border choices and the command needed to clear them.
  3. Choose No Border to remove all borders from the selection. In the Borders menu, click No Border. Excel clears the cell borders applied to the selected cells, including outside edges and interior lines. This does not delete text, numbers, formulas, fill colors, or the worksheet’s gridline setting. Click an empty cell or another part of the sheet to see the result without the selection highlighting.
  4. Remove only one border edge when needed. If you need to keep the other sides, select the affected cells and open the Format Cells dialog. On Windows, press Ctrl+1, choose the Border tab, and inspect the preview in the middle of the dialog. Click the particular edge shown in the preview to switch it off; click it again only if you need to restore it. Use the preview to remove a top, bottom, left, right, or diagonal line without clearing the remaining borders. Click OK to apply the change. On Mac, Command+1 opens Format Cells; the dialog’s Border tab provides the same kind of edge controls.
  5. Check each cell when the border crosses a range. A line between two cells can be the right border of the cell on the left, the left border of the cell on the right, or both. If removing one edge leaves a line, select the adjacent cell or the full relevant range and inspect its border settings too. For example, a vertical divider between columns B and C may be assigned to either side of the boundary, so checking both columns can be necessary.
  6. Confirm that the line is actually gone. Click outside the selected range and look at the cells again. If the line disappears only while a cell is selected, it may have been the active-cell outline rather than a border. If it is still visible, identify whether it is a gridline, conditional-formatting effect, table style, or drawn object before repeating the border command.
  7. Use Excel for the web or Mac as appropriate. In Excel for the web, select the cells, open the Borders menu on the Home tab, and choose No Border; available Format Cells options can differ from the desktop dialog. In Excel for Mac, the Home tab’s Borders menu also includes No Border, and Command+1 opens Format Cells for finer control. If your ribbon is collapsed or narrow, expand the Home tab or use the search box for the Borders command rather than guessing at an icon.

Common Mistakes

Choosing the wrong border command: The Borders menu includes commands that add a bottom, top, outside, or other border. Clicking one of these can change the line instead of removing it. Choose No Border when clearing every edge, or use the Border tab in Format Cells to switch off a single edge.

Selecting too many cells: A whole-sheet selection is convenient when every cell should have its borders cleared, but it can also erase carefully formatted report sections. Select the smallest range that covers the unwanted line. If you already applied the command to too many cells, press Ctrl+Z on Windows or Command+Z on Mac right away, then make a narrower selection.

Confusing gridlines with borders: Excel’s light worksheet gridlines are a viewing aid and are not cell borders. No Border will not hide them. Conversely, turning off gridlines hides them across the worksheet but does not remove borders that will remain in print or when gridlines are shown again.

Assuming formatting is only one type: A line may be produced by a conditional-formatting rule or a table style. Clearing ordinary borders does not necessarily remove formatting that Excel reapplies automatically. Check those sources if the line returns after editing a cell or refreshing the display.

Tips

When a border is needed on most of a table but not at one edge, use Format Cells rather than clearing the whole selection and rebuilding the design. This is especially helpful for a header row with a bottom rule, a total row with a top rule, or a section divider where the other cell edges should stay in place. Take a moment to check the preview before clicking OK; it shows which sides are currently set for the selected cells.

For a quick visual check, temporarily turn worksheet gridlines off using View > Gridlines. If the dark line remains, it is probably a border or another formatting object; if the pale cell grid disappears, you were looking at gridlines. Turn the setting back on afterward if you still want gridlines visible while working. This is a display choice, not a way to delete borders.

If you are cleaning a workbook for printing, inspect it in File > Print or Print Preview after removing the border. Gridline printing is controlled separately from cell borders: on the Page Layout tab, the Sheet Options area has Gridlines settings for View and Print. A border can print even when worksheet gridlines are not set to print, so check the actual preview rather than relying only on the normal worksheet view.

Use Undo immediately if the result is broader than intended. Formatting changes can usually be undone with Ctrl+Z on Windows or Command+Z on Mac. If the workbook has been closed or the undo history is no longer available, you may need to reapply the intended borders manually or restore a saved version. For shared workbooks, confirm that you have permission to edit the cells and that another user is not changing the formatting at the same time.

Troubleshooting

The line is still visible after No Border. First click outside the selection so the active-cell outline is no longer mistaken for a border. Then toggle View > Gridlines off and on to see whether the line is a worksheet gridline. If it stays visible with gridlines off, check the Format Cells Border tab for the neighboring cells, as a shared-looking divider may be set on either side.

The line returns after I edit a cell. A conditional-formatting rule may be applying a border based on a value or formula. Select the affected cells and go to Home > Conditional Formatting > Manage Rules. In the rules manager, set the display to show rules for the current selection or worksheet, inspect relevant rules, and edit or delete the rule that applies the border. Be cautious about deleting a rule: it may also control fill color, font, or other formatting you want to keep. Use Edit Rule and Format when you only need to remove its border formatting.

The line appears only inside a formatted table. Click in the table and inspect the Table Design tab and its Table Styles. A style can draw lines or emphasize rows and columns independently of ordinary cell borders. Try another style or adjust the relevant table style options. If you convert the table to a normal range, table-specific behavior stops, but this can also remove table features such as filters and structured references, so do not convert it solely as a first troubleshooting step.

The line can be selected or moved. It may be a shape or drawing object placed over the cells rather than a cell border. Click the line itself; if selection handles appear, press Delete to remove that object. If clicking selects a cell instead, use Home > Find & Select > Selection Pane to locate and select objects on the worksheet. Check that the object is the unwanted line before deleting it, especially if the sheet contains charts, logos, or other drawings.

The command is unavailable or the formatting will not change. The worksheet may be protected, or the workbook may open in a restricted editing state. Check the Review tab for Unprotect Sheet; you may need the password or permission from the workbook owner. Also check whether the cell is part of a merged range or a table, because the selected area and available formatting controls can behave differently. Select the full merged area or the relevant table cells and try again if editing is allowed.

Frequently Asked Questions

How do I remove just the bottom border in Excel?
Select the cell or range, press Ctrl+1 on Windows or Command+1 on Mac, and open the Border tab. Click the bottom edge in the preview to turn it off, then click OK. If the line remains, inspect the adjacent row for a top border.

Does No Border delete the text or formulas?
No. It changes border formatting only. Cell contents, formulas, number formats, and fill colors remain in place. To remove only one edge while preserving other borders, use the Border tab in Format Cells instead of No Border.

Why do I still see lines after removing borders?
They may be worksheet gridlines, an active-cell outline, conditional formatting, a table style, or a drawn line. Turn gridlines off temporarily, click outside the selection, and check conditional-formatting rules and objects if the line remains.

Can I remove borders from an entire sheet?
Yes. Click the Select All triangle at the top-left of the worksheet, then choose Home > Borders > No Border. This clears cell borders across the sheet, so use it only when you intend to remove all of them, not just the lines in one table.

Will removing a border change how the worksheet prints?
Removing a cell border can change the printed appearance. Worksheet gridlines have separate View and Print settings on the Page Layout tab, so a line that appears on screen may not print, and a border may print even when gridlines are not set to print. Check File > Print before sharing or printing the workbook.

Can I restore a border after removing it?
Use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Otherwise, select the cells and add the intended edge again from the Borders menu or the Format Cells Border tab. If you are unsure what the original formatting was, compare with an unchanged neighboring cell or restore a saved copy.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.