Office Settings & Configuration

Fix an Excel Worksheet That Is Locked or Cannot Return to the Original View

Amos GikundaAmos Gikunda Nov 12, 2026 871 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Unprotect the worksheet

Open the file in Excel, select the Review tab, and choose Unprotect Sheet. Enter the password if Excel requests one.

2
Unprotect the workbook structure

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.

3
Show hidden rows and columns

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.

4
Clear frozen panes or split windows

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.

5
Return to the intended worksheet

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.

Password or permission required: If Excel requests a protection password, the file owner or administrator must provide it. Do not alter or bypass protection without authorization.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open the spreadsheet module from the WPS Office home screen.
  2. 2. Open the Excel workbook: Select Open from the WPS Office home page and choose the XLSX or XLS file from your computer.
  3. 3. Check worksheet settings: Use the worksheet and View menus to inspect protection, hidden rows or columns, freeze panes, and split-window settings.
  4. 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.
Open and edit common Excel XLSX and XLS files with a familiar spreadsheet interface.Use a lightweight office suite for everyday worksheet editing and view adjustments.Work with sheet tabs, hidden rows and columns, freeze panes, and related spreadsheet settings.Maintain compatibility with Microsoft Excel XLSX and XLS formats when sharing files.
microsoft office alternative - wps office

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.