How to remove the print preview lines in Excel 2010?

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.

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.

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