![]() ![]() Workbook-level security will help you prevent other users from adding, deleting, hiding, or renaming your sheets. In case you have specified any password while protecting the sheet, Excel will ask you to enter the same in order to unprotect the sheet. In case you want to unprotect the sheet, you can do it by selecting the Unprotect Worksheet option from the Review tab. Give some password of your choice and click on OK (The setting of a password is optional).From the “ Allow all users of this worksheet to” option, select any of the elements that you wish to.To protect the sheet, click on the Review tab and then select the Protect Sheet option.Open the Font window present in the Home tab.In the sheet that you wish to protect, select all cells that can be edited by the users.To protect your worksheet you must follow 2 steps:ġ: Unlock cells that can be edited by the users you can allow each sales staff to modify the details of only that product which he is responsible for and not the others. For example, if you have a sheet that contains details of the sales for different products, and every product is handled by different individuals. Not just this, you can also selectively allow or disallow access to particular cells of your sheet to various users. To protect the data present in a worksheet from being modified, you can lock the cells and then protect your worksheet. Protecting a file with a password will not necessarily protect against malicious activities.Avoid distributing password protected files with sensitive information such as bank details. ![]() No restrictions are levied but, Excel passwords are case-sensitive.Do not forget your password as there is no password recovery available in Excel.Keep the following points in mind while entering passwords: In order to protect an Excel file, follow the given steps:Ĥ: From the list, select Encrypt with Password optionĥ: Enter a password in the dialog box that appearsĦ: Re-enter the password and then, click on OK So, here is the first and the most important aspect that you need to know in this Advanced Excel Tutorial.įile-level security refers to securing your Excel file by making use of a password so as to prevent others from opening and modifying it. Take a look at all the topics that are discussed in this article: In case you are still unaware of the magical tricks of Excel, here is an Advanced Excel tutorial to help you learn Excel in great depth. It’s really nice to manage huge data with just a few mouse clicks and Excel is definitely the one tool that will allow you to do this. ![]()
0 Comments
Leave a Reply. |