Why is my excel sheet suddenly printing very small?

[JMartin]

I am modifying an Excel sheet, and after making several changes to the
format, my sheet only prints in a miniature version in the top left quadrant
of the page (the layout orientation is landscape). How can I get my document
to start printing again in its full size?
Thank you so much in advance for your help.

 

[Sandy Mann]

One possibility, if you have a large print area set, (because you originally
had more data), and "fit to 1 page wide by 1 page tall" set. Check the
setting in Page layout.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[JMartin]

Thank you! My only question is, how do I fix it? What should I 'fit' it to?

 

[Sandy Mann]

It depends on how your data is laid out and how you want it to print. Try
changing the scaling in Page Setup to "Adjust to 100% normal size" and clear
the setting for Print area in the Page Setup *Sheet* tab and then see what
you get.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[JMartin]

Got it. THANK YOU!

It depends on how your data is laid out and how you want it to print. Try
changing the scaling in Page Setup to "Adjust to 100% normal size" and clear
the setting for Print area in the Page Setup *Sheet* tab and then see what
you get.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Glad that you got it sorted out. Thanks for letting us know that it worked.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

Just uncheck that option and set the one above to 100%.

See what you get.


Gord Dibben MS Excel MVP