Best Ways To Unprotect Excel Sheet

By going through this blog carefully, you shall get to know about the different ways for unprotecting sheets within MS Excel in Windows and Mac operating systems.

Unprotect Excel Sheet

Methods for unprotecting an Excel sheet

By using MS Excel

  1. Firstly, start workbook that has the protected sheet in MS Excel. This shall be done by doing a double click on the file on the system.
  2. Then, right-click the tab of the protected sheet. It shall result in opening the pop-up menu.
  3. After that, press on Unprotected Sheet. Note that in case the sheet is not secured by the password, then it shall unlock by itself. And if not, then it shall ask to put the password in the prompt.
  4. Next, put the password, then press on OK. Remember the password that you put if it is correct, then the sheet shall become unprotected.

Upload to Google Sheets

  1. Firstly, visit drive.google.com in the web browser.

Note: In case you have your own Google account, then you may use Google Sheets for taking out security from every sheet in the workbook.

  • Follow instructions given on display for logging in if not log in till yet.
  • Then, press +New. It shall be towards the above at the left-hand side of the screen.
  • After that, press File Upload. This shall take you to the system’s Open panel.
  • Next, choose the Excel file that you wish to edit and press open. This shall upload your data to Google Drive.
  • Then, double-click Excel file in Google Drive of yours. You need to move downwards for searching it most probably. This shall open a file preview.
  • After that press Open with menu-located at the above of the preview. Look that a menu shall get expanded.
  • Next, press on Google Sheets.
  • Download the file to the system one more time. If you wish to continue to work on the MS Excel file instead of Google Sheets, you will be able to download the recently-unprotected version of the workbook by going through the given below steps:
  • Firstly, press File menu. It shall be towards the above at the left-hand side corner of the sheet.
  • Then, press on Download As.
  • After that, press on MS Excel (.xlsx).
  • Next, choose a folder for saving the file.
  • Lastly, press on Save for downloading the file.

Hope you have been able to unprotect an Excel sheet after going through this blog step by step.

Edward Lewis  is a Microsoft Office expert and has been working in the technical industry since 2002. As a technical expert, Edward has written technical blogs, manuals, white papers, and reviews for many websites such as office.com/setup.

 

Source : Best Ways To Unprotect Excel Sheet

 

 

 

Comments are closed