Home » Accounting » How to Protect Cells within Microsoft Excel

How to Protect Cells within Microsoft Excel

Download Business Management Templates Excel Dashboards KPI Reports

Protect Cells in Excel:
Click on the review options in the menu options on top of the excel worksheet. Choose protected Sheet.
Type a password in the Password area option to unprotect the sheet area in the options box which opens. Select ok. Type the password one more time to confirm it in new box which opens and then select ok to define it.
Choose any excel cell and test to modify it. You could discover any error information telling you that document is secured and has got the read only condition.
Eliminate password protection. To accomplish this, click on the review options in the top options and next select the Unprotect sheet image. Type the password and then select ok.
Choose the cells you prefer to unlock. Take into account that each one cells’ setting is secured right away, so you will need to unlock cells which do not have to be read only prior to you can include protection into the ones you prefer to be protected. Right click the chosen cells and then click formatting excel cells.
Click on the protection tab in new window which opens and uncheck secured check box. Select ok.
Click on the review options in the list on top of page and choose protected Sheet. Enter the password in to the options box and then select ok. Confirm the password in the following box and then select ok.
Choose cell which you unlocked and then confirm it could be modified. Choose cell which you have not unlocked and confirm now that it is read only.
If you have to choose cells which aren’t next to each other, choose the first cell, hold the control key and next click the following excel cell in to include it into the selection.
You don’t need to type password if you protected the worksheet, however you could very well do so. In case you do not, any user is able to eliminate the protection and modify your cell info.
Make sure that to get note of every passwords you make use of to secure Excel. In case you forget about you might not be capable to edit the documents in the future.
You could protected or maybe even freeze the columns in excel therefore they remain visible whenever you are scrolling via the excel sheet.

Download Business Management Templates Excel Dashboards KPI Reports