Protection Examples

Please sign up for the course before starting the lesson.

Protection Ex 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%

To see the full course contents click here.

Lesson tags: vlookup
Back to: Advanced Excel Course > Protecting spreadsheet information and formulas