Print Form on ONE page instead of 3+ ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1092139%22%20slang%3D%22en-US%22%3EPrint%20Form%20on%20ONE%20page%20instead%20of%203%2B%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1092139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20to%20print%20forms%20people%20submit%20individually%20(not%20summarized%20responses%20in%20Excel)%2C%20but%20there%20is%20so%20much%20wasted%20space.%26nbsp%3B%20The%20simple%20form%20I%20have%20should%20easily%20be%20able%20to%20fit%20onto%20one%20side%20of%20one%20piece%20of%20paper%2C%20but%20as%20is%20prints%20out%20as%203%20or%20more%20pages%2C%20depending%20on%20how%20much%20people%20type.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAny%20idea%20if%20or%20how%20this%20can%20be%20accomplished%3F%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1092139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1093311%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20Form%20on%20ONE%20page%20instead%20of%203%2B%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1093311%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F506841%22%20target%3D%22_blank%22%3E%40North8425%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20printing%20from%20within%20the%20Form%20responses%20tab%20itself%3F%20There's%20a%20%3CSTRONG%3EView%20results%3C%2FSTRONG%3E%20button%20(%3CSTRONG%3EForm%3C%2FSTRONG%3E)%2C%20and%20%3CSTRONG%3EReview%20answers%3C%2FSTRONG%3E%20button%20(%3CSTRONG%3EQuiz%3C%2FSTRONG%3E)%20that%20then%20shows%20%3CEM%3Eindividual%20responses%3C%2FEM%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20there%20you%20can%20click%20onto%20the%20%3CSTRONG%3E...%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EPrint%20response%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163966iAB11A3ADB422C6F0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20200107093703380.png%22%20title%3D%22capture20200107093703380.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20spreads%20the%20questions%2Fanswers%20out%20so%20it%20fits%20the%20page%20better.%20You%20an%20also%20adjust%20how%20much%20you%20want%20to%20see%20on%20the%20page%20in%20the%20printer%20options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163968i143E8FC806639D08%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20200107093924960.png%22%20title%3D%22capture20200107093924960.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20spreadsheet%20option%20could%20work%20with%20some%20manipulation%20but%20I%20think%20this%20is%20the%20easiest%20if%20you%20are%20just%20wanting%20to%20print%20individual%20responses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1094480%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20Form%20on%20ONE%20page%20instead%20of%203%2B%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1094480%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20this.%26nbsp%3B%20It's%20what%20I%20originally%20tried%20and%20it's%20what%20spreads%20it%20out%20to%203%20pages.%26nbsp%3B%20(See%20screen%20shot%20below).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20other%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164076i32D6AAFE93217448%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled-5.png%22%20title%3D%22Untitled-5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1095728%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20Form%20on%20ONE%20page%20instead%20of%203%2B%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095728%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F506841%22%20target%3D%22_blank%22%3E%40North8425%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20certainly%20not%20ideal%20to%20have%20that%20happening.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20try%20to%20play%20through%20trial%20and%20error%20with%20%3CEM%3EScale%3C%2FEM%3E%20and%20%3CEM%3EPages%20per%20sheet%3C%2FEM%3E%20under%20%3CSTRONG%3EMore%20settings%3C%2FSTRONG%3E%20to%20see%20if%20you%20can%20get%20a%20better%20fit%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%2C%20the%20only%20other%20workaround%20I%20can%20think%20of%20would%20be%20to%20mailmerge%20the%20Excel%20doc%20with%20a%20Word%20doc%20that%20is%20formatted%20in%20a%20userfriendly%20way%2C%20and%20then%20print%20those%20off.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098931%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20Form%20on%20ONE%20page%20instead%20of%203%2B%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098931%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20in%20Forms%20Pro%3F%20I'm%20using%20Forms%20Pro%20for%20the%20advanced%20survey%20capabilities%20and%20branching%20rules%20that%20aren't%20available%20in%20Forms.%20However%2C%20it%20seems%20that%20they%20have%20eliminated%20the%20%22View%20Results%22%20and%20%22Review%20Answers%22%20buttons.%20I%20want%20to%20be%20able%20to%20print%20everything%20out%20or%20create%20a%20PDF%20of%20one%20individual's%20survey%20responses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJacob%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need to print forms people submit individually (not summarized responses in Excel), but there is so much wasted space.  The simple form I have should easily be able to fit onto one side of one piece of paper, but as is prints out as 3 or more pages, depending on how much people type.  

 
Any idea if or how this can be accomplished?
5 Replies
Highlighted

Hi @North8425 

 

Have you tried printing from within the Form responses tab itself? There's a View results button (Form), and Review answers button (Quiz) that then shows individual responses.

 

From there you can click onto the ... and Print response.

 

capture20200107093703380.png

 

It spreads the questions/answers out so it fits the page better. You an also adjust how much you want to see on the page in the printer options.

 

capture20200107093924960.png

 

The spreadsheet option could work with some manipulation but I think this is the easiest if you are just wanting to print individual responses.

 

Hope that helps?

 

Cheers

Damien

Highlighted

Hi @Damien Rosario,

 

Thanks for this.  It's what I originally tried and it's what spreads it out to 3 pages.  (See screen shot below).

 

Any other ideas?

 

Untitled-5.png

Highlighted

Hi @North8425

 

Yes, certainly not ideal to have that happening.

 

You could try to play through trial and error with Scale and Pages per sheet under More settings to see if you can get a better fit as well.

 

Otherwise, the only other workaround I can think of would be to mailmerge the Excel doc with a Word doc that is formatted in a userfriendly way, and then print those off.

 

Cheers

Damien

Highlighted

Hello @Damien Rosario 

 

Is there a way to do this in Forms Pro? I'm using Forms Pro for the advanced survey capabilities and branching rules that aren't available in Forms. However, it seems that they have eliminated the "View Results" and "Review Answers" buttons. I want to be able to print everything out or create a PDF of one individual's survey responses.

 

Thank you,

 

Jacob

Highlighted

Hi @Jacob_Idowu 

 

I haven't actually used Forms Pro in a while so can't really advise you. It's possible when you do find the print option that the above advice may help but maybe someone else on the forum who uses Forms Pro can chime in for this one?

 

Best wishes

Damien