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 |