![]() Explains how you can easily allow users to edit only certain cells in Microsoft Excel while locking the rest of the spreadsheet. For our expense report, we’re going to insist that users put in a number with two decimal values, so we would select the “Decimal” option. Here, you can set a specific type of input to allow for your selected cells. In the Data Validation window, on the “Settings” tab, click the “Allow” dropdown menu. Allow edit objects in protected worksheet by checking the Edit Objects option. If you need to edit objects in a protected worksheet, please try the methods in this article. ![]() How to allow edit objects in protected worksheet in Excel? By default, the inserted objects such as shapes, text boxes cannot be edited after protecting the worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |