Setting Print Areas

M

Meredith

I currently have a spreadsheet with about 150 rows of data in it. I would
like to print out each row on a separate sheet of paper. Is there a quick
way of doing this? I would rather not set a page break for each page; this
would take a long time. And changing the settings on the page setup menu
does not seem to work. Thanks!
 
T

tim m

In a quick test this seemed to work for me, 'file'...'page setup'...'margins
tab' and I set the bottom margin to 9.75" while leaving the top margin at 1".
I didn't do a print test but in print preview it appeared to force one Row
per sheet printing.
 
Top