Document Editing Problems

How to Unlock a Highlighted Cell or Cursor in Excel

Adam DavisAdam Davis Oct 20, 2026 871 views

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.

How to Unlock a Highlighted Cell or Cursor in Excel
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 you start

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.

Solution 1Recommended

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.

1
Open the Review tab

Navigate to the top ribbon menu in your Excel interface and click on the 'Review' tab.

2
Click Unprotect Sheet

Look for the 'Protect' group and click on 'Unprotect Sheet'. If the button says 'Protect Sheet' instead, the worksheet is not currently protected.

3
Enter the password

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.

Remove Worksheet Protection
Lost Password: If you do not know the password, you will need to contact the file owner to grant you editing permissions.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS website to download and install WPS Office for free on your PC or Mac.
  2. 2. Open your spreadsheet: Right-click your locked Excel file, select 'Open with', and choose WPS Office from the list of applications.
  3. 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.
100% compatible with Microsoft Excel formats including .xlsx, .xls, and .csvCompletely free to use for daily spreadsheet editing and data entryNo restrictive subscription locks that suddenly prevent you from typingFamiliar interface ensures zero learning curve when switching from MS Office
microsoft office alternative - wps office

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.