speedking

Using Excel 2003 SP3.

When you have done a print preview the display shows the page 'edges' as dashed lines.

Is there any way of then turning them off? I can close the spreadsheet and re-open it and they have disappeared, but there doesn't seem to be a switch to turn them off once you have finished with the Preview mode.

<Rant> Converting to a pdf, the page sizes are slightly different in Adobe to those presented in Excel Print Preview mode, so we have to force every page length, to ensure that the pdf page numbering matches the Excel document. Seems to be related to Excel row heights that vary slightly when superscript or subscripts are used </Rant>

HankScorpio

Tools...
Options...
"View" tab.
"Page Breaks" checkbox

speedking

Yes that works, but it disables the Page Break Preview mode. Therefore I cannot view page break positions without turning the checkbox back on. Trouble is that in Page Break Preview mode the checkbox is disabled.

I suppose I can understand why the functions are linked.

Its nice to use a combination of print preview (includes headers, repeated rows at top, footers, true page numbers) and page break preview (for draggable page boundaries).

The checkbox is easier than closing and then re-opening, which is what I've done up to now, so thanks but it would be nice to be able to turn off the dashed lines without affecting the other functionality

HankScorpio

Mmmh... Doesn't on mine

Switch them off, work in the sheet, View... Page Break Preview Mode - comes up as expected.

View... Normal takes it back to normal with lines off.

speedking

Have tried other spreadsheets and they're OK. But for one you can select View, Page Break Preview, but the display doesn't change. Click on View again and the Page Break Preview button is highlighted, therefore that mode is selected. Tools, Options, View, and Page breaks checkbox is greyed out Must be 'slightly' corrupt.

Thanks for advice.