Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Fit To Pages & page Breaks

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



  #2   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I can't move my page breaks in Page Break Preview btaft Excel Discussion (Misc queries) 6 April 27th 23 11:49 AM
Setting pages breaks in Excel Pretzil Excel Discussion (Misc queries) 1 October 13th 06 11:15 PM
Pages hidden with manual breaks still print D Poole Excel Discussion (Misc queries) 1 February 10th 06 02:43 PM
sheet tabs as page number and in a cell page of pages? [email protected] Excel Discussion (Misc queries) 0 November 22nd 05 02:43 PM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"