Somehow or another i managed to switch on the print margin lines in excel 2010 I can't turn them off I went to page layout->page setup->print area->clear print area but the lines remain on my screen. What should i do to get rid of them?

Best Answer

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