ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page scaling & Page break preview prob (https://www.excelbanter.com/excel-discussion-misc-queries/27016-page-scaling-page-break-preview-prob.html)

Martin ©¿©¬ @REMOVETHIS.plus.com

Page scaling & Page break preview prob
 
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
©¿©¬


chris100


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



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com