ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enlarge printing to fit whole page (https://www.excelbanter.com/excel-discussion-misc-queries/131720-enlarge-printing-fit-whole-page.html)

Stove79

Enlarge printing to fit whole page
 
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?

Gord Dibben

Enlarge printing to fit whole page
 
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?




All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com