Remove print preview lines (Page Breaks)
- Excel For Mac 2011 Cant Remove Page Break Lines Images
- Excel 2010 Remove Page Break Lines
- Excel For Mac 2011 Cant Remove Page Break Lines 2017
Author: Oscar CronquistArticle last updated on August 22, 2020
Have you ever wondered how these lines got there on a worksheet?
They show where pages will break, in other words, they show how much of the worksheet that will be printed on a single paper or pdf.
They show where pages will break, in other words, they show how much of the worksheet that will be printed on a single paper or pdf.
So, the best is to try once to start Excel in Safe Mode. Press and hold CTRL when you start the program or else by using the “/safe” (excel.exe /safe) option while starting the program from the command line.; Now while running Excel in safe mode, this avoids functionality and settings like the alternative startup location, toolbars changes, the xlstart folder and even the Excel add-ins. Aug 26, 2020.
If you click Page Break Preview button on tab 'View' and then click '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 clicking 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 download 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)
- Click on tab 'File' on the ribbon.
- Click on 'Options'
- Click on tab 'Advanced'.
- Scroll down to 'Display Options for this worksheet'.
- Disable 'Show Page Breaks'.
- Click 'OK' button.
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.
- Copy code below.
- Press Alt+F11 to open the VB Editor.
- Paste code to the Immediate window
- Press Enter
- Return to Excel
How to remove print preview dotted lines [Excel 2007]
- Click the Office button located at the top left side of your screen.
- Click 'Excel Options'.
- Click tab 'Advanced' in the left window.
- Find 'Display Options for this Worksheet'.
- Disable the check box 'Show Page Breaks'
- Click 'OK' button.
How to remove print preview dotted lines [Excel 2003]
- Go to the Tools menu.
- Click Options.
- Click the View tab.
- Disable checkbox Page Breaks found in Windows Options.
- Click OK button.
![2011 2011](https://support.content.office.net/en-us/media/d15f3346-9ca8-42e7-bf7a-5610157abdc3.png)
Excel 2011 Macintosh
- Go to 'Preferences' on the menu.
- Click View in 'Authoring'.
- Disable checkbox 'Show Page Breaks' located below 'Windows Options'
Build a macro and automate these steps
If 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 lines
What happens if we record a macro while disabling 'Page Breaks' in Excel options? This is what the macro recorder returns:
Use the above line in the examples below if you don't want to toggle print preview lines. Noteburner itunes audio converter 2 1 6.
Macro toggles print preview lines on the active worksheet
Using 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.
Macro toggles print preview lines on every sheet in the workbook
The following macro shows or hides 'Page Breaks' on every sheet in the current workbook.
Macro toggles print preview lines on every sheet in all open workbooks
This macro toggles 'Page Breaks' on every sheet in every open workbook.
Watch a video where I explain how to use the macros above
https://youtu.be/eGyxSf6SdDAVideo can't be loaded because JavaScript is disabled: Remove Print Preview Lines [VBA] (https://youtu.be/eGyxSf6SdDA)
Where to put the code
- Copy the preferred macro above.
- Go to Visual Basic Editor (VBE). (Alt + F11)
- Click 'Insert' on the menu.
- Insert a new module.
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:
Save links to your favorite macros in a personal tab on the ribbon for easy access and become more productive. […]
Download Excel file
Toggle-Page-Break-printer-lines.xlsm
Recommended articles
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD […]
A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell […]
Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. […]
In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]
This article describes how to create a button and place it on an Excel worksheet then assign a macro to […]
I recently discovered something quite useful. Allow me to explain, sometimes you need to take a screenshot of your worksheet […]
This article explains how to print multiple worksheets so the page numbers are in sequence across all selected worksheets. Instructions: Go […]
If you want each page to have the same row(s) or column(s) to be repeated at every page you print. […]
- Thank you! You helped me remove the print preview lines. I'm so grateful!
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
Excel For Mac 2011 Cant Remove Page Break Lines Images
How to add VBA code to your comment
[vb 1='vbnet' language=',']
Put your VBA code here.
[/vb]
[vb 1='vbnet' language=',']
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Upload picture to postimage.org or imgur
Paste image link to your comment.
Excel 2010 Remove Page Break Lines
Contact Oscar
You can contact me through this contact form