To apply group-level protection to a worksheet, follow these steps:
1.Start Excel, and then open a blank worksheet.
2.On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
Note If you are running Excel 2007, click Allow Users to Edit Ranges in the Changes group on the Review menu.
3.In the Allow Users to Edit Ranges dialog box, click New.
4.In the New Range dialog box, click Collapse Dialog, select the range B2:B6, and then click Collapse Dialog again.
5.In the Range password box, type rangeone, and then click OK twice. When prompted, retype the password.
6.Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
7.In the Allow Users to Edit Ranges dialog box, click Permissions, and then click Add in the Permissions for Range2 dialog box.
8.In the Select Users, Computers, or Groups dialog box, type Everyone.
9.Click OK in the Select Users, Computers, or Groups dialog box, and then click OK in the Permissions for Range2 dialog box.
10.In the Allow Users to Edit Ranges dialog box, click Protect sheet, type ranger in the Password to unprotect sheet box, and then click OK twice. When prompted, retype the password.
11.Select cell B3, and then start to type Dataone. A password is still required. Click Cancel in the Unlock Range dialog box.
12.Select cell D3, and then type Datatwo.
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.
Microsoft Excel the best software, in my opinion, that is created by human being. In this blog, you will find related stuff with this software. I am not here to solve any problem with Excel. I am here to helping you all and my self to understand the software and gain more knowledge about it.
Subscribe to:
Post Comments (Atom)
Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...
-
If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
-
Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
-
I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
No comments:
Post a Comment