Expanding Excel to fit on a page

Welcome to the Forum Kengregau2!

It is really hard to imagine what you have from this description.

Your title refers to expanding, but there is no mention of that in your description. When you set up Page Layout with pages wide and pages tall, it is a constraint, not scaling. That is, Excel will shrink the page to fit to the specified layout, but it will not expand it to fill. If you want your page to expand you have to manually set "Adjust to ____% normal size".

If you do not constrain the page layout, how many pages wide and how many tall are printed?

At what points do you manually set page breaks? What do you mean that it won't let you have three pages? If you set two page breaks, you will get (at least) three pages.

I suggest you attach a copy of your file, and tell us exactly what you would like to see on the printout. See yellow banner at the top of the page.

You seem only to have one page break imposed, and there's not enough stuff to warrant three pages, anyway. Print view looks fine - no squashed data or fonts. You do have a massive header margin, otherwise I do not see any issues. Is it because of the printer you are using and its default set-up? Is it set to A4 portrait?

Originally Posted by Kengregau2

and I would like page 1 to fill the whole page ...

Any clues , please - thanks for your help - kenAttachment 853655

Put the page break where you want it? That is, lower down? Why would you want the table to be stretched to fit? Would look awful. Maybe just let Excel decide where the page break should be?

I put/changed formulas in column A and D

Please Login or Register  to view this content.

Now you don't see numbers 47 - 68 and all fits on one page.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.