Connect with OB
- RT @virtualcfo: Told 9 yr old daughter I have a bachelors degree, she responded "you went to school to learn to be a bachelor?" and then-l… about 6 months ago from Twitter for iPhone ReplyRetweetFavorite
- RT @DarthWheeler: My email address is cowheeler@ ... Cow Heeler?!? I sound like a PETA lawsuit waiting to happen #MBAproblems @owenbloggers… about 6 months ago from Twitter for iPhone ReplyRetweetFavorite
- RT @VanderbiltOwen: Owen's new Dean Eric Johnson: Delighted to return to Vanderbilt and to Nashville. http://t.co/TF8sMaHafG about 6 months ago from Twitter for iPhone ReplyRetweetFavorite
Tag Archives: password protection
Today’s topic is password protecting your worksheet.
In my professional career I’ve had to make many spreadsheets for other people to use. This is always a tricky situation because regardless of Excel skills, there will always be an information asymmetry between the developer and user of the spreadsheet. Even if the spreadsheet developer uses the most clear formatting and annotation there is still a risk for the user to delete something, insert something, or paste something where it isn’t supposed to go.
To help combat this, it is sometimes wise to password protect a spreadsheet. Excel actually gives you quite a bit of flexibility when it comes to password protection. You can protect just a single cell of a spreadsheet all the way to the entire sheet and you also have a wide array of protection options. For example, you can set the parameters such that users can change the cell color, but can’t change the cell value. Or you could allow users to sort the data, but not use the Auto-Filter. Let’s look at some basic examples:
Download the example spreadsheet here.