An Excel worksheet can contain all the right records while its printout omits the newest rows. A saved print area may still end where last month’s list ended. Check the output scope before changing printer drivers.

Use desktop Excel for Windows and select the single worksheet you intend to print. Confirm the first and last required records on screen. Include the columns needed to interpret them, such as the identifier, date and units, rather than printing a set of unexplained amounts.

Set the range and repeated labels

Select the intended cells, then choose Page Layout, Print Area, Set Print Area. Microsoft notes that the area is saved with the workbook. Multiple separate areas print separately, so inspect Page Break Preview if you see unexpected extra pages.

Open Page Layout, Print Titles. On the Sheet tab, set Rows to repeat at top to the heading row or rows, such as $1:$1 for row 1. Use Columns to repeat at left when a wide report needs its identifying column repeated horizontally.

If the title boxes are unavailable, check whether multiple sheets are grouped. Microsoft also documents cell editing, a selected chart or no installed printer as reasons the Print Titles command can be unavailable.

Inspect the entire preview

Check page one, a middle page and the last page. Confirm that the first and final required records appear and that continuation pages have readable headings. Verify the rightmost column too; a missing column can change the meaning of the remaining data.

Do not force a very long list onto one tiny page just to reduce the page count. Judge the result at its intended paper size.

Save the workbook after the settings are correct. On the next reporting cycle, revisit the last record and print area instead of assuming the saved range expanded. If producing a PDF, open that exported file and repeat the scope checks before sharing it.

References: Microsoft: print areas, Microsoft: repeating printed headings.