Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
I'm now ready to share this information with other people, but first, I want to protect the worksheet. Because this is classified information for EatCake's organization, and I don't want just anyone taking a look at our costs. In order to do that, I'm going to use the commands that you see in the Changes group on the Review tab. You can protect a sheet, a workbook, so it just depends on the level of information and security you want to have. In this case, I'm just going to protect the sheet itself because that's really all the information that I have in this workbook.
And if you'd like to follow along, this is saved as EatCake Inventory list4, in your Exercise Files. If click on a protect sheet, I now have the ability to prevent unwanted changes to the data it in the information. If I click on it, it asks me, "what about the sheet would you like to protect?" The default is to protect the worksheet and the contents of any locked cells that I have.
The password used to unprotect the sheets is going to be EatCake, and you notice that it's encrypted so that no one even standing behind me when I'm trying time to protect this worksheet can see the password that I've added in here. I'm now going to identify the different levels of security that I'm going to allow the users of this worksheet to do. They could Select locked cells, they can unlock cells if they have the password, I'm not going to allow them know to format any of the cells because I like the look and feel, and I'm not going to allow them to change any of the columns or rows. I don't want them changing the information that's in here, I just want them to be able to analyze it.
if you are interested in allowing people to work with the data and add even more information to it, you can make any of these selections if it's appropriate. But in this case, I'm just going to identify that I want to lock certain areas of this sheet. So if I click OK, it then asks me to confirm the password that I placed in the spreadsheet. And if all is good, I've now protected this sheet. If I'd like to unprotect the worksheet, I simply click on unprotect worksheet, and put in the password that I've already created. When you protect a worksheet, you are actually protecting certain areas from editing.
So if I select this particular cell and try to change the amount that's included in here for my current cost to $6.00-- oh, look what I see, I see an error message that's telling me that the cell for the chart that I'm trying to change is protected and therefore read only. To modify it, I have to remove the protection using the password command. Let's try that. If I select this, click Unprotect Sheet, put in my password, which is eatcake, click OK, then go back into the cell and try to change it, I now have editing ability. So that really helps you as the owner of the spreadsheet to control who has final ability to edit the information that you are working with.
I'm going to remove that change by clicking the Cancel button here up on the formula bar. So you can protect the sheet, a cell in the sheet, or the whole workbook by adding the password permissions to any of the spreadsheets that you work with in 2007. In the next movie, we're going to be looking at some of the different options that you can choose for sharing your information, and tracking the changes that are made to the different worksheets.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73572 Viewers
80 Video lessons · 129279 Viewers
52 Video lessons · 63653 Viewers
59 Video lessons · 49415 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.