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
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
