Excel for the Web Pastes Only Formatting into Protected Sheets
Question details
The user needs to paste cell contents from a local file into unlocked cells on a protected worksheet in Excel for the web.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- Copying data from a local file into a protected workbook stored in OneDrive or SharePoint using an organizational Microsoft 365 account.
- Observed behavior
- Ctrl+V pastes only formatting into unlocked destination cells on a protected worksheet. Ctrl+Shift+V pastes values correctly, and Ctrl+V works on an unprotected sheet. The behavior occurs across multiple browsers.
Confirm that the destination cells are unlocked and that the worksheet is protected. Decide whether you need only the copied values or also formulas and formatting, because the values-only workaround does not preserve formulas.
Use Ctrl+Shift+V to paste values into unlocked cells
Use this temporary workaround when you need cell values without copied formulas or formatting.
In the local source file, select the cells you need and press Ctrl+C.
In Excel for the web, select an unlocked destination cell on the protected worksheet and press Ctrl+Shift+V.
Select the destination cells and check their contents in the formula bar. Confirm that the expected values were inserted rather than only formatting.
Compare pasting on protected and unprotected worksheets
Use a controlled comparison to check whether worksheet protection is the condition triggering the issue.
Report the protected-sheet paste issue to Microsoft
Use this route if you need normal Ctrl+V behavior restored or the values-only workaround is insufficient.
Try WPS Spreadsheet for Local Excel Workbook Editing
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move to local workbook editing. It does not fix Excel for the web's protected-sheet paste issue; test your workbook's protection and paste behavior before switching your workflow.
Frequently Asked Questions
Why does Ctrl+V paste only formatting even though the destination cells are unlocked?
The reported behavior occurs when worksheet protection is enabled in Excel for the web, even for unlocked cells. The exact cause has not been established. Paste the same data into an unprotected worksheet to check whether protection is the triggering condition.
Will Ctrl+Shift+V preserve my formulas?
No. In this workaround, Ctrl+Shift+V pastes values only. If the source cells contain formulas, their calculated results are pasted rather than the formulas themselves.
Should I move the workbook from SharePoint to OneDrive or change browsers?
Neither change is a confirmed fix: the issue was reported across multiple browsers and in both OneDrive and SharePoint. Testing another SharePoint library can provide useful diagnostic information, but Ctrl+Shift+V is the demonstrated temporary workaround.
Can I temporarily remove worksheet protection to paste normally?
If you are authorized and have any required password, use Review > Manage Protection to turn off protection, then test Ctrl+V. Normal pasting worked on unprotected sheets in the reported case. Restore protection afterward if the workbook requires it.
What should I include in a Microsoft support report?
Include the browser version, the source Office application version if applicable, workbook storage location, and a sanitized sample file. Explain that Ctrl+V pastes only formatting on a protected sheet, Ctrl+Shift+V pastes values, and Ctrl+V works on an unprotected sheet.
