Excel Yourself: Print all columns one page wide

Excel Yourself

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

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

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.

How-to articles, sample spreadsheets and more

Excel yourself

Combine annual and monthly data in Excel with these simple steps


Making data relationships work

Easy steps to make data Relationships work in Excel


Excel Yourself

Easy tips for matching salary to job class in Excel