80

Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but the lines remain on my screen. Any ideas to get rid of them?

studiohack
  • 13,477
Mark Allison
  • 1,285

8 Answers8

99

I have Excel 2007 so I'm giving the instructions to hide page break lines for Excel 2007, but it should be applicable to Excel 2010 as well:

  1. Click on the Office button in the top left corner.
  2. Select the Excel Options button at the bottom right side of the Office menu.
  3. Select Advanced in the left column.
  4. Scroll down to the Display Options for this Worksheet section.
  5. Uncheck the box marked Show Page Breaks.
  6. Click OK.

enter image description here

Mehper C. Palavuzlar
  • 55,953
18

You can create a macro and a custom button for your ribbon to toggle them on/off so you don't have to go through the Options every time.

VBA

Sub TogglePageBreaks()

  ActiveSheet.DisplayPageBreaks = Not ActiveSheet.DisplayPageBreaks

End Sub

I created/saved this macro to the Personal.xlsb file (see Copy your macros to a Personal Macro Workbook).

I then added a button to my Excel 2010 Ribbon for the macro (see How to add your own Macros to Excel Ribbon).

Clicking it toggles the page breaks on and off in any spreadsheet you open.

random
  • 15,201
AMM
  • 369
7

For Excel 2010, go to File, Options, Advanced. Then page down to Display options for this worksheet and uncheck Show page breaks. Be sure you are in Display options for this worksheet and not 'this workbook'. That should do it!!

Brad Patton
  • 10,668
Dana
  • 71
5

In the Immediate console (Alt + F11 -> Ctro + G), execute the following command: ActiveSheet.DisplayPageBreaks = False

Julius Getz Mørk
  • 151
4

The fastest way I have found is to simply save your file, close and reopen. The dashed print lines should no longer be displayed.

Rory Simms
  • 41
4

Here are the instructions for Excel 2003:

  1. Go to the Tools menu and select Options.
  2. Select the View tab.
  3. In the Window Options section, uncheck the box marked Page Breaks.
  4. Click OK.
jjz
  • 462
0

Go to View set "Workbook views" from Page Break preview to Normal. This will remove the background Page number" watermark.

Go to Options -> Advanced -> Display options for this worksheet -> Remove "Show page breaks". This will remove the printing dotted lines.

Rajesh Jain
  • 21
0

Excel 2011 for Mac:

1) Go to Preferences (⌘ + ,)
2) In the Authoring section, click View
3) On the right under Window options, uncheck Show page breaks

jlewkovich
  • 168