logo
search
Others

How to Create a Flexible Check Sheet in Microsoft Forms

Bushra ParveenBushra Parveen Sep 28, 2026 868 views

Question details

The user needs to create a checklist in Microsoft Forms where respondents only have to complete a subset of applicable questions (e.g., 3 to 10 out of 12 items).

How to Create a Flexible Check Sheet in Microsoft Forms
Product
Microsoft Forms
Device & OS
not provided
Scenario
Designing a customizable online form or checklist that accommodates varying respondent situations without forcing them to answer irrelevant questions.
Observed behavior
The goal is to allow optional responses, enable the ability to edit submissions later, and dynamically show relevant questions using branching paths.
Before you start

Ensure you are logged into your Microsoft 365 account with access to Microsoft Forms, and have your complete draft of checklist questions ready for configuration.

Solution 1Recommended

Use Branching Logic for Dynamic Question Paths

Direct respondents to specific questions based on their previous answers, completely hiding items that are irrelevant to their specific situation.

Branching is the most effective way to create a flexible checklist because it adapts the form in real-time. Instead of showing all 12 questions, respondents will only see the 3 to 10 questions that directly apply to the choices they make.

1
Access branching settings

Click on the question you want to add branching logic to, then click the 'More options' menu (the three dots icon) located at the bottom right of the question box.

2
Add branching logic

Select 'Add branching' from the dropdown menu to enter the branching configuration view.

3
Configure the conditions

For each possible answer choice, use the dropdown menu to choose which specific question the respondent should jump to next, or select 'End of the form' if no further questions are needed.

Test Your Form: Always click 'Preview' at the top of the page to test your branching paths and ensure respondents are being routed to the correct questions.
Free Microsoft Office alternative

Need a reliable and free Office suite? Try WPS Office

While Microsoft Forms is excellent for online quizzes and surveys, managing the exported data or creating offline, highly customizable check sheets often requires a powerful spreadsheet tool. WPS Office provides a complete, lightweight, and free alternative to Microsoft Word, Excel, and PowerPoint. With seamless format compatibility and a familiar interface, you can easily open, edit, and analyze your form data without costly subscriptions.

  1. 1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the quick on-screen instructions to install the suite on your device.
  3. 3. Open your files: Launch WPS Spreadsheet to open your exported forms data or create complex offline checklists seamlessly.
Fully compatible with Microsoft Office formats (XLSX, DOCX, PPTX)Free and lightweight suite available for PC, Mac, and mobile devicesFamiliar user interface requiring zero learning curveBuilt-in robust spreadsheet tools to analyze your checklist data efficiently
microsoft office alternative - wps office

Frequently Asked Questions

Can I make multiple questions optional at once in Microsoft Forms?

No, Microsoft Forms does not currently support bulk editing for the 'Required' setting. You must click on each question individually and toggle off the 'Required' switch to make them optional.

Why can't I see the 'save and edit' option in my form settings?

The ability to save and edit responses may be restricted by your organization's IT admin policies. Additionally, if the form is set to collect responses anonymously, it prevents tracking user sessions, meaning respondents cannot return to edit previous submissions.

What happens if I use branching on a required question?

The respondent will be forced to answer that mandatory question before they can proceed. Once they answer it, the branching logic will then seamlessly direct them to the appropriate follow-up question based on their choice.