To delete borders in Excel without removing cell contents, select the cells, then choose Home > Borders ▼ > No Border in the Font group. This removes the cell-border formatting from the selection; it does not delete values, formulas, fills, or the worksheet gridlines. Save a copy first if you are working in a shared or important workbook, especially before changing a large range.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The cells, rows, columns, or range whose borders you want to remove. If you are unsure which cells have borders, select the area and inspect the Borders menu before applying a change.
- Permission to edit the worksheet. A protected sheet may prevent border changes until it is unprotected.
Step-by-Step
- Select the cells with the unwanted borders. Click one cell to remove its borders, or drag across a range to select multiple cells. To select a whole column or row, click its letter or row number. To select the entire worksheet, click the small triangle at the top-left corner where the row and column headings meet. A broad selection is convenient, but verify it carefully because the command applies to every selected cell.
- Open the Borders menu. On the ribbon, select the Home tab. In the Font group, locate the Borders button, which usually shows a small square grid. Click the arrow beside the button, not just the main button. The arrow opens the list of border options; clicking the button itself may repeat the most recently used border command instead.
- Choose No Border. Select No Border from the menu. Excel removes the borders applied to the selected cells. The contents stay in place, and other formatting such as font, number format, alignment, and cell fill remains. If you only wanted to change one side of a border, use a specific edge option instead of No Border.
- Check the result at the edges of the selection. Click outside the selected range or select a different cell to see the change clearly. If a border appears to remain, zoom in or check whether it belongs to an adjacent cell, conditional formatting, a table style, or a drawn line rather than the cell border you just removed. The troubleshooting section explains how to identify those cases.
- Undo promptly if the wrong area changed. Press Ctrl+Z on Windows immediately after an unintended change. This restores the previous border formatting, provided you have not performed actions that prevent the undo. For Mac, use Command+Z. If you have already made later edits, inspect the affected cells and apply the needed border formatting again rather than repeatedly undoing unrelated work.
- Save the workbook. Press Ctrl+S on Windows or Command+S on Mac. If the workbook is shared, confirm that the saved changes are the ones you intended. For a workbook that needs to retain the original appearance, use Save As to make a separate copy before cleaning up borders.
These ribbon steps also apply in Excel for Mac, although the ribbon layout and menu appearance can differ slightly. Select the cells, open the border options on the Home tab, and choose No Border. In Excel for the web, use the Home tab and its Borders menu; some commands may be arranged differently depending on the window width. If the ribbon is collapsed, expand it or use the search box to locate border commands.
Common Mistakes
- Confusing gridlines with borders. Gridlines are the faint worksheet guides that help show cell boundaries; they are not the same as borders applied with the Borders menu. Choosing No Border will not remove gridlines. If you want a blank-looking sheet, use View > Gridlines to hide gridlines on screen. To control printed gridlines, use the Page Layout tab and the Gridlines options under Sheet Options. These settings affect the worksheet view or printout, not cell-border formatting.
- Selecting too much or too little. No Border acts on the entire selection. If you select a whole worksheet, it can remove intentional borders from a carefully formatted report. If only one cell is selected, borders on neighboring cells are not necessarily removed. Select the exact range, then check the boundary cells, which are the ones most likely to show an unexpected remaining line.
- Using Clear Formats instead. The command Home > Clear > Clear Formats removes much more than borders. It can also remove number formats, font choices, fills, and other formatting. Use it only when you really want to reset the selected cells’ formatting. No Border is the targeted choice when the goal is to keep the rest of the appearance.
- Expecting No Border to remove a line drawn over the cells. A line may be a shape or drawing object placed on the worksheet, not a cell border. Clicking the line may select its handles. If so, select the object and press Delete, taking care not to delete nearby content. If it is hard to select, use Home > Find & Select > Selection Pane to locate and select objects.
- Ignoring special formatting sources. A conditional-formatting rule or an Excel table style can display borders even after you remove ordinary cell borders. Reapplying No Border repeatedly will not necessarily change a border supplied by those features. Check the rule or table design settings instead of treating the line as a standard border.
Tips
- Remove only selected edges when possible. The Borders menu includes options for individual sides, such as top, bottom, left, and right borders. If the goal is to remove a line between two parts of a layout, identify which cell edge creates it and change that edge rather than clearing every border in the range.
- Use Format Cells for a more visual check. Select the cells, open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac, and choose the Border tab. The preview shows the current border arrangement. Click the relevant edge buttons to turn them off, or choose the no-border setting, then select OK. This can be easier than guessing which edge option is active in the ribbon menu.
- Inspect merged cells carefully. A merged range behaves as a single cell for many formatting actions. Select the merged area itself before removing its border. If the line is at the outside edge of the merged range, removing only an interior edge may not affect it. Avoid unmerging solely to remove a border unless you also want to change the worksheet structure.
- Use the selection tools for scattered cells. Hold Ctrl on Windows while clicking separate cells or ranges to add them to a selection, then apply No Border once. On Mac, use Command while selecting separate areas. Make sure each selected area is intentional; a mistaken multi-range selection can make it harder to see exactly where the command will apply.
- Keep a clean source copy for repeatable reports. If you regularly receive a formatted workbook and need a border-free version, save a copy before making changes. This gives you a straightforward way to compare the original and edited sheets without relying on a long undo history.
Troubleshooting
The border is still visible after choosing No Border. First check whether you are seeing gridlines. Toggle View > Gridlines off temporarily; if the faint line disappears, it was a gridline, not a cell border. If it remains, select the cell or range on both sides of the line and check the Borders menu. Borders belong to cell edges, so a visible boundary may be applied from a neighboring cell that was outside your original selection.
A border comes back as soon as you edit a cell. A conditional-formatting rule may be applying it based on the cell’s value or another condition. Select a cell showing the line and go to Home > Conditional Formatting > Manage Rules. In the rules manager, choose the appropriate option in the Show formatting rules for list, such as This Worksheet, and inspect rules that apply to the cell. Edit or remove the relevant rule only if you are sure it is responsible; a rule may also control colors or fonts that you want to keep.
The line is part of an Excel table. Click inside the table and look for the Table Design tab. Table styles can supply visual formatting, including edge treatments. Try a different table style or adjust the available table style options. If you need the data to remain a table, avoid converting it to a range just to hide a border, because conversion removes table behavior such as filter controls and structured references.
The Borders menu is unavailable or the command has no effect. The worksheet may be protected. Check Review > Unprotect Sheet; if prompted, you may need the password set by the workbook owner. If the sheet is shared or controlled by an organization, ask the owner for permission rather than trying to bypass protection. In a workbook opened as read-only, save an editable copy if you are authorized to make changes.
You cannot select the cell that seems to contain the line. The object may be a shape, picture, chart edge, or another drawing element. Try clicking the line itself and look for object handles. You can also open Home > Find & Select > Selection Pane, select a listed object, and delete it if appropriate. If the line is part of a chart, select the chart and change its formatting through the chart tools rather than using the cell Borders menu.
Frequently Asked Questions
Will deleting a border delete the cell’s value or formula?
No. Choosing No Border changes the selected cells’ border formatting only. Values, formulas, and other formatting remain. Be careful not to choose Delete or Clear Contents when your goal is only to remove a border.
How do I remove borders from an entire worksheet?
Click the Select All triangle at the top-left of the worksheet grid, then choose Home > Borders > No Border. This removes cell borders across the sheet, including borders you may want to keep in a report. Consider selecting only the used range or making a copy first.
Can I remove just the bottom border?
Yes. Select the relevant cells, open the Borders menu, and choose the option that removes the bottom edge. If the line remains, check the adjacent row because its top border can create a similar-looking boundary. The Format Cells dialog preview can help you identify the edge that is still applied.
Why do I still see cell lines after removing all borders?
They are probably worksheet gridlines. Hide them with View > Gridlines. Gridline visibility is a sheet display setting, while borders are formatting stored on cells. Gridlines may also be treated separately for printing in the Page Layout sheet options.
Can I remove borders in Excel for the web or on Mac?
Yes. In Excel for the web, select the cells, open the Borders menu on the Home tab, and choose No Border. On Mac, use the same Home-tab border menu; the ribbon arrangement may differ. The Windows shortcut keys for ribbon commands may not apply on Mac, so using the menu is the clearest route.
Can I recover a border after saving?
If the workbook is still open and the action is in the undo history, use Ctrl+Z on Windows or Command+Z on Mac. After closing the workbook, undo history may no longer be available. If you saved a separate original copy, reopen it or copy the needed formatting from it; otherwise, reapply the border from the Borders menu or Format Cells dialog.
Related
- Copy Just the Fill Color in Excel Without Other Formatting
- Copy Only Filtered Data in Excel: Step-by-Step
- How to Copy Into Multiple Cells in Excel Without Errors
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Number Format for Millions With One Decimal PlaceTo show a number in millions with one decimal place in Excel, apply the custom number format #,##0.0,,.…
- Outlook Never Block Sender: Why Mail Still Goes to JunkChoosing Never Block Sender in Outlook adds an address to your Safe Senders list; it does not guarantee…
- Excel Group Rows Together for Sorting: What Actually WorksTo keep related rows together when sorting in Excel, give every row in a group the same value…
- Track Changes in Word: How to Remove ThemTo get rid of Track Changes in Word, first turn tracking off, then accept or reject the recorded…
- Microsoft Word: Add a Header to the First Page OnlyTo add a header to only the first page in Microsoft Word, open the header, select the Header…
- How to Create and Set Up an Email Signature in OutlookTo create an email signature in Outlook, open the signature settings for your version, make a new signature,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.