Channg excel printed size

[mrsphxbabe]

I know how to increase the fonts on screen, I know how to go into page set up and say fit to certain page size wide and certain page size high, but what I'm having a problem with is getting the printed text to alter, so that when it is printed I can actually read it.
It seems to be large on screen but then shrinks when I print it.
There is always plenty of space to the side of each page, but I want to stretch it to fit the full page but be bigger text. I have used page setup and said to print 1 page wide by 10 pages tall. But the text is so small it cant be read. and my columns are only 2 wide.

Can anyone help please? Thanks

 

[shg]

There is always plenty of space to the side of each page ...

Does the print area include empty columns? If so, change it so it doesn't.