Protecting sheets and cells with Excel tools
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
|
The frustration of having accidentally overwritten cells can be prevented through the use of Excel tools to protect individual cells against changes or overwriting. More often than not you will need the flexibility of being able to make input changes, but don’t want to allow formula changes made. This is especially true when more than one person must be able to work on a spreadsheet, but allowing changes to formulas will lead to inaccurate models. As such we take a short tour through the use of Excel tools to protect cells or sheets against these changes
|
|
Where to find the protection feature
Select Tools on the Menu-bar and then select the Protection option. From this you will be able to select sheet protecting as there are also other choices such as workbook protection. Once you have selected to protect the sheet a window will open with several options. You can select to protect locked cells or format cells. To get to the level of required protection simply select the relevant options. By only selecting the areas where the formulas are, you can still allow input changes by the user. If someone is to type in a protected cell, a message will pop-up to warn that it is protected and thus no changes will be allowed.
It is important though to note that if the sheet protection choice is made that all the cells will be protected. If you want specific cells to be protected you need to indicate it. One of the useful Excel tools is that of password protection. You can add a password to be typed in before the protection is removed. To unprotect you follow the same steps and select the sheet to be unprotected. View our training videos on the use of Excel tools.
|
