lets say i have sally typed in rows 1-5, bob in rows 6-10, and john in rows
11-15. how can i work it so excel automatically inserts a page break after
each name in the cell changes. in other words a page break between sally and
bob, bob and john.

this spreadsheet is massive!

please help!