Others

How to Create a Multiple-Choice Quiz Faster in Microsoft Forms

John Wilson Oct 16, 2026 869 views

Question details

The user wants to speed up the creation of multiple-choice vocabulary quizzes because they are struggling to copy answer choices across multiple questions.

How to Create a Multiple-Choice Vocabulary Quiz Faster in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating repetitive multiple-choice questions, such as a vocabulary test, where similar or identical options are needed.
Observed behavior: The process is overly time-consuming because Microsoft Forms lacks a built-in command to duplicate questions or instantly copy the same answer choices across multiple quiz items.

Before you start

Open your Microsoft Forms project in your web browser and prepare a blank spreadsheet file (like Excel or WPS Spreadsheet) to organize your answer choices.

Solution 1Recommended

Use a Spreadsheet to Copy and Paste Multiple Choices

Since Microsoft Forms lacks a native option to duplicate choices, copying a vertical list from a spreadsheet and pasting it into the first option box is the fastest workaround to populate your quiz instantly.

By utilizing the grid layout of a spreadsheet, Microsoft Forms automatically reads each row as an independent answer choice. This prevents you from having to type out options one by one for every single question.

Prepare your list in a spreadsheet

Open a spreadsheet application like Microsoft Excel or WPS Spreadsheet. Type each of your vocabulary choices into a single column, with one choice per row.

Copy the answer choices

Highlight all the cells containing your vocabulary options. Right-click and select 'Copy', or press Ctrl+C (Windows) / Cmd+C (Mac) on your keyboard.

Add a new question in Forms

Switch back to your Microsoft Forms quiz. Click on 'Add new' and select 'Choice' to create a new multiple-choice question.

Paste into the first option

Click directly inside the text box for 'Option 1'. Press Ctrl+V (Windows) / Cmd+V (Mac) to paste the copied cells. Forms will automatically split each spreadsheet row into separate answer choices.

Use a Spreadsheet to Copy and Paste Multiple Choices

Advanced Alternatives: For highly complex or fully reusable quizzes, consider building your form using Microsoft Power Apps, though this requires more technical setup. You can also submit a feature request for native question duplication through the Microsoft Forms Feedback Portal.

Free Microsoft Office alternative

Manage Your Quiz Data Seamlessly with WPS Office

While you build your quiz in Microsoft Forms, you can easily organize your vocabulary lists and answer choices using WPS Spreadsheet. It is a powerful, free alternative to Microsoft Excel that perfectly bridges the gap for data preparation.

1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
2. Open WPS Spreadsheet: Launch the application and create a new blank workbook to start organizing your quiz data.
3. Draft and Copy: Type your vocabulary options in a vertical column, highlight the cells, and copy them directly into your web-based Microsoft Form.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless data copying.Ideal for drafting and saving large vocabulary lists to reuse across multiple quizzes.Lightweight, fast, and completely free to download and use.Familiar tabbed interface makes it incredibly easy to learn.

microsoft office alternative - wps office

Frequently Asked Questions

Can I duplicate an entire question in Microsoft Forms?

Currently, Microsoft Forms does not support duplicating a question along with its answer choices with a single click in standard quizzes. You must create a new question and manually paste your prepared choices from a spreadsheet.

Why do my pasted options appear in a single line instead of separate choices?

This happens if you copy plain text from a standard document where choices are separated by commas or spaces. To fix this, always copy your options from a spreadsheet column where each choice sits in its own row. Forms relies on the spreadsheet's line breaks to separate the options.

How can I reuse the same answer choices for future quizzes?

The best approach is to save your vocabulary lists or standard answer choices in a dedicated spreadsheet file. When creating a new Microsoft Forms quiz, open that spreadsheet, copy the needed list, and paste it directly into your new question's options.

Office Quick Solutions