Is there a way to protect your formula maybe by putting it in a different cell that can be locked and referencing the cell where they can input Thanks. I have a formula in one column that needs to be edited if need be but if they make a mistake and hit delete then my formula disappears and it throws the whole sheet off. Right now I have certain columns locked while allowing others to be edited. Sometimes I am stymied by an obvious feature that is still not included, even though there are a lot of incredible features (as well as more than a little bloat). Sometimes you might want to lock cells in your Excel spreadsheet that contain formulas and functions or. To protect your spreadsheet, Excel proposes the following options. Protecting a workbook is different from protecting the Excel file with a password to prevent. Allow Users To Edit Ranges In Excel Password To Prevent Allow Users To Edit Ranges In Excel Software Updates InĪlso, we are not responsible for access configuration or software updates in your company. We are not a division, a subsidiary, or a contractor of Microsoft Corporation, and we are not responsible for their decisions. On the Home tab, in the Editing group, click Find Select, and then.
0 Comments
Leave a Reply. |