Why is my excel sheet suddenly printing very small?

  • Thread starter Thread starter JMartin
  • Start date Start date
J

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.
 
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
 
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
 
Got it. THANK YOU!

Sandy Mann said:
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
Click to expand...
 
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
 
Just uncheck that option and set the one above to 100%.

See what you get.


Gord Dibben MS Excel MVP
 
Back
Top