MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Page Setup

Posted by Karl D'Gama on July 11, 2001 7:29 AM

Could you tell me how to do page setup in Excel. I have a table generated thru ASP and VB Script and store it in an XLS file.
When I do a print preview the table looks very small. I want to be able to make the table occupy the full page.
We use the ExecuteExcel4Macro and the function PAGE.SETUP.
Is there some setting in the PAGE.SETUP function that needs to be made.

Posted by Mark W. on July 11, 2001 8:47 AM

Open the Page Setup dialog using the File | Page Setup...
menu command. Click the "Page" tab and then the
"Fit to..." Scaling radio button. Make sure the
"pages(s) wide..." and "tall" fields are set to 1
then press [ OK ].