Others

How to Use Different Rating Choices for Each Row in Microsoft Forms

Camila Milosovich Oct 9, 2026 869 views

Question details

The user wants to assign different rating-scale choices to individual rows within a single Microsoft Forms question.

How to Use Different Rating Choices for Each Row in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a customized survey or questionnaire requiring unique rating scales for specific items.
Observed behavior: Microsoft Forms applies a fixed set of rating options to all rows within a single rating or Likert question, preventing individual row customization.

Before you start

Since Microsoft Forms restricts a single question to one uniform rating scale, you should plan your survey structure to accommodate multiple individual questions instead.

Solution 1Recommended

Use Separate Rating Questions

Since multi-row questions share one scale, separating them into individual rating questions allows for unique choices per item.

Microsoft Forms does not natively support different rating-scale choices for individual rows in one question. To achieve the desired result, you must break down the single grid question into multiple, standalone rating questions.

Remove the existing Likert question

Select the multi-row Likert question in your form and click the trash can icon to delete it.

Add a new Rating question

Click the '+ Add new' button and select 'Rating' from the available question types.

Customize the scale choices

Adjust the 'Levels' and 'Symbol' settings to match the specific rating scale required for this first item.

Repeat for additional rows

Add another 'Rating' question for the next item, configuring its scale independently as needed.

Provide Feedback to Microsoft: If you require custom row scales in a single grid, consider submitting a feature request through the official Microsoft Forms feedback portal.

Free Microsoft Office alternative

Analyze Your Survey Data Effectively with WPS Office

After collecting your survey responses in Microsoft Forms, you need a reliable tool to analyze the data. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that makes managing spreadsheets seamless.

1. Export Forms Data: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your data.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded .xlsx file to view your survey responses.
3. Analyze and Visualize: Use WPS Spreadsheet's built-in pivot tables and charts to summarize and visualize the collected ratings.

Fully compatible with Microsoft Excel formats (.xlsx, .csv) for analyzing form exports seamlessly.Free and lightweight alternative to the Microsoft Office suite.Familiar user interface ensuring a seamless migration with zero learning curve.Built-in charting and data visualization tools to present survey results professionally.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use branching logic for individual rows in a Likert question?

No, Microsoft Forms only supports branching logic at the question level, not for individual rows within a Likert or grid question.

Is it possible to add a 'N/A' option to a Microsoft Forms rating question?

Standard rating questions (star/number scales) in Microsoft Forms do not have a specific 'N/A' toggle. However, you can use a Likert question or a Choice question to explicitly include 'N/A' as one of the text options.

Will Microsoft Forms ever support different scales per row?

Feature updates depend on user demand. You can submit or vote on this requirement in the Microsoft Forms feedback portal to encourage its development in future releases.

Office Quick Solutions