WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to unlock excel file

July 26, 2022
7.0K Views

Have you ever tried to open an Excel file and received the message File is locked and cannot be opened? This can be a frustrating experience, especially if you need to access the information in the file

There may come a time when you need to unlock an excel file. Perhaps you have forgotten the password, or maybe the file has been encrypted by someone else. No matter what the reason, there are several ways to unlock an excel file. In this article, we will discuss how to do it using three different methods. We will also provide step-by-step instructions on how to complete each method. Let's get started!

How To Unlock Excel File: First Method

With password protection:

1. First open the file you want to unlock by Using WPS Office to open the spreadsheet.

A then Click the Review tab.

If you try to enter the data you will not be able to enter the data in sheet because it is locked.

2. Click on the Unprotect Sheet button option.

Once you click pop-up Unprotect Sheet dialog box will appear, enter the password you set before, and then click OK.

3. Once you click ok the document or the excel sheet will be unprotected means that it will be unlocked and now you can add any data to the sheet.

How To Unlock Excel File: Second Method

If the sheet is locked but there is no password.

1. First open the file you want to unlock by Using WPS Office to open the spreadsheet.

A then Click the Review tab.

If you try to enter the data you will not be able to enter the data in sheet because it is locked.

2. Click on the Unprotect Sheet button option.

3. As you click the unprotect sheet your sheet is ready to use right now that you can add data now to any cell or perform any function of WPS excel and manage your data.

How To Unlock Excel File cells?

1. Open the excel file using the WPS excel and then select the review option.

2. Once you open the WPS excel sheet select the cell you want to unlock.

3. Now click on the lock cell option so that the cells which was lock can be unlocked.

Unlocking an Excel file consists solely of these three steps. We sincerely hope that you found this information to be informative about how to unlock excel file.

If, on the other hand, you are interested in learning more about the WPS office, I would like to direct your attention to the official website of the WPS Academy. The free version of WPS Office, which can be downloaded from this website, enables users to make changes to a variety of file types, including PDFs, Word spreadsheets, and PowerPoint presentations.

Remember that adopting a few precautions can go a long way toward preventing locked files from occurring at all in the first place! Thank you very much for reading.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.