| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hatched page break lines
I inadvertently printed a page which is normally only displayed visually,
and now the page boundaries appear as hatched horizontal and vertical lines. I have checked that there is no "Print_Area" selected for that sheet, but have been unable to get rid of the unwanted lines. Is there an easy way to remove them? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hatched page break lines
Tools=Option, view tab, at the buttom uncheck PageBreaks. Just a guess at
what you mean hatched (I would choose dashed or dotted, more like -----) - but I assume this will do it. -- Regards, Tom Ogilvy "Hotbird" wrote in message news:hXmZb.171$Z9.140@newsfe1-win... I inadvertently printed a page which is normally only displayed visually, and now the page boundaries appear as hatched horizontal and vertical lines. I have checked that there is no "Print_Area" selected for that sheet, but have been unable to get rid of the unwanted lines. Is there an easy way to remove them? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hatched page break lines
Thanks Tom for your explanation. Have got one more little question. I
would like to show a tiny printer icon in a corner of my spreadsheet, (or on a menubar) which can be switched on or off by program control to indicate when I have the automatic print function selected. "Tom Ogilvy" wrote in message ... Tools=Option, view tab, at the buttom uncheck PageBreaks. Just a guess at what you mean hatched (I would choose dashed or dotted, more ike -----) - but I assume this will do it. -- Regards, Tom Ogilvy "Hotbird" wrote in message news:hXmZb.171$Z9.140@newsfe1-win... I inadvertently printed a page which is normally only displayed visually, and now the page boundaries appear as hatched horizontal and vertical lines. I have checked that there is no "Print_Area" selected for that sheet, but have been unable to get rid of the unwanted lines. Is there an easy way to remove them? |
| 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) | |||
| how to remove the page break lines in a spread sheet, | Excel Discussion (Misc queries) | |||
| how do I remove dotted page break lines from my workbook pages? | Excel Discussion (Misc queries) | |||
| Page Break Lines in Excel 2007 | Excel Discussion (Misc queries) | |||
| Can I set an automatic page breaks to break every 40 lines? | Excel Discussion (Misc queries) | |||
![Hotbird[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
