|
Protecting
formulas worksheets in Excel is sometimes needed to protect your
formulas, allow editing of specific cells only and hide the formulas in
a worksheet so that a user doesn't change them unknowingly. This helps
the user in avoiding errors and since the formulas are supposed to work
on the entered data in a specific way, the task of data entry becomes
even easier. Of course, you may wish to hide the formulas because you
don't wish people to copy your hard work. The training video below
describes in detail how to hide the formulas, allow editing of specific
cells in the worksheet and providing protection to other areas of the
worksheet where the user cannot enter data. In case the user tries to
enter data in the protected areas, a message is diplayed indicating
that the worksheet is protected and you need to unprotect the sheet
before you can enter data in that area. For that the user must have a
password!
|