logo
search
File Sharing Problems

How to Hide Latest Responses When Sharing Microsoft Forms Results

Chanuka GeekiyanageChanuka Geekiyanage Sep 28, 2026 868 views

Question details

The user wants to share the visual charts and graphs from Microsoft Forms summary results without exposing the raw comments displayed in the Latest Responses section.

How to Hide Latest Responses When Sharing Microsoft Forms Results
Product
Microsoft Forms
Device & OS
not provided
Scenario
Sharing survey or questionnaire results with stakeholders while keeping individual text responses private.
Observed behavior
The default summary link provided by Microsoft Forms includes a Latest Responses section that exposes raw text comments alongside the aggregate visual charts.
Before you start

Since Microsoft Forms lacks a native toggle to hide the Latest Responses section on the summary page, ensure you have a spreadsheet application installed to process and visualize your exported form data.

Solution 1Recommended

Export Responses to Excel and Generate Custom Charts

Since Microsoft Forms doesn't allow hiding the Latest Responses section, exporting the data to Excel provides full control over what information you visualize and share.

This is the most reliable workaround for presenting your data visually while maintaining strict privacy over individual text comments.

1
Open your Form Responses

Navigate to Microsoft Forms, open your specific form, and click on the 'Responses' tab at the top of the page.

2
Download the data

Click the 'Open in Excel' button to download a complete spreadsheet of all submitted responses.

3
Create custom charts

Open the downloaded file in your spreadsheet software. Select the columns containing the data you want to share, and use the 'Insert Chart' feature to recreate the visual graphs.

4
Share the clean visuals

Copy the generated charts into a new presentation, PDF, or document to share with your stakeholders without including the raw comment data.

Export Responses to Excel and Generate Custom Charts
Complete Control: Exporting your data ensures that stakeholders only see the aggregate metrics and charts you deliberately choose to share.
Free Microsoft Office alternative

Process Exported Form Data Beautifully with WPS Office

While Microsoft Forms limits how you share summaries natively, you can export your responses and seamlessly create professional, comment-free charts using WPS Spreadsheet—a completely free and lightweight alternative to Microsoft Office.

  1. 1. Open the exported file: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
  2. 2. Generate charts: Highlight your data columns, click the 'Insert' tab, and select from a variety of chart types to visualize your results.
  3. 3. Export as PDF: Once your charts are ready, use the 'Export to PDF' feature to create a secure, easily shareable document free of raw comments.
Highly compatible with Microsoft Excel (.xlsx) formats for opening exported form data effortlessly.Create professional charts and graphs easily without exposing raw comments.Free and lightweight with a familiar, user-friendly interface that requires zero learning curve.Includes built-in PDF conversion tools to easily share your final charts.
QA img-9

Frequently Asked Questions

Can I share Microsoft Forms results without names attached?

Yes, you can make a form anonymous by going to Settings and unchecking 'Record name' before distributing it. However, this only hides the respondents' names; their raw text answers will still appear in the Latest Responses section on the shared summary link.

How do I print only the charts from Microsoft Forms?

You can use the 'Print Summary' option located in the Responses tab and choose 'Save as PDF'. To hide the raw comments, you will need to manually exclude the specific pages containing the Latest Responses before sharing or printing the final document.

Is there any way to selectively display comments in Forms?

Currently, Microsoft Forms does not offer a moderation tool or a way to selectively display comments on the shared summary link. Exporting the data to a spreadsheet application is the only reliable method to filter or curate the responses you wish to share.