Why is there a dotted line in excel

Improve this answer. Reddy Lutonadio Reddy Lutonadio Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? This kind of dotted line is actually caused by the switching of workbooks views. You can see this feature in View tab or the bottom right of Excel window.

When you switch the view from Normal to other styles then switch back, you are very likely to see several dotted lines in the page. To remove these dotted lines, just select Print Area in Page Layout tab.

Then click Clear Print Area. You can even decide to do away with the borders. You should also notice that excel shows the grid and borderlines by default. I mean, the lines around your cells and columns. You can decide to remove those lines if you want your work to be devoid of lines or dots. Select your data and check the top menu bar and click the "view tab. Take a look at the gridline box and untick the checkmark.

You can remove the page break by selecting the cell and row that follows it immediately. Selecting the Home tab at the top of the screen reveals the Font section on the ribbon. Clicking the Borders drop-down button gives you an extensive list of border options for the currently selected cell or range of cells.

If your current borders are dotted lines, you can turn off borders or select a style other than dotted lines for the cell borders. An Excel page break problem can also create unexpected dotted lines. When you have a spreadsheet formatted to print, page breaks are represented horizontally by lines. In the current version of Excel for Office , a manually added page break shows as a solid horizontal line, while automatically generated page breaks show as dotted lines.

To remove a single manually added page break in Excel, select a cell in the row immediately below the primary page break. Click on Breaks and select Remove Page Break. In Normal View, the solid horizontal line disappears.