Fix Excel When You Can Edit Only a Few Cells
Question details
The user needs to restore normal cell editing in an Excel workbook when only a few cells can be edited at a time.

- Product
- Excel for Microsoft 365
- Device & OS
- Windows 10
- Scenario
- Editing cells in an Excel workbook after upgrading to Windows 10 and Microsoft 365.
- Observed behavior
- Excel allows editing in only a few cells at a time instead of allowing normal editing throughout the worksheet.
Check whether the problem occurs in one workbook or in multiple workbooks. If the file opens in Protected View, select Enable Editing only if you trust its source.
Update Excel and reopen a newly named workbook
Use this first to rule out an outdated Office installation or a problem with the current workbook file.
In Excel, select File > Account > Update Options > Update Now. Install any available updates.
Select File > Save As, choose a location, and save the workbook with a new name.
Close the workbook, open the newly named file from File > Open, and test editing several cells.
On the Review tab, check whether Unprotect Sheet or Protect Workbook is shown. If the sheet is protected, select Unprotect Sheet and enter the password if prompted. Check workbook protection as well.

Test Excel in Safe Mode for add-in conflicts
Use Safe Mode if the issue continues after reopening the workbook and checking protection.
Test a new workbook and repair Microsoft 365
Use this to determine whether the issue extends beyond one file and to address a possible Office installation problem.
Edit spreadsheets with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files into WPS, although it does not repair Excel itself.

Frequently Asked Questions
Why can I edit some cells but not others in Excel?
The worksheet may be protected, with only certain cells unlocked for editing. On the Review tab, look for Unprotect Sheet and enter the password if required.
How do I start Excel in Safe Mode on Windows?
Close Excel, press Windows + R, enter excel /safe, and select OK. Open the affected workbook and check whether you can edit cells normally.
What if only one workbook has the editing problem?
Select File > Save As to save it under a new name, then close and reopen the copy. Also check the Review tab for worksheet protection.
Where can I find my Excel version and update channel?
In Excel, select File > Account and look under Product Information for the version, build, and update channel. Include these details if you contact support.




