Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default Dealing with automatic / manual page breaks


I have a little problem and I would like to know if there is a solution
to it...

I have a very long worksheet, with two buttons allowing to switch
between the short and the full view. Obviously, I would like to correct
the page breaks in some instances, e.g. where a section title is at the
end of a page. However, if I change an automatic page break to a manual
page break, the summary view printing gets all screwed up, as it is
affected of the same manual page breaks. Any idea what could help me?

(I CANNOT set two worksheet for both view, as the update of the data
would be an issue.) I guess I might just leave the automatic breaks as
is, but it sux!:P

Thanx


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=555996

  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default Dealing with automatic / manual page breaks

Nel post news:Turquoise_dax.2a2ahz_1151413202.4901@excelfor um-nospam.com
*Turquoise_dax* ha scritto:

I have a little problem and I would like to know if there is a
solution to it...

I have a very long worksheet, with two buttons allowing to switch
between the short and the full view. Obviously, I would like to
correct the page breaks in some instances, e.g. where a section title
is at the end of a page. However, if I change an automatic page break
to a manual page break, the summary view printing gets all screwed
up, as it is affected of the same manual page breaks. Any idea what
could help me?

(I CANNOT set two worksheet for both view, as the update of the data
would be an issue.) I guess I might just leave the automatic breaks as
is, but it sux!:P

Thanx



Hi,

You can use Custom Views. From menu View select Custom Views, Add. You have
to specifiy a name for each view. So the procedure should be:
prepare your worksheet to print in detailed mode, add a custom View called
Detail; now prepare your worksheet to print in summary mode and add a custom
view called Summary.
Now you can switch from a view to another and also the page breaks will
switch.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.misc
Turquoise_dax
 
Posts: n/a
Default Dealing with automatic / manual page breaks


Thanx, I know this is working fine, but I though of it and it is not
applicable to this project.

The trick is there is gonna be many excel files, based on the same
template, and once initiated, the company's Knowledge Management center
will be responsible for the udates and residency. However, they cannot
perform editing, so any added row or data would screw up the custom
view. So I guess I'll just leave it to the automatic page break and the
user will modify the print setting after getting a copy from the
read-only file if he wants to...

Thanx anyway!


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=555996

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
evenly spaced page breaks sorrywm Excel Discussion (Misc queries) 2 December 15th 05 01:25 AM
find automatic page breaks Reason Excel Worksheet Functions 1 April 15th 05 06:03 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 10:29 AM
Automatic page breaks in Excell 2003 Novice Excel Discussion (Misc queries) 2 February 21st 05 10:59 PM
How do I stop automatic page breaks in excel Lesley Hutchinson Excel Worksheet Functions 0 October 31st 04 01:49 PM


All times are GMT +1. The time now is 06:01 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"