Fixing page width for print purposes

[andrewdelmont]

Ive created a number of forms for my business. Often when I print it resets the width and it often pushes a column into the adjacent page. The same thing happens when I try to line up the top right footer with the page side. What I want to do is set the page width permenantly so it can never add a column of pages when I print (particularly to PDF). I'm not familiar with programming so a non-programming solution if possible please. Thank-you

 

[matthew230]

Possible with VBA,

Without you can tell it to print to one page etc. in the print properties.

Or view page break review to see if it is going to go over the page.

 

[andrewdelmont]

Thanks Matt, the review page break function has sorted the main problem. I didnt fix the alignment issue with the right header, but thats minor. Thanks

 

[Peter_SSs]

Andrew

I would pursue Matthew's middle paragraph. While in your sheet ...

File|Page Setup...|Page tab|select Fit to 1 pages wide and remove the number altogether from the 'tall' box|OK

 

[andrewdelmont]

Brilliant, thank-you Peter, that works
Andrew (Johannesburg)