Some Useful Tools when protecting spreadsheets

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

Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Control access to information in Excel Spreadsheets