![]() Now go to the Review tab and select Allow Edit Ranges. To do this, open a spreadsheet and select formulas in the document, or select entire rows or columns. Select Trust Center > Trust Center Settings > Protected View. This will allow you to lock formula cells and only allow people to use a password to modify cells where data input is necessary. Disabling Protected View to Edit Excel Files Go to File > Options. When people edit cells in your sheet, they will not have to unprotect the entire document. This lets you set a separate password to protect the Excel sheet and a second password for each range of cells you want people to edit. You can also allow people to use a password to edit a specific range of cells in your Excel worksheet. Remember that if you’ve applied conditional formatting before protecting the sheet, the formatting will continue to trigger as expected even if some cells are locked. ![]() You will be able to edit unlocked cells in the Excel file, but not the ones you’ve locked. This will block specific cells in Microsoft Excel. Confirm your password and select OK again. ![]() ![]() Uncheck everything you want to block, and then select OK. Add a password here, and go through the list of options in the pop-up. Click the Review tab and select the Protect Sheet option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |