Formatting Issues

How to Remove Dotted Lines or Borders Beneath Excel Cells

Maira Mehtab Sep 22, 2026 871 views

Question details

The user wants to remove unexpected dotted lines appearing beneath certain spreadsheet cells and wants to understand what caused them.

Product: Spreadsheet
Device & OS: not provided
Scenario: Formatting spreadsheet cells
Observed behavior: Dotted lines appear beneath some cells and persist until the cell borders or conditional formatting rules are manually cleared.

Before you start

Verify whether the dotted lines are actual cell borders, page break indicators, or print area boundaries, as different types of lines require different removal methods.

Solution 1Recommended

Remove Cell Borders Using the Format Cells Menu

The most common cause of dotted lines beneath cells is unwanted border formatting. You can quickly clear this using the Format Cells dialog shortcut.

Often, formatting is accidentally applied or carried over when pasting data from another source. Clearing the border settings directly resolves this issue.

Select the affected cells

Highlight all the cells in your worksheet that have the unwanted dotted lines beneath them.

Open the Format Cells dialog

Press the Ctrl+1 keyboard shortcut to immediately open the Format Cells dialog box.

Remove the borders

Navigate to the Borders tab at the top of the dialog, click on 'None' under the Presets section, and click OK to apply the changes.

Quick Ribbon Alternative: You can also remove borders quickly by selecting the cells, navigating to the Home tab, clicking the Borders dropdown icon, and choosing 'No Border'.

Solution 2

Inspect and Clear Conditional Formatting Rules

If the dotted lines keep returning automatically after you remove them, they might be triggered by a conditional formatting rule.

Format Cells Easily with WPS Spreadsheet

Remove Unwanted Cell Borders in WPS Office

WPS Office offers a highly intuitive spreadsheet interface where you can easily customize cell borders, clear unwanted formatting, and manage spreadsheet styles seamlessly. It is a powerful, free alternative to Microsoft Excel.

1. Open your file: Launch WPS Spreadsheet and open the document containing the dotted lines.
2. Select the cells: Highlight the specific cells that have the unwanted formatting.
3. Clear the border: Go to the Home tab, locate the Borders icon in the font group, and select 'No Border'.
4. Save your work: Press Ctrl+S to save your newly formatted spreadsheet.

Fully compatible with Microsoft Excel (.xlsx) files and formattingClear unwanted cell borders in just one click from the Home ribbonEasily view and manage complex conditional formatting rulesLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why do dotted lines appear in my spreadsheet unexpectedly?

Dotted lines usually appear due to accidentally applied cell borders, pasting data that carries its source formatting, or active conditional formatting rules that apply borders based on specific criteria in your worksheet.

How can I tell if the dotted lines are page breaks instead of cell borders?

If the dotted lines extend across the entire width or height of the worksheet and do not disappear when you select 'No Border', they are likely page breaks. You can hide them by going to File > Options > Advanced, scrolling down to 'Display options for this worksheet', and unchecking 'Show page breaks'.

How do I clear all formatting from a cell at once?

To completely reset a cell, select it, navigate to the Home tab, click the 'Clear' button (often represented by an eraser icon) in the Editing group, and choose 'Clear Formats'. This will strip away borders, colors, font styles, and number formats instantly.

Document & File Issues