How to Unprotect an Excel Sheet
Unprotecting an Excel sheet is surprisingly easy. If your Excel sheet is password protected and you do not know the password, there is no way that you can unprotect the sheet in that particular workbook – but you can create a new workbook which will contain exactly the same formulas, formatting and values that will not be protected and will be editable.
How to Unprotect a Non-Password Protected Excel Sheet
- Open up the Excel document.
- Click on the “Review” tab.
- Click “Unprotect Sheet” or “Unprotect Workbook.”
How to Unprotect a Password Protected Excel Sheet
- The first way to do this is to copy and paste the contents into a new workbook. This sounds very simple and is very simple but most people do not even consider this option due to its simplicity.
- In the case that your Excel sheet is password protected and you cannot select the cells on the Excel sheet, you are going to need to make use of a web-based spreadsheet solution – namely Google Spreadsheet.
- Upload your spreadsheet into Google Spreadsheet.
- You can now already edit the file, from within Google Spreadsheet. If you wish to make a copy that you can also edit in Excel, simply export the spreadsheet into an .xls file. Simple.
How to Remove Protection from an Excel Sheet using Google Docs
Another way to remove protection from an Excel sheet without the password or access to the document creator is to import it into the Google Docs Spreadsheet program, which will remove protection once the document is imported.
Step 1 – Create a Google account at gmail.com or use an existing one.
Step 2 – Log into Google Docs with a google account at: docs.google.com by entering a login name and password.
Step 3 – Click “Upload” then the “Select Files to Upload” option on the subsequent window.
Step 4 – Use the Google file chooser to locate the spreadsheet file to be uploaded and that protection will be removed from.
Step 5 – View and edit the data file after it is successfully imported into Google Docs.
|
|
Comments (1)
Leave a Reply
- Microsoft Excel Password Recovery
Microsoft Excel documents can utilize three passwords: Password to open Password to modify Protect sheet or Protect workbook Password to Open The Password to open requires a user to enter a password to view the document. When the user sets a Password to open, the entire Microsoft Excel document is encrypted with the RC4 stream [...]...
- Spreadsheet Software
Spreadsheet software is very important in the modern world of records and organization. Spreadsheet software allows users to make lists, organize budgets, perform calculations, and much more. While not all spreadsheet software is the same, the general goal is to provide the user with a simplified way of organizing and presenting information. This article will [...]...
- How to Import Data in Excel
Importing data to MS Excel is the process of transferring data from other database sources and converting it into .xls format. This process eliminates the need to manually enter every item into a new Excel worksheet. Importing data therefore saves the user a lot of time and reduces human error. The source data is called [...]...
- Excel Tutorials
Working With Text & Numbers Tutorial A tutorial that shows how to use excel & covers all basics in just a few easy steps Steps: To begin open Microsoft Excel. Then, if necessary, click on the in the upper right corner of the task pane to close the task pane. The screen shown here will [...]...
- How to Create Excel Macros
A macro is a template of commands and functions which can be used to facilitate automation of tasks you repeatedly do in Microsoft Excel. You can specify if a macro is available only to a certain workbook or to all Microsoft Excel files. Set the Security Level to Medium or Low Open an Microsoft Excel [...]...
there is a popular solution for those who have been locked out by excel worksheet. For this solution, what you need is a password recovery tool,my favourite is SmartKey Excel Password Recovery, you can Download this software from its official site
With SmartKey Excel Password Recovery, you can open you excel spreadsheet without data lost.