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


On Wed, 21 Feb 2007 12:31:00 -0800, Stove79
wrote:

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?