Connect with OB
- Strong showing by the 2nd years so far @ the Owen Olympics #OwenOlympics http://t.co/shoi47wFzr about 4 weeks ago from Twitter for iPhone ReplyRetweetFavorite
- RT @VanderbiltOwen: Thoughts and prayers are with Kevin White (MBA'10) and family who were severely injured in #BostonMarathon bombing h ... about 1 month ago from Twitter for iPhone ReplyRetweetFavorite
- Owen dames & partners supporting the mens first year softball team http://t.co/QlxyhSOWRe about 1 month 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.