Excel Yourself: Print all columns one page wide

Excel 2010 has a setting that forces all the columns to be printed one page wide.

In the File Ribbon Tab, under the Print Option, there is a Scaling Option "Fit All Columns on One Page".

 

 

Figure 1

This is useful for landscape reports that have all the months of the year going across the page.

If you would like to achieve the same effect in earlier versions of Excel, you can use the Page Setup dialog Page tab.

 

 

Figure 2

Just delete the entry in the tall box and click OK

Neale Blackwood CPA runs A4 Accounting, providing Excel training, webinars and consulting services.