We’ve all had those moments where we print off a document from Excel and find that our spreadsheet annoyingly sits across one and a bit pages, rather than neatly across one page. Rather than trying to rearrange your graphs and tables, there is a quick and easy way of making sure the document fits across one page.

In Excel 2003, go to the File menu, select Page Setup. On the Page tab, make it so that it reads: Fit to 1 page(s) wide by __ tall. (Just delete the number before ‘tall’ so the __ is intentionally blank), and click OK. Excel will interpret the settings as: Fit to 1 page wide by ‘as many pages as necessary’ tall. In Excel 2007, this same setting is located by clicking on the Page Layout tab and selecting the Page Setup menu.