I looked at the file "dpi-Julia99r-modified.xls" you sent and it is perfect. I previewed & printed it on 100%, 120% & 125% dpi . It is the same on all settings - the pagebreaks & margins incorporate all the text perfectly !!
There is just one "grey" row missing at the bottom of each page which I think you may have only omitted when you setup what ever you did. I have attached 2 pages of the spreadsheet to show you the missing lines which I have marked with a purple text box & arrow (row is also missing on page 3,4,& 5 ). So next thing is you need to explain to me what you did to correct my problem & how !!

Attached Images

	SCREEN PRINT PG 1.jpg (205.7 KB, 15 views)
	SCREEN PRINT PG 2.jpg (260.0 KB, 15 views)

If you got on one sheet more than 1 page to print don't leave it to excel to choose the printarea. As you've seen now, maybe excel won't get it right. What I did, I set up printarea with vba. Open the file and press Alt + F11 in Modul1 is this code:
But there is also a way to do it manually without vba:
- Select on the sheet the cells for the first page
- Keep pressing <CTRL> while selecting further areas for page 2, 3, ...
- Maybe a empty row/column has to separate the different areas, please check on this
- Once all areas are selected (they will all be shown marked) you click on the menue File ---> Printarea ---> Define

If you have then a look at preview it will show the defined pages. In case you have selected the areas too big in size that they won't fit on one page excel will devide the printout of these areas on more than one page.
Still you have more options by clicking "Layout": There you can for example adjust the margins and try to get the areas fit on one page. Be aware that some printers require a minimum margin on top and bottom.Therefore I was setting the margin for the bottom to 0.5. If you want include the grey row in the area, you will have to set that margin to 0 and look what your printer makes of it.
I just discovered that there is at least one more option in "Layout": Obviously the size of the areas to print can be modified by percentage. I haven't tried, but seen the helpmenue provides some explanation on this.

Closing the file you will have to agree to save. This way the established printarea and everything related will be saved as well for the next time.

I left out any explanation on vba, it might be quite difficult that way if you never worked with. Just that much: In case you pressed Alt + F11 and wonder how to close the window: Click on the window's menue File ---> Close and Return to excel

wow !!! thankyou so much for all that. You have spent a LOT of time helping me out with this and I am just so grateful !!
I'll have a play around with what you have said and see how I go. I have read a little on VBA but really don't know anything about it... So I'd rather not go down that path.
Thanks heaps again !!!

Never mind you're welcome