Printing too small

[johnnyp1967]

When I set my printing area. I then go to Page Break Preview and adjust to what I want printed.
The resulted output is something like 50%. yet it doesn't cover the whole page.
how can i make the percent bigger where it will cover the whole page horizontally?

 

[GWteB]

Set your margins (Page Layout tab) to narrow or custom.

 

[johnnyp1967]

did that.
still a lot of area on top and bottom of spreadsheet

 

[GWteB]

When I set my printing area. I then go to Page Break Preview and adjust to what I want printed.

Excel prints with respect to the aspect ratio of the content to be printed. You have to live with that I presume ...

 

[johnnyp1967]

I mean I get that there is a lot of data wide but why can't it be bigger up and down?
There's got to be a way to do this I have seen it done.
thanks for your help.