Setting Print Areas
 

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!

Setting Print Areas
 

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.

"Meredith" wrote:

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!

Setting Print Areas
 

Thank you! I don't know why I didn't think of doing that. Much appreciated.

"tim m" wrote:

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.

"Meredith" wrote:

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!