Skip to content

Module 03 · Lesson 08

Why printouts go wrong

Six common problems, six settings.

Printing Excel4 min
What goes wrongThe fix
Last column printed on a separate pageScaling › Fit All Columns on One Page
Header row only on page 1Page Layout › Print Titles › Rows to repeat at top: $4:$4
Empty pages at the endSet Print Area to only the table
Text too small to readUse Landscape or narrow margins instead of Fit Sheet on One Page
Pages not numberedHeader/Footer › Page 1 of ?
Table stuck to the left edgeMargins › Center on page: Horizontally