| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Preview
After closing a print preview screen you see a dotted line outlining the
pages. What would be the cause that this dotted line is not showing in the worksheet? Connie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Preview
ToolsOptionsView. "PageBreaks" is not checked.
Gord Dibben MS Excel MVP On Thu, 27 Dec 2007 09:31:00 -0800, Connie Martin wrote: After closing a print preview screen you see a dotted line outlining the pages. What would be the cause that this dotted line is not showing in the worksheet? Connie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Preview
Gord, thank you, but this wasn't the problem. With that box checked or not,
the page breaks were not showing after closing print preview. I was trying to troubleshoot this for another employee and we were stumped until he said, "Another problem with this spreadsheet is that as I add for rows the printout gets smaller and smaller." Bingo! That was the problem. In page setup, "Fit one page wide by one page tall" was selected. When we changed it to "Adjust by % size", it solved both problems. The page breaks now show after closing out of print preview. Connie "Gord Dibben" wrote: ToolsOptionsView. "PageBreaks" is not checked. Gord Dibben MS Excel MVP On Thu, 27 Dec 2007 09:31:00 -0800, Connie Martin wrote: After closing a print preview screen you see a dotted line outlining the pages. What would be the cause that this dotted line is not showing in the worksheet? Connie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Preview
Thanks for the update of your resolution.
Appreciated by all. Gord On Fri, 28 Dec 2007 06:51:05 -0800, Connie Martin wrote: Gord, thank you, but this wasn't the problem. With that box checked or not, the page breaks were not showing after closing print preview. I was trying to troubleshoot this for another employee and we were stumped until he said, "Another problem with this spreadsheet is that as I add for rows the printout gets smaller and smaller." Bingo! That was the problem. In page setup, "Fit one page wide by one page tall" was selected. When we changed it to "Adjust by % size", it solved both problems. The page breaks now show after closing out of print preview. Connie "Gord Dibben" wrote: ToolsOptionsView. "PageBreaks" is not checked. Gord Dibben MS Excel MVP On Thu, 27 Dec 2007 09:31:00 -0800, Connie Martin wrote: After closing a print preview screen you see a dotted line outlining the pages. What would be the cause that this dotted line is not showing in the worksheet? Connie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
| Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
| my Excel chart doesn't print as it appears on print preview | Excel Discussion (Misc queries) | |||
Hybrid Mode
