Microsoft Excel 2007 Tutorial – Workbook Safety

Spread the love

Microsoft Office environment Excel 2007 provides several techniques to protected and safeguard your do the job. For exceptional stability, you really should secure your complete workbook file with a robust password. Excel passwords can be up to 255 letters, quantities, areas, and symbols and are Situation Delicate. For further protection of knowledge inside your workbook, you can protect unique worksheet or workbook elements, with or with out a password. Guarding worksheet or workbook factors might support reduce customers from unintentionally or intentionally changing, relocating, or deleting essential knowledge.

In this Microsoft Excel 2007 Tutorial, I am going to present you how to build a password to secure your workbook and how to safeguard some workbook aspects. There are quite a few Excel Suggestions and Tips to information to currently being an qualified Excel user. I have other Excel Strategies as element of my Microsoft Excel 2007 Tutorial sequence that I hope you find handy.


To provide security to your complete workbook, you can specify two individual passwords:

  • Open and check out the workbook. This is an encrypted password that helps prevent unauthorized entry to your workbook. You can also give users the possibility to open in read through-only manner if they are just viewing info. This can assistance avert accidental alterations from currently being saved.
  • Modify the workbook. This is an unencrypted password that is only intended to give specific buyers authorization to edit the workbook.

These passwords use to the overall workbook and they really don’t have to be the exact same password. In point, it is substantially safer to use distinct passwords. To provide strong protection, you may want to make the most of both features. Talking of potent, sturdy passwords combine uppercase and lowercase letters, figures, and symbols. sweetheartone is not solid, but Sw33tH3ArT0nE is potent.

To secure your workbook with a password:

  1. Click the Microsoft Office Button, then click on Help save As, then pick out Excel Workbook. Certainly, do this for an present workbook.
  2. On the bottom remaining of the Help you save As dialog box, click on the Equipment button and pick Standard Options.
  3. To require customers to enter a password on opening the file, type a password in the Password to open box.
  4. To require consumers to enter a password that will allow them to make and preserve modifications, sort a password in the Password to modify box.
  5. To guard from users unintentionally modifying the file, find the Read-only encouraged verify box. People will be requested whether or not or not they want to open the file as study-only. Note! If you designed a Password to modify, the consumer, when prompted to enter this password, will have the alternative to open up as read through-only. Consequently, this selection is not important when making use of Password to modify.
  6. Click on Okay.
  7. You will be prompted to retype your passwords to confirm them. Click Alright soon after confirming.
  8. Click on the Save button.
  9. If this is an current workbook and you’re applying the same file-title, you will be prompted to click on Certainly to change the present workbook.

Microsoft Place of work Excel 2007 gives choices to defend your facts from getting altered or deleted by making use of worksheet factor stability and workbook aspect stability. For other Microsoft Place of work Excel Suggestions and Tips, see my other posts in the Microsoft Excel 2007 Tutorials sequence.

WORKSHEET Ingredient Stability

  1. On the worksheet that you want to guard, unlock any cells or ranges that you want other consumers to be able to adjust:
  2. Choose each cell that you want to unlock or decide on a complete selection of cells.
  3. On the Property tab, in the Cells team, simply click the Structure button, then click Format Cells.
  4. On the Defense tab, very clear the Locked verify box.
  5. You can cover formulas that you never want buyers to see:
  6. Decide on the cells that consist of the formulation you want to disguise.
  7. On the Residence tab, in the Cells group, simply click Format, then click on Structure Cells.
  8. On the Defense tab, select the Concealed test box, then click on Ok.
  9. If you want to unlock objects like pictures, clip artwork, or designs do the adhering to:
  10. Keep down [CTRL] whilst clicking just about every item that you want to unlock. The Picture Resources or Drawing Instruments will be shown, including a Format tab. Take note! Do not pick objects of different kinds as the Dialog Box Launcher will not likely initialize.
  11. On the Format tab, in the Sizing group, click the Dialog Box Launcher upcoming to Sizing.
  12. On the Homes tab, distinct the Locked test box. If current, crystal clear the Lock text check box.
  13. Simply click the Near button.
  14. On the Assessment tab, in the Variations group, click on Defend Sheet.
  15. In the Let all people of this worksheet to record, pick out the things that you want to make it possible for people to adjust.
  16. In the Password to unprotect sheet box, form a password for the sheet, simply click Okay, then affirm the password. This is an optional password. If you do not use it, then any person can unprotect the sheet and change the protected things.

WORKBOOK Factor Stability

You use workbook component stability to reduce consumers from, amongst other folks:

  • Viewing worksheets that you have concealed
  • Shifting, deleting, hiding, or shifting the names of worksheets
  • Inserting new worksheets or chart sheets
  • Shifting or copying worksheets to a different workbook
  • In PivotTable experiences, displaying the source details for a mobile in the info spot, or exhibiting page area webpages on separate worksheets
  • Recording new macros
  1. On the Assessment tab, in the Variations group, simply click Secure Workbook and choose the Protect Framework and Windows possibility.
  2. To safeguard the composition of a workbook, select the Framework check out box.
  3. To retain workbook windows in the very same dimensions and place each and every time the workbook is opened, pick the Windows look at box.
  4. To avoid users from taking away this workbook defense, in the Password (optional) box, kind a password, click on Alright, then validate it. This is an optional password. If you will not provide a password, then any user can unprotect the workbook and adjust the protected features.

Excel safety is an critical element that can assist safeguard your information.

Don't miss out!
Subscribe To Newsletter

Receive top technical news, lesson ideas, travel tips and more!

Invalid email address
Give it a try. You can unsubscribe at any time.

Spread the love


  1. Good site! I truly love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified when a new post has been made. I’ve subscribed to your RSS feed which must do the trick! Have a nice day!

  2. Good site! I truly love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified whenever a new post has been made. I’ve subscribed to your RSS feed which must do the trick! Have a great day!


Please enter your comment!
Please enter your name here