Enlarge printing to fit whole page

G

Guest

Can Excel format my document to fit a whole page regardless of size. For
instance if I typed "A" in cel A1, can I get the "A" to fit the entire page?
 
G

Gord Dibben

First.....let's set the rules.

What do you consider as a "page"?

The visible window area?

The entire worksheet, which would consume a great amount of resources.

To enter "A" in all visible cells select A1 to bottom corner of window(maybe
O34?).

Enter "A" in A1 and hit CTRL + ENTER

Could also be done with event code using Windows(1).VisibleRange property if you
desire that.


Gord Dibben MS Excel MVP
 

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

Similar Threads

How to make a page fit the whole printed page 1
Excel 2007 - Scale To Fit 1
How do I fit to 1 page on entire workbook 2
Excel Fit to page print options in Excel 1
Save as PDF not same size as Print and Print Preview in Excel 4
Make more than one graph fit the page 3
Pinting to fit 11
How do I print fit to page as in Lotus 97 2

Top