Others

How to Fix Microsoft Forms Copying Excel Row Formatting in OneDrive

Maira Mehtab Sep 27, 2026 868 views

Question details

The user needs to prevent new response rows in an Excel workbook linked to Microsoft Forms from improperly inheriting manual color formatting from the previous row.

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Collecting survey or quiz responses into an Excel workbook hosted on OneDrive where manual formatting is applied.
Observed behavior: New rows populated by Microsoft Forms inherit manual background colors or formatting from the preceding row instead of adopting the standard Excel table formatting.

Before you start

Verify whether the inherited color is due to manual formatting or conditional formatting, as the troubleshooting steps differ significantly for each scenario.

Solution 1Recommended

Create the Form Directly in Microsoft Forms

Bypass the OneDrive integration defect by generating the form from the Microsoft Forms portal rather than creating it from inside OneDrive.

Testing indicates that the formatting inheritance defect specifically occurs when the form is created in OneDrive and the linked Excel file is stored there. Creating the form directly via the Microsoft Forms interface prevents the issue.

Open Microsoft Forms

Navigate to forms.office.com in your web browser and log in with your Microsoft account.

Create a New Form

Click on the 'New Form' or 'New Quiz' button to build your form directly within the Forms interface rather than initiating it from a OneDrive folder.

Link to a New Excel Workbook

Once responses are collected, navigate to the Responses tab and select 'Open in Excel' to generate a fresh workbook that will not inherit manual formatting from previous rows.

Solution 2

Check and Adjust Conditional Formatting Ranges

If you are using conditional formatting instead of manual colors, ensure the rule applies to the entire column so new rows are formatted correctly.

Solution 3

Report the Formatting Defect to Microsoft

Since the manual formatting inheritance is a known functionality defect with OneDrive-linked forms, reporting it helps Microsoft prioritize a software fix.

Free Microsoft Office alternative

Switch to WPS Office for Seamless Spreadsheet Management

If you are tired of dealing with integration defects and formatting glitches in Microsoft Excel and OneDrive, WPS Office offers a powerful, lightweight alternative. It provides excellent compatibility with Microsoft formats and includes advanced data collection tools without the syncing errors.

1. Download WPS Office: Visit the official WPS Office website and click the free download button for your operating system.
2. Install and Launch: Run the installer package and open WPS Spreadsheet once the installation is complete.
3. Open Your Existing Files: Simply open your existing .xlsx workbooks in WPS Office to continue working flawlessly without formatting glitches.

100% compatible with Microsoft Excel (.xlsx) and other Office formats.Free, lightweight, and fast spreadsheet processing with an intuitive UI.Stable and predictable table formatting without unwanted row inheritance.Seamless migration process with no learning curve required.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel table inherit the wrong color when a new Form response is submitted?

When a form is created in OneDrive and linked to an Excel file stored there, a known defect causes new rows to inherit the manual formatting (like background colors) of the row directly above it, rather than applying the default table style.

Can conditional formatting fix the issue with Microsoft Forms?

Yes, if you use conditional formatting instead of manual color coding, new rows will follow the designated rules automatically. Just ensure that the 'Applies to' range in the Conditional Formatting Rules Manager spans the entire column.

Is there a way to disconnect the Excel workbook from Microsoft Forms to stop the formatting issue?

Disconnecting the workbook will stop the live sync of new responses altogether. If you need live responses without the formatting bug, the best workaround is to recreate the form directly at forms.office.com rather than originating it from inside OneDrive.

Office Quick Solutions