eirikdaude
Board Regular
- Joined
- Nov 26, 2013
- Messages
- 93
- Office Version
- 365
- Platform
- Windows
Now this might be a very simple question, but some cursory internet searches didn't provide any answers.
Anyway, my problem is this. I have a table which I want to fit to the size of the page it is printed on. In my case that means enlarging it somewhat.
I tried to go to Page Layout > Expanding Scale To Fit > Check Fit to 1 pages wide by 1 pages tall, but apparently when Microsoft writes "Fit to" they actually mean "Shrink to", because my print area is still much smaller than the actual page (see attached image of the print preview)
Is there any way to automatically enlarge the print are to fit the page, or am I out of luck? If using VBA is the only way to do this, I'd be open to such a solution, but ideally I'd want to avoid it.
Anyway, my problem is this. I have a table which I want to fit to the size of the page it is printed on. In my case that means enlarging it somewhat.
I tried to go to Page Layout > Expanding Scale To Fit > Check Fit to 1 pages wide by 1 pages tall, but apparently when Microsoft writes "Fit to" they actually mean "Shrink to", because my print area is still much smaller than the actual page (see attached image of the print preview)
Is there any way to automatically enlarge the print are to fit the page, or am I out of luck? If using VBA is the only way to do this, I'd be open to such a solution, but ideally I'd want to avoid it.
