Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

4 Answers 4

up vote 34 down vote accepted

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

share|improve this answer
1  
Aha page breaks! I thought it was something to do with printing. Worked a treat, thanks v much. –  Mark Allison Sep 6 '11 at 13:02
    
@Mark Allison: You're welcome. –  Mehper C. Palavuzlar Sep 6 '11 at 13:13
1  
+1 for this. They seem to turn on automatically somehow but I've no idea what I am doing to enable them. Another question, perhaps :) –  Mark McDonald Jun 25 '12 at 6:12
    
Similar option on the Mac version: Preferences > View > Show page breaks –  Baumr Dec 31 '12 at 16:14
1  
They actually turn on after you have went to print once. –  RipperDoc Apr 30 at 5:29

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 this link for an explanation: http://office.microsoft.com/en-us/excel-help/copy-your-macros-to-a-personal-macro-workbook-HA102174076.aspx ).

I then added a button to my Excel 2010 Ribbon for the macro (see this link for an explanation: http://chandoo.org/wp/2012/02/27/how-to-add-your-own-macros-to-excel-ribbon/ ).

Clicking it toggles the page breaks on and off in any spreadsheet you open. I don't have enough reputation points yet to post an image so if you want me to send a screenshot of what my ribbon looks like, let me know at amccmail-online@yahoo.com

share|improve this answer

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!!

share|improve this answer
    
My Excel 2010 is not showing an "Office" button (step 1 in Mehper's answer), but THIS answer worked. –  Doug_Ivison Mar 11 at 8:37

I'm running MS Excel 2008 for MAC, so none of above suited me for a quick fix.

But, I came up with another, a poor-man and very easy option, to get rid of those guidelines:

Go to PAGE SETUP / OPTIONS and make a CUSTOM PAPER SIZE setting it up for, say, 2000x2000 mm (for example, or else).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.