The sign-in sheet occupies A1:D24. Working totals in F1:H12 help the coordinator, while the printed copy is for the desk staff.

Set the rectangle that belongs on paper

In Ulet select A1:D24, including the last guest. Choose Page Layout → Print Area → Set Print Area. Save the XLSX to retain the setting.

The print area A1:D24 contains headings and the last guest, with F1:H12 outside it.

Illustrated selection before choosing Set Print Area.

Read the first and last pages

Open View → Page Layout and look for all four headers, the last guest in row 24 and the absence of the totals block. If a late guest goes into row 25, set the area to A1:D25 and inspect the last page again. Check the area boundaries if an extra blank page appears.

The print boundary extends to A1:D25 to include a late guest.

Illustrated last-row check.

Related Microsoft Excel reference