![remove print lines excel 2016 remove print lines excel 2016](https://i.stack.imgur.com/Fn8P8.png)
![remove print lines excel 2016 remove print lines excel 2016](https://support.content.office.net/en-us/media/fc25132a-538d-42c9-bdc0-19f27a4f2011.jpg)
REMOVE PRINT LINES EXCEL 2016 FREE
This free application for removing pages from Excel document will help you quickly get rid of pages that are bothering you, you can send your document to partners in the form you need. Storing resources in most documents is organized quite difficult for an ordinary user, so we have developed an application that will not only remove unnecessary pages from your Excel document, this application will optimize resources and pages in such a way that your document has the optimal size and retains only the necessary pages and data in them. So these are three ways you can remove the dotted lines in Excel.Remove pages from Excel document is a simple online application that allows you to remove unwanted pages from your document simply by specifying page numbers, without having to worry about images or other resources being damaged or missing. In case you want the Gridlines back, simply go back and check the same option. That’s it! The above steps would remove all the gridlines from the worksheet. In the Show group, uncheck the Gridlines option.These gridlines are applied to the entire worksheet and you can easily make them disappear. While the gridlines are not dotted lines (these are solid lines), some people still think that these look like dotted lines (as these are quite faint). In case you want to replace the dotted border with some other type of border, you can do that as well. The above steps would remove any borders in the selected cells. In the border options that appear, click on ‘No Border’.In the Font group, click on the ‘Border’ drop-down.Select the cells from which you want to remove the dotted border.To remove these dotted lines, you can either remove the border completely or change the dotted line border to the regular solid line border.īelow are the steps to remove these dotted borders: In some cases (not as common as page break though), people may use dotted lines as the border. Instead, you will see solid lined outlining the print area. In case you have set the print area in the worksheet, the dotted lines will not be shown. For other workbooks, you will have to repeat the same process if you want to get rid of the dotted lines. Note that the above steps would stop showing the dotted lines only for the workbook in which you have unchecked this option. The above steps would stop showing the page break dotted line for the workbook. Uncheck the option – “Show page breaks”.Scroll down to the section – “Display options for this worksheet”.In the Excel Options dialog box that opens, click on the Advanced option in the left pane.Here is a better way to remove these dotted lines: Reopening a workbook will remove the page break dotted lines. It divides your worksheet into sections and you would know what part will be printed on one page and what will spill over.Ī super easy (but not ideal) fix of this is to close the workbook and open again. Now, I understand the utility and purpose of keeping these. Sometimes, I see these page-breaks dotted lines (as shown below) that just refuse to go away. This is one of the most irritating things for me in Excel.
REMOVE PRINT LINES EXCEL 2016 HOW TO
Let’s dive in and see how to remove these dotted lines in Excel in each scenario. Your worksheet can have any one or more of these settings and you can easily remove these lines and disable it. These are not really dotted lines (rather faint solid lines that looks like dotted borders around the cells) Gridlines that appear in the whole worksheet.Borders that have been set to show as dotted lines.Due to Page breaks where Excel visually show page breaks as dotted lines.There can be various reasons for the dotted lines to appear in Excel: Possible Reasons for Dotted Lines in Excel Possible Reasons for Dotted Lines in Excel.