Forum home » Delegate support and help forum » Microsoft Excel Training and help » Page Break Preview default
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Page Break Preview default
Resolved · High Priority · Version 2007
Reply Mon 12 Jul 2010, 17:29Delegate Ludovic said...
Ludovic has attended:
Excel Intermediate course
Page Break Preview default
Every week I print an A3 spreadsheet and I have to go into page break preview to alter the page break to make sure when it prints it captures all the necessary cols and rows.
Is there a way I can make the page break setting permanent on this one file? I have been doing the same thing week in week out for this... would be nice to have it set up.
Thanks
For upcoming training course dates see: Pricing & availability
RE: Page Break Preview default
Hi Ludovic, thanks for your query. You need to set up a custom view. Set the page breaks to the required position and the go to the View tab and the Custom Views option on the left hand side. Click on Add and give you view a name (say, A3Print) and note that the Print settings box is ticked. That will save the view.
Now when you need it, simply go to View - Custom Views, select A3Print and click Show. It will snap the spreadsheet straight to your view settings.
Hope this helps,
Anthony
Tue 20 Jul 2010: Automatically marked as resolved.
|