Centerally Expand for Better Printing

M

Manny

I have data that comfortably fits in one page in Portrait orientation.
However, there's plenty of space on the sides that is available to expand the
data into, thus making the data larger and more visible. The data has been
centered vertically and horizontally.

Is there a way aside from margins, to enlarge/expand the same centered data
to fill the sides while maintaining it in one page?
 
F

Fred Smith

While Excel will shrink to fit, there's no corresponding 'expand to fit'.
However, you can achieve the same effect. Just make your source data large
(for example, by increasing the font size). In Page Setup, select Fit to one
page wide and one tall. Excel will then fill the page, no matter the
orientation.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top