Tips for helping data fit on one page, or better manage how it looks across multiple pages.

Printing from Excel - 3 useful things to know

When printing from excel, there are common issues that arise. The most common is having data fit on one page, or better manage how it looks across multiple pages. Before printing anything from excel, check these 3 things to reduce multi-page issues.

1: Check your paper size

The US standard for excel is Letter size. If you are printing in Europe the standard paper size in your devices is the ‘A’ system. Often A4.
On the Layout Ribbon, check your paper size is changed from Letter to A4

2: Optimize the fit of your data

Over time the amount of space used up by different columns or rows in excel can drift.
To give your data it’s ‘best fit’.
Click the triangle between col A and row 1 to highlight whole sheet. On the home ribbon, choose the format dropdown and auto fit column widths and/or heights

3: Turn on ‘Print Titles’

This feature ensures that if data does need to be spread across a few sheets that the headings of the data are repeated as needed.

To create print titles.

1. Select the Page Layout Ribbon
2. Click on the Print Titles button
3. Select the Rows to Repeat at Top field

1. Point to the left of the row you want to use as a Print Title. The cursor changes to an arrow. Select the row. The reference is added to the Rows to repeat at top field. Select OK.

Happy Exceling!

---