If you want to make changes, you need to unprotect the sheet first and make changes in excel. Now we have protected our sheet, which restricts the users from modifying the document. The only thing they can do is they can insert a new sheet and only work on that newly inserted sheet only. In this sheet, users cannot do anything else apart from seeing the data. Re-enter and click on OK to complete the process. Step 5: It will ask you to re-enter the password one more time. Step 4: At the same time, we can allow a user to make some kind of changes like Insert Hyperlink, Insert row or column, etc… If you allow them to make changes, you need to select those options under “ Allow all users of this worksheet to.”Click on OK. Because you need the same password to unprotect the sheet later if you want to make some changes, a password is case sensitive so remember the exact characters as well. Step 3: Enter your password carefully here. Step 2: Now, you will see Protect Sheet window, which asks you to put the password. Step 1: Go to the Review tab and click on the Protect Sheet. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting in Pivot Table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |