| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting print options globally ? | Excel Discussion (Misc queries) | |||
| Want to set print gridlines as a default setting | Excel Worksheet Functions | |||
| Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
| Set Multiple Print Areas | Excel Discussion (Misc queries) | |||
| Setting up a macro to print? | Excel Worksheet Functions | |||
Linear Mode
