Protecting formulas worksheets in Excel

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!