Feb 2016: How to Get Rid of a Dotted Line in Excel
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.
Step 1Click the “File” menu and select “Options.”
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.
- 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.