Printing different cells within worksheet on different pages

[Guest]

How can I print different cells within a workbook on different pages? (For
example, I have written plenty of names on the cells within a worksheet and I
want to print each name on separate sheets of paper.)

 

[Guest]

The easiest way may be to set your top and bottom margins so that only one
row is printed per page. File | Page Setup | Margins (pre-2007); for Excel
2007: Page Layout tab, Page setup group, Margins.

Set the bottom margin to a large value such as 7.5 inches. Use Print
Preview to see just what's going to print on each sheet and adjust your
top/bottom margins until you get just one row placed where you want it on the
printed sheets. You can even adjust the margins while in print preview to
keep from having to adjust over and over to get it right.

The other option would be to go in and insert a page break at every row
which would be labor intensive to say the least.