Page breaks and print area

[littleme]

This has been bugging me for ever. Dont understand why in some
workbooks, excel manages to correctly identify active pages and print
out the right number. Then in other books it goes haywire and
identifies too few or too many pages... Ive reset the print area
several times. If there is formatting on a page, but no data, does
excel then identify that as an active page or is this some common bug?
Had to remove the page of pages function becaus alwyas showed the wrong
number of pages...

Its really frustrating, especially since I have to run around the
office helping people pring things out properly and explain why it
doesnt work properly... argh.

Hope someone understand my probelm and can tell me what ot check.... =)


Happy summer

 

[JE McGimpsey]

This has been bugging me for ever. Dont understand why in some
workbooks, excel manages to correctly identify active pages and print
out the right number. Then in other books it goes haywire and
identifies too few or too many pages...

I've never seen XL identify too few pages. I've occasionally seen too
many, usually when cell formatting was applied to entire rows or
columns. Explicitly setting the Print area in that case solved the
problems.

Ive reset the print area several times.

If you set the Print Area, XL will print all and only that area,
regardless of whether you have cell entries or cell formats in cells
within or without the print area.

If there is formatting on a page, but no data, does excel then
identify that as an active page or is this some common bug? Had to
remove the page of pages function becaus alwyas showed the wrong
number of pages...

Values/Formulae and cell (but not font) formatting will define the
default Print Area. So if you have entries in A1:B2, and format Z150
with a white background, the default print area will be A1:Z150, with a
lot of blank pages.

Its really frustrating, especially since I have to run around the
office helping people pring things out properly and explain why it
doesnt work properly... argh.

Hope someone understand my probelm and can tell me what ot check.... =)

If you're getting anomalous results, select the rows/columns outside
your data area and choose Edit/Clear/Clear All. On older versions you
*may* have to save/close the workbook and reopen it to reset the default
Print Area, but I don't remember.

Do you have any specific examples of problems that aren't addressed
above?

 

[littleme]

Thank you... At leat now I understand the problem, which is a relief in
itself... Im guessing then that the format rule applies to conditional
formatting as well... which leads me to another problem.... Which I
hope you can help me with: Need a horizontal line to appear at each
page break. Used conditional formatting to do that before but that
seems to mess things up, so would need some help. Any ideas?

 

[littleme]

Have another, related problem, print area will not adjust and shrink as
long as have formatted columns with lins dividng the columns. But I
need those lines! and at the same time need pring area to adjust! How
do i get aroung this problem? as well as the one above?

 

[JE McGimpsey]

Need a horizontal line to appear at each
page break. Used conditional formatting to do that before but that
seems to mess things up, so would need some help.

I'm not sure what you really are looking for...

What's messed up about CF? Do you want the horizontal line to print? If
so, on the bottom of the first page or the top of the second?

Should the line extend across the entire sheet or only part?

 

[littleme]

Ok.. youre right there is nothing wrong with CF.... so realised that
creating a horizontal line at certain row numbers worked using CF...
however the column lines are a bit trickier... am aware that can use CF
there too, but feels like one should be able to have the lines dividing
columns already drawn and still have print area adjust or no?