Hi
I have an Excel file with 5 columns.
I insert a title bar on each page after the contents are fitted to the
page size. This ends up as a 4 page catalogue with headers & footers
When i print preview, i need to adjust the page scaling to 59% or 60%
so as it prints at a reasonable size
However, this knocks out the page breaks and when i re-set the page
breaks the scaling reduces to 54%

How do i get the desired page scaling AND have page breaks in the
correct place ?

Martin
©¿©¬

Try reducing margins, headers & footers in page setup.


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=372589