Easy Tech TutsHow to Work With Likert Questions in Microsoft Forms Easily 2026
By Impran M N
Once you've added a Likert grid to a Microsoft Forms survey, getting the most out of it means understanding how to manage the rows and columns and how the data translates when you export it. This guide covers building and maintaining a Likert question and reviewing the resulting data.
01Open the extended field drawer
Click Add New, then tap the More Question Types dropdown to reveal advanced survey assets including Likert.
02Insert the Likert matrix
Select Likert from the list to drop the default grid onto your canvas.
03Write your prompt and scale
Enter your overarching evaluation prompt, then edit the horizontal option columns to define your scale, such as Strongly Disagree to Strongly Agree.
04Add your statement rows
Fill in the vertical statement lines with the specific criteria you want evaluated, using Add Statement to expand as needed.
05Check mobile rendering and require answers
Toggle Required, then preview the grid to confirm the scale text doesn't clip on smaller screens.
Frequently asked questions
How does Likert data appear when exported to Excel?
Each statement typically becomes its own column with the selected scale value recorded per respondent.
Can I reorder statements after I've added several?
You can edit and rearrange statement rows within the question block before publishing.
What's a good number of statements for one Likert grid?
Keeping the list focused avoids overwhelming mobile respondents with a wide grid that's hard to scroll.
Is Likert available in both quizzes and standard forms?
Yes, the Likert question type is available under the extended options in both formats.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
