Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Break Lines in Excel 2007
After I do a page preview for a worksheet, from that point on the page break
lines appear and I can't figure out how to get them turned off. They are there in Normal, Page Layout, and Page Break Preview. Now do you get them to disappear, at least on the Normal view? Thanks! Ostate |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Break Lines in Excel 2007
Figured it out--there is a check box option buried deep in the Excel
Options. "Ostate" wrote in message . .. After I do a page preview for a worksheet, from that point on the page break lines appear and I can't figure out how to get them turned off. They are there in Normal, Page Layout, and Page Break Preview. Now do you get them to disappear, at least on the Normal view? Thanks! Ostate |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Break Lines in Excel 2007
Or programmatically:
activesheet.displaypagebreaks = False HTH "Ostate" wrote in message t: Figured it out--there is a check box option buried deep in the Excel Options. "Ostate" wrote in message . .. After I do a page preview for a worksheet, from that point on the page break lines appear and I can't figure out how to get them turned off. They are there in Normal, Page Layout, and Page Break Preview. Now do you get them to disappear, at least on the Normal view? Thanks! Ostate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove page break lines in normal view? | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
How do I show Grid Lines on Worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
Can I set an automatic page breaks to break every 40 lines? | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |