Print on full sheet a select area

J

John W

How do I get Excel to print a small print area on the full page? I have set the print area to print the relevant data and it is printing on legal paper, but it is cramming all of the data to the top of the page and leaving over 1/2 of the sheet blank. Any suggestions

Thanks

Joh
NYC
 
J

Jay

=?Utf-8?B?Sm9obiBX?= said:
How do I get Excel to print a small print area on the full page? I
have set the print area to print the relevant data and it is printing
on legal paper, but it is cramming all of the data to the top of the
page and leaving over 1/2 of the sheet blank. Any suggestions?
Click to expand...

One way is to use
File >> Page setup >> Page
One of the choices there is "Adjust to XXX % normal size." By choosing XXX
larger than 100 you can fill more of the page. You can use "Print preview"
to test the result before printing.
 
G

Gord Dibben

John

Try playing with the settings at File>Page Setup>Page "Adjust to".

Scale it up as far as you can.

Gord Dibben Excel MVP
 
N

nilizandr

if you just want to move the data, but don't want the size to chang
then also on page setup, on the margins tab, you can click on cente
horizontally and/or vertically on the page. (Adjust to % size is als
good, but may cause the appearance of the data to become very large.
 
Top