How to: Protecting your Sheets/Workbooks with a password

SUMMARY:

SUMMARY:

To prevent other users from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook, an easy way to accomplish the task is protecting certain worksheet or workbook elements with a password. This passage is going to show you how to do.

Before getting into this tips and tricks, I'd like to share a great resource on the web where you can crack your Excel files if you forgot the password.

Microsoft Office Excel Password Recovery Solution Page can't open your secure Excel files, refer to this page, it is creates with best and more powerful features to help us to recover excel spreadsheet password.

And now for the tips to Protecting your Sheets/Workbooks:

HOW TO:

Protecting a Sheet is not hard. You just need to remember there are two steps. The first is choosing which cells you want locked. It's okay if you want every cell on a sheet, just click CTRL + A to select all of the cells on the sheet. Once you've chosen the cells you want protected, right click and choose FORMAT CELLS. Click the PROTECTION TAB on the dialogue menu that pops up and check the LOCKED option. By default, the locked option is checked. (See below)

The second step is to go to the REVIEW ribbon and click PROTECT SHEET. You have many options here but choosing SELECT LOCKED CELLS will ensure future users won't be able to change your important data. You will have to enter a password to continue. (See below)

Now you won't be able to select any of the cells you chose to lock. To unlock, click UNPROTECT SHEET and input your password.

Protecting a Workbook is also not hard. Click on the Tools button and near the bottom of the dialog box just to the left of the Save button. Excel displays a drop-down list. Click General Options from the drop-down list. Excel displays the General Options dialog box. (See below)

The General Options contains boxes where you can enter two passwords. Each password controls a different level of protection. If you fill in the first password field, you are specifying the password someone needs to know simply to open the workbook. If you fill in the second field, then someone needs to know that password to make any changes to the workbook. Understand that they can still save the open workbook under a new name, but they cannot make any changes and save them back into the same workbook file.

You should set your passwords as desired, and then click on OK to dismiss the General Options dialog box. You are asked to confirm your password, and then you can continue to save your file (using the Save As dialog box) as you normally would.

As a final caveat, you should note that none of the native (built-in) password schemes in Excel are particularly robust. If you want the best protection possible, you should look to a third-party solution for encrypting and protecting your workbooks.

How to: Protecting your Sheets/Workbooks with a password

By: Maggiechen

POST COMMENT

HP Mini 5102 and Asus Eee PC 1101HA Seashell- Best Netbooks Booming World of textbooks Should You Buy Books Or Borrow Them? Top 5 Books About Alcohol The Top 5 Books About Alcohol Reading levels of books Top 3 Forbidden Kid's Books: Have You Got In Your Shelf? Personalised Photobooks Where And How To Buy Mini Netbooks? power supply voltage than the nominal battery voltage of my books is much higher Counters and Guest Books Where and how to buy mini netbooks? Netbooks Best Price