Forum Discussion
Copy and past to Microsoft Form multiple question answers
I was wondering if there was a way to quickly copy and past a list possible answers to a Microsoft Forms multiple choice question. I will often have an Excel list of 50 possible answers in a column. It would be great when building a form if I could select the first possible multiple choice question box and the pasted answers would automatically become different answers. Currently when I past the entire list of 50, it just stretches across one answer.
6 Replies
While there is no specific option to duplicate, you can use this hack:
Type the list of your responses that you'd like to duplicate, one response choice per line into Notepad (or Excel). Select all, copy and paste into the first response choice box of your question, and it should automatically populate the entire list into separate response choices!
- I tried this and it pasted all off the options in the first row.
ChrismaT
I just copy and pasted a list from word into the first option and it populated them into separate answer choices. There were carriage returns between my options. Here's a picture from MS Word.
The only workaround to this I could think of so far is to use a "template" form and just duplicate that--I've observed no way so far to copy/paste multiple choice options so far.
- Hi Kyle
I'm not aware of any way to do that, but maybe another user here might have an idea?
Forms isn't very complex at this time, but the capability may likely be developed down the track.
Best of luck!
Cheers
Damien
