Author: Oscar Cronquist Article last updated on August 22, 2020 Show
Have you ever wondered how these lines got there on a worksheet? If you press with left mouse button on Page Break Preview button on tab "View" and then press with left mouse button on "Normal" button, the lines appear, however, they don't disappear automatically. So how do you get rid of them? You can't easily disable them press with left mouse button oning a button on the ribbon, unfortunately, you must go to the Excel Options and disable it there. See detailed instructions below. What's on this page
I made a macro, demonstrated later in this article, that you can use to quickly disable the print preview lines, put it in your personal toolbox and use it whenever necessary. There is also a macro-enabled workbook for you to get further down in this post. It seems that if you close the workbook and then open it again the print preview lines disappear, however, this is in my opinion to much work to only remove the lines. How to remove dotted lines (Excel Options)
How to remove dotted lines (Immediate window)If you are familiar with the Immediate window in the Visual Basic Editor you can probably more quickly delete the print preview lines than through Excel Options.
ActiveSheet.DisplayPageBreaks = False How to remove print preview dotted lines [Excel 2007]
How to remove print preview dotted lines [Excel 2003]
Excel 2011 Macintosh
Build a macro and automate these stepsIf you often disable print preview lines manually why not build a macro that does it for you? It is not hard, simply copy the macro and paste it to your workbook module. If you want to use it any workbook you open, put it in a personal macro workbook and link it to the Quick Access Toolbar or the ribbon. In fact, you can save useful macros in your personal macro workbook and become a lot more efficient in your work. Macro to disable print preview linesWhat happens if we record a macro while disabling "Page Breaks" in Excel options? This is what the macro recorder returns: Macro1() ActiveSheet.DisplayPageBreaks = False End Sub Use the above line in the examples below if you don't want to toggle print preview lines. Macro toggles print preview lines on the active worksheetUsing that code you can now show or hide "Page Breaks" on the active sheet with a macro. Meaning, if "Page Breaks" are visible this macro hides them. If "Page Breaks" are hidden, the macro makes them visible. Sub Macro1() ActiveSheet.DisplayPageBreaks = Not ActiveSheet.DisplayPageBreaks End Sub Macro toggles print preview lines on every sheet in the workbookThe following macro shows or hides "Page Breaks" on every sheet in the current workbook. Sub Macro2() Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets sh.DisplayPageBreaks = Not sh.DisplayPageBreaks Next sh End Sub Macro toggles print preview lines on every sheet in all open workbooksThis macro toggles "Page Breaks" on every sheet in every open workbook. Sub Macro3() Dim wb As Workbook Dim sh As Worksheet For Each wb In Workbooks For Each sh In wb.Worksheets sh.DisplayPageBreaks = Not sh.DisplayPageBreaks Next sh Next wb End Sub Watch a video where I explain how to use the macros aboveWhere to put the code
Don't forget to save the workbook as a macro-enabled workbook (*.xlsm file) or the macro is gone the next time you open the workbook. Here is how to put this macro on the Excel ribbon: Recommended articles
Recommended articles
How to find errors in a worksheet
How to quickly select a cell range
How to find blank cells
How to quickly select blank cells
How to select cells with data
Convert column number to column letter
Improve worksheet readability
Rotate text to save space
Create a numbered list ignoring blank cells
How to format numbers as text Latest updated articles. More than 300 Excel functions with detailed information including syntax, arguments, return values, and examples for most of the functions used in Excel formulas. More than 1300 formulas organized in subcategories. Excel Tables simplifies your work with data, adding or removing data, filtering, totals, sorting, enhance readability using cell formatting, cell references, formulas, and more. Allows you to filter data based on selected value , a given text, or other criteria. It also lets you filter existing data or move filtered values to a new location. Lets you control what a user can type into a cell. It allows you to specifiy conditions and show a custom message if entered data is not valid. Lets the user work more efficiently by showing a list that the user can select a value from. This lets you control what is shown in the list and is faster than typing into a cell. Lets you name one or more cells, this makes it easier to find cells using the Name box, read and understand formulas containing names instead of cell references. The Excel Solver is a free add-in that uses objective cells, constraints based on formulas on a worksheet to perform what-if analysis and other decision problems like permutations and combinations. An Excel feature that lets you visualize data in a graph. Format cells or cell values based a condition or criteria, there a multiple built-in Conditional Formatting tools you can use or use a custom-made conditional formatting formula. Lets you quickly summarize vast amounts of data in a very user-friendly way. This powerful Excel feature lets you then analyze, organize and categorize important data efficiently. VBA stands for Visual Basic for Applications and is a computer programming language developed by Microsoft, it allows you to automate time-consuming tasks and create custom functions. A program or subroutine built in VBA that anyone can create. Use the macro-recorder to quickly create your own VBA macros. UDF stands for User Defined Functions and is custom built functions anyone can create. A list of all published articles. Why do lines disappear in Excel when printing?Troubleshoot printing issues with gridlines – If gridlines don't show up when you print your worksheet, or if you can't see them in the Print Preview window, check that the Draft quality check box is not selected. The Draft quality check box appears on Sheet tab in the Page Setup dialog box.
How do I make lines visible in Excel when printing?On the File menu, click Print.. Click the sheet.. On the Layout tab, under Print, select the Gridlines check box.. On the File menu, click Print.. |