1 / 25

A few tricks to take you beyond the basics of Microsoft Office 2007

A few tricks to take you beyond the basics of Microsoft Office 2007. GCPS Tech Tips. Microsoft Excel 2007: Stop Unauthorized Changes in Cells. . EXCEL 2007: Stop Unauthorized Changes in Cells.

zubeda
Download Presentation

A few tricks to take you beyond the basics of Microsoft Office 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office 2007 GCPS Tech Tips Microsoft Excel 2007: Stop Unauthorized Changes in Cells.

  2. EXCEL 2007: Stop Unauthorized Changes in Cells Did you ever finish putting information into an Excel worksheet and start thinking, “I wish there were some way to keep anybody else from messing up this worksheet.”

  3. EXCEL 2007: Stop Unauthorized Changes in Cells There is a way to protect one cell... or a group of cells... or even a whole worksheet from tampering by other people. If you share a worksheet with other people, you can specify which cells they can and cannot change.

  4. EXCEL 2007: Stop Unauthorized Changes in Cells The first step is to select the cell or cells that you do not want protected... the ones that you are willing for others to make changes in. Select those cells...

  5. EXCEL 2007: Stop Unauthorized Changes in Cells Then... with your cursor on those selected cells... press the right button on your mouse.

  6. EXCEL 2007: Stop Unauthorized Changes in Cells That will drop down a list of things you can do to the selected cells. Click on “Format Cells.”

  7. EXCEL 2007: Stop Unauthorized Changes in Cells That will open a “Format Cells” dialog box with six tabs across the top. Find the tab that says “Protection” and click on it.

  8. EXCEL 2007: Stop Unauthorized Changes in Cells At the top of the “Protection” page, you’ll see the words “Locked” and “Hidden.” Make sure neither word has a check mark by it...

  9. EXCEL 2007: Stop Unauthorized Changes in Cells and click “OK” at the bottom of the dialog box.

  10. EXCEL 2007: Stop Unauthorized Changes in Cells Now that you have told Excel what not to protect, you can tell it to protect every other cell in the worksheet. To lock the whole worksheet, click on “Tools” at the top of your screen.

  11. EXCEL 2007: Stop Unauthorized Changes in Cells Then click on the Format option in the Cells box.

  12. EXCEL 2007: Stop Unauthorized Changes in Cells That will drop down a list of Excel tools.

  13. EXCEL 2007: Stop Unauthorized Changes in Cells In the Protection section, you will see “Protect Sheet.” Click on that and...

  14. EXCEL 2007: Stop Unauthorized Changes in Cells Excel opens a “Protect Sheet” dialog box with lots of choices.

  15. EXCEL 2007: Stop Unauthorized Changes in Cells You put a check mark here to protect the whole worksheet.

  16. EXCEL 2007: Stop Unauthorized Changes in Cells A password is not required, but if you want to use a password, you can type it in here. (Be sure you write that password down somewhere because, if you forget it, there won’t be any way to find it again.) Of course, without a password, anybody who knows their way around Excel could go in and reverse the restrictions you are putting in place.

  17. EXCEL 2007: Stop Unauthorized Changes in Cells If you do choose to use a password, clicking on “OK,” will bring up one more box that Excel uses to confirm your password. Don’t forget that this password is case-sensitive – you have to enter it every time with capital and lower case letters just the way you originally entered it.

  18. EXCEL 2007: Stop Unauthorized Changes in Cells One final click on “OK” and your worksheet is protected except for the cells in which you were willing to allow changes.

  19. EXCEL 2007: Stop Unauthorized Changes in Cells If someone tries to enter anything into any of the protected cells, they will receive a warning that looks like this.

  20. EXCEL 2007: Stop Unauthorized Changes in Cells But, if they select any of the cells you left changeable, they will be able to make any changes there that they like.

  21. EXCEL 2007: Stop Unauthorized Changes in Cells To unprotect a worksheet, click “Format” from within the Cells window under the Home tab ...

  22. EXCEL 2007: Stop Unauthorized Changes in Cells then click on “Unprotect Sheet.”

  23. EXCEL 2007: Stop Unauthorized Changes in Cells You’ll have to type in the password if there is one...

  24. EXCEL 2007: Stop Unauthorized Changes in Cells But after that, a click of “OK” takes you back to where you can make changes anywhere in the worksheet.

  25. EXCEL 2007: Stop Unauthorized Changes in Cells That’s all there is to it. Now, if you would like a copy of the step-by-step directions for stopping unauthorized changes in cells within Excel 2007, just print this last page. Have fun controlling those changes!

More Related