Some Useful Tools when protecting spreadsheets

Please purchase the course before starting the lesson.

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 see the full course contents click here.

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