Making protected Excel Spreadsheets easier to use

Protection Examples

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.

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