Photos & storage

Fit the spreadsheet to one page wide, not one unreadable page

Fit an Excel table to one page wide while letting rows continue, then check text size, paper format and repeated headings before printing.

A worksheet with two hundred rows fits on one sheet of paper, but the text is too small to read. The scaling setting did its job. The problem is asking both the width and the height to fit a single page.

In desktop Excel, try a width of one page with the height left automatic. The columns can stay together while the rows continue onto further pages. Compare portrait and landscape in print preview. If the table is still unreadable, allow more width or prepare a simpler print copy instead of shrinking it further.

A stock list might need only item, quantity and location on paper. Keep the original workbook and its calculation notes intact. Omit unnecessary columns only from a separate copy prepared for this printout, and check that its values remain correct.

Inspect the smallest text, the last column and the final row. Where your edition supports it, repeat the heading rows on later pages so page three still makes sense. Confirm the paper size: changing from A4 to another format can change the layout. Print a representative page before sending the full job.

Sources & further reading

  1. Microsoft — Scale a worksheet
  2. Microsoft — Repeat specific rows or columns on every printed page

Sources support the technical explanations. Examples and suggested checks are editorial guidance.