Document Editing Problems

Fix Excel When You Can Edit Only a Few Cells

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

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.

Fix Excel When You Can Edit Only a Few Cells
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.
Before you start

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.

Solution 1Recommended

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.

1
Update Office

In Excel, select File > Account > Update Options > Update Now. Install any available updates.

2
Save a new copy

Select File > Save As, choose a location, and save the workbook with a new name.

3
Reopen the copy

Close the workbook, open the newly named file from File > Open, and test editing several cells.

4
Check protection

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.

Update Excel and reopen a newly named workbook
Protected cells: A protected worksheet can allow edits only in unlocked cells. If you do not know the password, ask the workbook owner for access.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in WPS SpreadsheetsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.