Others

Can You Hide Questions from Respondents in Microsoft Forms?

Kushani NimanthikaKushani Nimanthika Oct 22, 2026 872 views

Question details

The user wants to know if it is possible to add questions to a Microsoft Form that are visible only to editors and hidden from respondents.

How to Handle Hidden Questions in Microsoft Forms
Product
Microsoft Forms
Device & OS
not provided
Scenario
Creating a form where administrative fields or internal tracking questions need to be kept entirely hidden from the people filling it out.
Observed behavior
Microsoft Forms currently displays all added questions to the respondents; there is no native feature to make specific questions visible only to form editors.
Before you start

Determine whether the hidden information must be captured at the exact time of form submission, or if it can be added later by your team during an internal review process.

Solution 1Recommended

Use Power Automate and Excel for Internal Tracking

Since native hiding isn't supported, use an automated workflow to send form responses to a spreadsheet where editors can add hidden columns.

This method completely separates the respondent experience from the editor's administrative process. By capturing the data elsewhere, your team can evaluate submissions in a private environment.

1
Create the respondent-facing form

Build your Microsoft Form including only the questions you want your respondents to see and answer.

2
Prepare your internal tracking sheet

Create a new Excel Online spreadsheet or SharePoint List. Set up columns for the respondent's answers, plus additional columns for your internal 'hidden' questions.

3
Set up an automated workflow

Open Power Automate and create a new automated cloud flow. Choose the trigger 'When a new response is submitted' for Microsoft Forms.

4
Map the response details

Add the 'Get response details' action, then add an action to 'Add a row into a table' in Excel (or create a SharePoint item). Map the form answers to the corresponding columns.

5
Evaluate responses internally

Form editors can now view the captured responses in the spreadsheet and manually fill in the internal-only columns without respondents ever seeing them.

Use Power Automate and Excel for Internal Tracking
Data Privacy: This ensures that sensitive internal evaluations or grading matrices are never accidentally exposed through the form link.
Free Microsoft Office alternative

Discover WPS Office for Managing Exported Form Data

While Microsoft Forms lacks certain field visibility settings, you can easily manage your exported results, internal tracking spreadsheets, and data reports using WPS Office. It is a lightweight, fully compatible alternative to Microsoft Office.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your computer.
  2. 2. Open Exported Form Results: Export your Microsoft Forms results as an Excel file, then open it instantly using WPS Spreadsheets.
  3. 3. Add Hidden Evaluation Columns: Add internal notes, color-coding, and custom evaluation columns to your spreadsheet securely.
Seamlessly open and edit exported Microsoft Excel (.xlsx) results from your forms.Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Free, lightweight, and incredibly fast to install on any device.Familiar user interface makes analyzing form submissions and survey data a breeze.
microsoft office alternative - wps office

Frequently Asked Questions

Can I hide a question based on a previous answer in Microsoft Forms?

Yes, you can use branching logic to hide or show questions depending on the respondent's previous answers. However, these questions are still part of the respondent experience if triggered, meaning they are not completely hidden for editor-only use.

Will Microsoft add a hidden question feature to Forms?

The feature has been highly requested on the Microsoft Feedback Portal, but there is no official release date yet. Voting for the feature request increases the likelihood of it being prioritized by the development team.

How do I securely track internal notes on a form response?

The most secure way is to export the Microsoft Forms results to a spreadsheet or link the form to a SharePoint list using Power Automate. Once the data is moved, you can safely add columns for internal notes that the respondent cannot access.