ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to hide page breaks? (https://www.excelbanter.com/excel-discussion-misc-queries/24259-how-hide-page-breaks.html)

how to hide page breaks?

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

William

ToolsOptionsView
Remove check mark from "Page Breaks"

--

XL2003
Regards

William



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




David McRitchie

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?








All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com