excel print not right 2

[CFNB]

Hello all.

When i specify rows to repeat at top when printing,i get page breaks in the middle of the page. If i print without this feature, there is no problem!

thanks for any hint.

 

[macropod]

Hi CFNB,

Perhaps you worksheet has hard-coded page breaks and, when you've got header rows specified, that's throwing things off.

Cheers

[MS MVP - Word]

 

[CFNB]

thanks macropod.

where do i look for hard-coded page breaks ?

 

[xlhelp]

View, Page Break Preview

Member- AAAA Association Against Acronym Abusers

 

[CFNB]

well this is the problem.

Everything is ok in Page Break Preview but it not when printed!

thanks again.

 

[xlhelp]

I would suggest starting fresh. Remove all Page setup. See what the print out is going to look like, then re-apply page setup. Somewhere along the line there may be something weird like Fit-to-page and manual page breaks applied together. (Combination of these two give strange results).

Member- AAAA Association Against Acronym Abusers

 

[CFNB]

thanks.
this what i did.