Quick Links
Have you ever been working on an Excel spreadsheet when dotted lines suddenly appeared?
While fine to some, those dotted lines may be distracting to others.
We’ll show you when and why these dotted lines appear and how to remove them.
There are a few instances where you may see dotted lines in Excel.
Here’s how to remove dotted lines in Excel for these situations.
These are indicators of page breaks for your spreadsheet.
When the Excel Options window opens, select “Advanced” on the left.
On the right, scroll down to the Display Options for This Worksheet section.
As with printer previews, you’ll see lines for the page breaks.
To return to Normal view, select “Normal” on the View tab.
To remove these lines, follow the same steps as above for after a printer setup.
When the Options window closes, your dotted and solid page break indicators should be gone.
One of thesechanges may include borderswhere there were none before or dotted cell borders.
you might either remove the border completely or choose a solid line style rather than dotted.
opt for cells containing the borders.
Then, head to the Home tab and Font section of the ribbon.
poke the Borders drop-down box.
To remove the borders altogether, choose “No Border.”
This deletes the borders from all selected cells.
In the pop-out menu, pick one of the solid line options.
You should see any borders with dotted lines updated to solid lines.
Related:How to Remove Gridlines in Microsoft Excel
