In Microsoft Excel 2013 we can protect our whole worksheet but now we can also secure our single sheet and cells present in it. When we finalize our worksheet by examine the formulas and proof read the data so we want to save it from the access of unauthorized person and unexpected changes.
In Excel’s worksheet cells may b locked or unlocked. Cells have two attributes Locked and Hidden. In this application all cells are locked by default by they are not hidden. When Excel sheet is protected then these two characteristics play their roles. When worksheet is being protected then we have to unlock the cells. Locking and unlocking of cells is useless and have no effect unless and until worksheet is protected.
In Excel’s worksheet cells may b locked or unlocked. Cells have two attributes Locked and Hidden. In this application all cells are locked by default by they are not hidden. When Excel sheet is protected then these two characteristics play their roles. When worksheet is being protected then we have to unlock the cells. Locking and unlocking of cells is useless and have no effect unless and until worksheet is protected.
How we will learn how to protect Excel document by following this particular method.
Protect a Document in Excel:
- Open > Microsoft Excel
- Select > Sheet which we want to protect.
- Go to > Review tab.
- Click > Protect Sheet command from the Changes section.
- Protect Sheet dialog box will open.
- By default, Excel selects the check box of Protect Worksheet and Contents of locked cells at the top of the box.
- Moreover, Excel also chose the option of locked any unlocked cells.
- Type Password in the edit box of > Password to Unprotected sheet.
- After entering password, Click > Ok button.
- Excel opens the Confirm Password box, again enter the password in the > Re-enter Password to Proceed.
- Click > OK button or Press > Enter key.
Post a Comment