This project has moved. For the latest updates, please go here.

Format the Excel Worksheet

Jul 26, 2012 at 8:25 PM

Good afternoon,

 

I was wondering if there is a way to format an excel worksheet to be landscape, format the sheet to print on one page, and lastly how to automatically resize the columns to its contents..

 

Thanks in Advance

Sal

Editor
Jul 26, 2012 at 8:40 PM

Use the Worksheet.Printersettings.Orientation property and Worksheet.Columns(i).AutoFit method.


 

 


Jul 26, 2012 at 8:51 PM

Thank you