Printing in A3 using the maximum page area

macropod · #1 01-26-2015, 03:57 AM

Have you tried setting the print scaling to 1 page width & height? If you have, and a portion of the page remains unused, that's because your worksheet doesn't require a full page when scaled to fit. If you have spare width, you can try increasing the column widths. Conversely, if you have spare height, you can increase the row heights. In either case, choosing a different font can both improve legibility without an increase in point size and, depending on the font, allow a larger point size. For example, if you have spare height, changing to Arial Narrow will allow a larger point size than, say, Arial, without increasing the overall width.

stuwoolf · #2 01-27-2015, 11:54 AM

Quote:

Originally Posted by macropod

Have you tried setting the print scaling to 1 page width & height? If you have, and a portion of the page remains unused, that's because your worksheet doesn't require a full page when scaled to fit. If you have spare width, you can try increasing the column widths. Conversely, if you have spare height, you can increase the row heights. In either case, choosing a different font can both improve legibility without an increase in point size and, depending on the font, allow a larger point size. For example, if you have spare height, changing to Arial Narrow will allow a larger point size than, say, Arial, without increasing the overall width.

Thanks for your help.

I did as you said and I now have a full page print.

Thanks again.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Page print area	namyeyelus	Excel	1	07-15-2014 10:05 AM
Page number is set outside print area	sgp22	Word	2	06-18-2014 11:06 AM
Set an area that cannot be edited in one page of word	expert4knowledge	Word	1	02-18-2014 08:30 AM
Setting the printing area	secoo140	Excel	1	10-13-2013 05:15 PM
2 page document printing problem, text from page 1 in layout of page 2 when printed	laurawether45	Word	1	08-02-2012 07:03 AM