View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Fit To Pages & page Breaks

From XL Help ("Print to fit a fixed size or number of pages"):

Microsoft Excel ignores manual page breaks when you use the Fit to
option.



In article ,
"Tony McGee" wrote:

Hello all

In Excel (2003) I would like to in Page Setup, use a combination of "Fit To
Pages" (say 1 wide by 50 tall) & also have Excel use manual Page Breaks I
insert.

Excel allows me to insert the page breaks but it only seems to recognise
them wihn I go bakc to 100% (not fit to pages) mode.

Is it possible to combine these two print options?

Thanks
Tony McGee