Fix an Excel Worksheet That Is Locked or Cannot Return to the Original View
Question details
The user needs to restore access to an Excel worksheet or return it to its expected view.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The spreadsheet appears locked, or the user cannot return to the original worksheet page or layout.
- Observed behavior
- The worksheet view or editing functions are unavailable, possibly because of protection, hidden content, frozen panes, split windows, or file permissions.
Check the Excel version and confirm whether the file is saved locally or on OneDrive or SharePoint. On the Review tab, look for Unprotect Sheet or Unprotect Workbook, and note whether a password is requested.
Check worksheet protection and restore the normal Excel view
Use this diagnostic path when the worksheet is locked or its layout appears different from the original.
A locked worksheet may be protected at the sheet or workbook level. A view that looks incomplete may instead be caused by hidden rows, hidden columns, frozen panes, or split windows.
Open the file in Excel, select the Review tab, and choose Unprotect Sheet. Enter the password if Excel requests one.
On the Review tab, choose Protect Workbook or Unprotect Workbook, depending on the Excel version. If Unprotect Workbook is shown, select it and enter the required password.
Select the entire worksheet by clicking the triangle above row 1 and left of column A. Open Home > Format > Hide & Unhide, then choose Unhide Rows and Unhide Columns.
Open the View tab and select Freeze Panes > Unfreeze Panes. If the worksheet is divided into sections, select View > Split to turn off the split.
Use the sheet tabs at the bottom of the Excel window. If a sheet tab is missing, right-click any visible sheet tab, choose Unhide, select the worksheet, and click OK.
Verify OneDrive or SharePoint access and file history
Use this option when the workbook is stored online, opens as read-only, or changed views after synchronization.
Use WPS Office to Open and Edit Excel Workbooks in a Familiar Interface
If you need a lightweight alternative for everyday spreadsheet work, WPS Office provides a familiar interface for opening, editing, and saving Microsoft Excel files. It supports common XLSX and XLS workflows, although it cannot remove a password or permissions restriction imposed on a protected Excel file.
- 1. Install WPS Office: Download and install WPS Office, then open the spreadsheet module from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open from the WPS Office home page and choose the XLSX or XLS file from your computer.
- 3. Check worksheet settings: Use the worksheet and View menus to inspect protection, hidden rows or columns, freeze panes, and split-window settings.
- 4. Save in an Excel-compatible format: Choose Menu > Save As and select Excel 2007-365 Workbook (*.xlsx) or Excel 97-2003 Workbook (*.xls) when sharing the file with Microsoft Excel users.

Frequently Asked Questions
How can I tell whether an Excel worksheet is protected?
Open the Review tab and look for Unprotect Sheet. If that command is available, the worksheet is protected and may require a password before you can edit locked cells.
Why can I not see part of my Excel worksheet?
Rows or columns may be hidden, or the window may have frozen panes or a split view. Select the whole sheet, then use Home > Format > Hide & Unhide to show rows and columns, and View > Freeze Panes or View > Split to restore the window layout.
How do I restore a worksheet tab that is missing?
Right-click any visible worksheet tab, select Unhide, choose the missing sheet, and click OK. If Unhide is unavailable, the workbook may be protected or the sheet may not exist in that file.
What should I do if an Excel file on OneDrive opens as read-only?
Check the file's Share or permissions settings in OneDrive or SharePoint and confirm that your account has edit access. You can also review Version history or save an authorized local copy for editing.
Can WPS Office unlock a password-protected Excel workbook?
No. WPS Office can open and edit compatible Excel files when you have the required access, but it cannot legitimately remove a worksheet or workbook password or bypass OneDrive and SharePoint permissions.




