Protection Examples

Preview 
Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

Protection Ex 1

To follow along go to 19.18.1

  • Find all the Input Cells and make them blue and unlock them (watch out for the overwritten formula – you need to fix it)
  • Protect the sheet so that you can widen rows and columns if necessary
  • Create a different password for the Inflation Rate in cell C6
  • Make sure no one can enter a marketing percentage less than 10%

Solution




Lesson tags: spreadsheet protection
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Making protected Excel Spreadsheets easier to use