You may have applied borders to cells in Excel for clarity, but now need a clean slate. Borders are a direct cell formatting property that overrides the default gridline view. This guide will show you how to delete all custom borders and return cells to their standard, borderless appearance.
Key Takeaways: Removing Cell Borders in Excel
- Home > Font > Borders > No Border: This is the primary command to clear all borders from selected cells instantly.
- Ctrl + 1 > Border tab > None preset: Opens the full Format Cells dialog for more precise border removal and verification.
- Clear Formats from the right-click menu: Removes borders along with all other direct formatting like fill color and font changes.
Understanding Cell Borders Versus Gridlines
Excel displays light gray gridlines on screen by default to help you see cell boundaries. These gridlines do not print and are not part of a cell’s formatting. A cell border is a manual formatting addition you apply. It prints and remains visible regardless of your gridline settings. When you remove borders, you are deleting this manual formatting, which makes the underlying gridlines visible again on your screen.
Borders can be applied as lines on any side of a cell or a range. The default state for any cell is to have no border formatting applied. The goal of removal is to return to this base state. It is important to select the correct range before applying the removal command, as it only affects the chosen cells.
Steps to Clear Borders and Restore Default Formatting
You can remove borders using several methods on the ribbon, with keyboard shortcuts, or through right-click menus. The following steps cover the most common and effective techniques.
Method 1: Use the No Border Command on the Ribbon
- Select the target cells
Click and drag to select the cell or range from which you want to remove borders. You can select an entire sheet by clicking the triangle at the intersection of the row and column headers. - Navigate to the Borders menu
Go to the Home tab on the ribbon. In the Font group, click the small arrow next to the border icon, which looks like a square divided into four. - Choose No Border
From the dropdown gallery, select the option labeled “No Border.” This action immediately removes all border lines from the selected cells.
Method 2: Clear Borders Using the Format Cells Dialog
- Open the Format Cells dialog
Select your cells and press Ctrl + 1 on your keyboard. You can also right-click the selection and choose Format Cells from the context menu. - Go to the Border tab
In the dialog box, click the Border tab at the top. This shows a detailed preview of the current border settings. - Select the None preset
In the Presets section on the left, click the first button, which is labeled “None.” This clears all border selections in the preview diagram. Click OK to apply the change.
Method 3: Use Clear Formats for a Complete Reset
- Select the cells
Highlight the cell range containing the borders you want to remove. - Open the Clear menu
On the Home tab, find the Editing group. Click the small arrow on the Clear button, which looks like an eraser. - Choose Clear Formats
Select Clear Formats from the dropdown list. This removes all direct cell formatting, including borders, fill colors, and font styles, reverting the cells to the default style.
Common Mistakes and Limitations When Removing Borders
Certain situations can make border removal seem ineffective. Understanding these will help you troubleshoot.
Borders Persist After Using No Border Command
If borders remain after using the No Border command, the formatting might be part of a table style or a cell style. Convert an Excel Table to a regular range first by clicking inside it, going to Table Design > Tools > Convert to Range. For cell styles, go to Home > Styles > Cell Styles and apply the Normal style.
Gridlines Are Not Visible After Border Removal
If your worksheet appears blank after removing borders, the gridlines are likely turned off. To make them visible, go to the View tab on the ribbon and check the box for Gridlines in the Show group. Remember, gridlines only appear on screen and do not print.
Only Some Borders Are Removed
This happens when borders are applied inconsistently across a selected range. For example, only the outer edges of a block may have borders. The most reliable fix is to select the entire affected area and apply the No Border command twice to ensure all individual cell edges are cleared.
Border Removal Methods Comparison
| Item | No Border on Ribbon | Format Cells Dialog (Ctrl+1) | Clear Formats |
|---|---|---|---|
| Primary Use | Quick removal of all borders from a selection | Precise control and verification of border settings | Remove all formatting including borders, fill, and font |
| Speed | Fastest method | Slower, due to dialog navigation | Fast |
| Precision | Removes all borders at once | Allows removal of specific border sides | No precision, removes everything |
| Best For | Standard cleanup tasks | Debugging complex border setups | Resetting a cell to complete default state |
You can now clean up any worksheet by removing unwanted cell borders. Use the No Border command on the Home tab for everyday tasks. If you need to audit complex formatting, the Format Cells dialog accessed with Ctrl + 1 gives you full control. For a deeper clean, try using the Clear Formats option to also remove other direct formatting like cell shading.