How to Unlock a Highlighted Cell or Cursor in Excel
Question details
The user is unable to type or edit data in an Excel cell, observing that the cell only becomes highlighted or the cursor appears locked.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to input data, edit existing text, or navigate within an Excel workbook.
- Observed behavior
- When clicking a cell to type, the cell highlights but does not accept keyboard input, suggesting the spreadsheet is protected, the view is locked, or the software requires activation.
Before proceeding, try opening a completely new, blank Excel file to see if you can type in it. If the new file works, your issue is related to file protection; if it doesn't, you may be facing an application activation issue.
Remove Worksheet Protection
Use this solution if you can edit other Excel workbooks but the highlighted cell issue only occurs in one specific file.
Authors often protect worksheets to prevent accidental changes. When a sheet is protected, clicking on a locked cell simply highlights it, and any attempt to type will usually trigger a warning prompt or be ignored.
Navigate to the top ribbon menu in your Excel interface and click on the 'Review' tab.
Look for the 'Protect' group and click on 'Unprotect Sheet'. If the button says 'Protect Sheet' instead, the worksheet is not currently protected.
If the original author secured the document with a password, a dialog box will appear. Type the password and click 'OK' to unlock the cells for editing.

Check Microsoft Office Activation Status
If every single Excel file you open prevents you from typing and highlights the cells instead, your Office subscription may have expired.
Disable Scroll Lock on Your Keyboard
If you are using the arrow keys to move the cursor but the entire spreadsheet moves while the highlighted cell remains locked in place, Scroll Lock is likely enabled.
Edit Spreadsheets Without Activation Limits using WPS Office
If your Microsoft Excel application is locking you out of editing due to activation or subscription issues, switch to WPS Office. It is a fully featured, lightweight, and free alternative that opens all your existing Excel files smoothly.
- 1. Download the software: Visit the official WPS website to download and install WPS Office for free on your PC or Mac.
- 2. Open your spreadsheet: Right-click your locked Excel file, select 'Open with', and choose WPS Office from the list of applications.
- 3. Start editing immediately: Click on any cell to highlight it and simply start typing. WPS Office will process your edits smoothly without requiring costly activation.

Frequently Asked Questions
Why does Excel make a pinging sound when I try to type in a highlighted cell?
This sound indicates that the cell you are trying to edit is locked and the worksheet is protected. You must go to Review > Unprotect Sheet to make changes.
Can I edit a protected Excel cell if I don't have the password?
No, Excel's security features require the correct password to unprotect a sheet. You will need to request the password from the creator of the workbook.
Why is only a specific range of cells locked while I can type in others?
Excel allows authors to lock specific cells while leaving others unlocked for data entry. The author has applied formatting to lock those specific highlighted cells before protecting the worksheet.




