#1
|
|||
|
|||
Printing in A3 using the maximum page area
Hi,
I need some help with printing a spreadsheet in A3. The spreadsheet is 57 Columns by 44 Rows. I want to print this on a single sheet and in Landscape mode.....and then be able to read it! Whilst I can set the Print Options in A3, the output is less than satisfactory as the print is confined to the upper part of the sheet and is leaving about a 1/3 to a 1/4 of the page unused. Using the bottom 1/3 or 1/4 will make it much easier to read the print. I have changed margins to narrow and made each Row abd Column as small as possible. The spreadsheet is being produced using Excel 2003 and is on a network. The question therefore is how to force the output to use the whole page or at least most of it? Grateful for some advice and guidance. Thanks |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
I did as you said and I now have a full page print. Thanks again. |
Thread Tools | |
Display Modes | |
|
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 |