Feb 2016: How to Get Rid of a Dotted Line in Excel

Leave a comment

Dotted lines that appear in an Excel worksheet usually represent page breaks, which are displayed so you can see how adjustments to your document affect the printed copy. If you find the lines annoying, you can turn them off in the Excel options. Dotted lines also may be used as cell borders to separate groups of data. You can get rid of these dotted lines using a simple eraser tool.

Page Breaks

Step 1Click the “File” menu and select “Options.”

Step 2Click Advanced,” and then scroll down to the “Display Options for this Worksheet” section.

Step 3Remove the check mark from the box next to “Show Page Breaks,” and then click “OK.” The page break lines no longer show in Normal view; however, the setting only applies to the current worksheet.

Cell Borders

Step 1Click the “Home” tab, and then click the arrow next to the Borders icon in the Font section of the ribbon. The Borders icon is the small square to the left of the paint bucket icon.

Step 2Select “Erase Border” from the menu. Your mouse pointer turns into an eraser.

Step 3Hold down your mouse button, and drag the eraser over the dotted line to delete it. Double-click anywhere in the worksheet to return your pointer to normal.


  • In some cases, a dotted line may be a drawing object or image. Remove it by clicking the line to select it and then pressing the “Delete” button on your keyboard.


  • Information in this article applies to Microsoft Excel 2010 and 2013. It may vary slightly or significantly with other versions or products.

About Letowon Saitoti Abdi

simple person and always happy.