In this lesson we check that you’re clear on how you could be password protecting areas of a spreadsheet. The lesson is based on a question we regularly get on our financial modelling course training: “How do I password protect a spreadsheet?”
An obvious application would be where you’ve prepared a spreadsheet for use within your company, but you only want users to change certain key inputs. You don’t want anyone mucking up the formulas in the spreadsheet!
This lesson is a short one but it’s just a chance to make sure you are completely familiar with Excel’s password protection options.
The top tip in this course lesson should probably should be: “Don’t forget your password!”
We’ve got a free online Excel course for you
Here you can take our free course on Excel formulas for financial modelling.