How to assign different passwords to separate ranges in Excel worksheets


Question:

I am a finance officer in a bank. My job is to generate data into an excel worksheet and upload it into the intranet for various supervisors to view. Today, my manager ask me whether is it possible to assign a password to various supervisors so that he or she can only view that portion of the excel data cells dedicated for them. Anyone can help me, thanks in advance.

Answer:

Since this is a fairly involved procedure, I will guide you to in the Microsoft Knowledge Base that spells out how to do it.

Summary:

Since after the version of Microsoft Excel 2002, we can now use passwords to protect specific ranges in our worksheets. This is a progress from earlier versions of Excel, in which one password applies to the entire worksheet, which might have several protected ranges. In addition, if you use Windows 2000, you can apply group-level passwords and user-level passwords to different ranges.

How to assign separate passwords:

To assign different passwords to separate ranges in a worksheet, follow these steps:

Step 1: Open your Excel file, click the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
Note ：If you are running Microsoft Office Excel 2007, click Allow Users to Edit Ranges on the Review menu in the Changes group.

Step 2: In the Allow Users to Edit Ranges dialog box, click New.

Step 3: In the New Range dialog box, click the Collapse Dialog button. Select the range you want to protected and then click the Collapse Dialog button again.

Step 4: In the Range password box, type the password, then type it again in the Confirm Password dialog box, and then click OK.

Step 5: Repeat steps 2 through 4, assign password to the other ranges.

Step 6: In the Allow Users to Edit Ranges dialog box, click Protect sheet. In the Password to unprotect sheet box, type ranger, and then click OK two times. When prompted, retype the password.

From now on, your worksheet's separate ranges are password protected by different passwords. If you select the password protected range and start type the data, then Unlock Range dialog box will appears. Type the password in the Enter the password to change this cell box, and then press ENTER. You can now enter data.

When you apply different passwords to separate ranges in this way, a range that has been unlocked remains unlocked until the workbook is closed. When you unlock another range, you do not relock the first range. Likewise, when you save a worksheet, you do not relock a range.

You can use existing range names to identify cells that are to be protected with passwords, but if you do, Excel converts any relative references in the existing name definitions to absolute references. Because this may not give you the results you intended, it is preferable to use the Collapse Dialog button to select the cells, as described earlier in this article.

Note:

you can also find the Microsoft Support form: http://support.microsoft.com/kb/289270

Important:

Note these aspects of applying passwords to specific ranges:

Passwords have no effect unless the worksheet itself is protected, but if you password protected your worksheet but now you have forgotten the password, what can you do？There are several password recovery softwares available online which can help you in removing the passwords but if you are searching the easy-to-use and quick one, then Excel password recovery 5.0 is your best choice, for further information: http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

Legal Disclaimer

Our website is not responsible for the information contained by this article. Webworldarticles.com is a free articles resource thus practically any visitor can submit an article. However if you notice any copyrighted material, please contact us and we will remove the article(s) in discussion right away.


This article was sent to us by: Michelle at 08242010

Related Articles

1. Unauthorized Execution of Programs or Commands
A perpetrator can exploit a vulnerability in a victim system that enables the perpetrator to run one or more rogue commands on that system. A clever perpetrator can the...

2. Free Software Licenses
The term Open Source was coined in an attempt to resolve the confusion surrounding the word free in "free software." The Open Source Initiative (OSI) was created in order...

3. History of Free Unix Software
This history is simplified and biased toward the most important elements in a Linux system. In the earliest days of computing, software was seen as little more ...

4. Denial of Service Attacks
Denial-of-service (DoS) attacks are reported to incident response teams more than any other type of attack. Misconceptions about denial-of-service attacks abound, howev...

5. How to Downgrade PSP to version 1.5 using PSP battery
Lots of users downgrade their PSP to version 1.5 in order to upgrade to higher version such 3.51,etc.,because with a refresh PSP with a version 3.03 or above,you can run ...

6. Software To Increase Online Store Sales
Motivate your potential customer to purchase your product online! Make your customers loyal, and prefer your store over the competition! Make them an individual offer bas...

7. So You Think You Know CRM Software
A year ago if someone asked me if I knew my way around the CRM Software Industry I would have confidently said yes, however, as it turns out the old saying the more you l...

8. Using Age Verification Software in Your Business
Article Summary - There are all sorts of reasons you might need to know the age of a patron at your business, such as if he or she is trying to buy cigarettes or a...