Control access to information in Excel Spreadsheets

Some Useful Tools when protecting spreadsheets

This is a preview lesson
Register or sign in to take this lesson.
Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

When you are working with password protection, you often need to differentiate which cells are inputs and which are formula. You can manually do it (check every cell manually) or use some of Excel’s inbuilt tools to make the process faster.

To follow along go to 19.17