I Hate Page Break Previews (Part 1)

No, seriously.  I really, really hate page break previews in Excel.

You know what page breaks are - those damn dotted lines that appear in a worksheet after you print.  Or sometimes page breaks appear randomly, at the whim of some preternatural Excel superbeing.  Call it an irrational hatred (at least that's what I chalk it up to).

Example of  a page break in Excel

To turn off page breaks In Excel 2010 is 4 to 5 clicks.  Seriously, 4 to 5 clicks to turn off these damn lines.  Microsoft, GTFO.

First up, you need to click 3 times (File>Options>Advanced), then scroll 75% of the way  down the Advanced Options dialog to Display Options for this worksheet.  Make sure you select the worksheet you want to turn off page breaks for from the dropdown box.  Finally deselect Show Page Breaks. God help you if you have a large workbook with 100+ sheets.

Moar seals, less page breaks!

VBA solution to follow in a future post...
UPDATE: VBA solutions here