Password protecting an Excel spreadsheet

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!

Password protecting an Excel 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.