and for what it's worth in VBA use
ActiveSheet.DisplayPageBreaks = False

Showing page breaks will slow down many macros -- those
which insert or delete rows or columns for instance, so it is a
good idea to get rid of their display when not needed.
Display come up after Print Preview or Printing.

"William" wrote in message...
ToolsOptionsView
Remove check mark from "Page Breaks"


"how to hide page breaks?"
simple... how do i do it in excel?