Unprotext sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1276862%22%20slang%3D%22en-US%22%3EUnprotext%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1276862%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20update%20information%20on%20my%20budget%20spreadsheet.%26nbsp%3B%20I%20keep%20receiving%20a%20%22pop-up%20that%20says%20%2C%22%26nbsp%3B%20the%20cell%20or%20chart%20that%20you%20are%20trying%20to%20change%20is%20a%20protected%20sheet.%26nbsp%3B%20To%20make%20a%20change%2C%20unprotect%20the%20sheet.%26nbsp%3B%20You%20might%20be%20requested%20to%20enter%20a%20password.%22%26nbsp%3B%20I%20am%20unable%20to%20figure%20out%20how%20to%20do%20that.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1276862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1277761%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotext%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607014%22%20target%3D%22_blank%22%3E%40Sr3TAsL05%3C%2FA%3E%26nbsp%3BDo%20you%20see%20the%20lock%20icon%20with%20the%20sheet%20name%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-03%20at%2008.59.15.png%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F181842i32EA1AFD62B08231%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20title%3D%22Screenshot%202020-04-03%20at%2008.59.15.png%22%20alt%3D%22Screenshot%202020-04-03%20at%2008.59.15.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20so%2C%20go%20to%20Tools%2C%20Protection%2C%20Unprotect%20Sheet...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-03%20at%2009.01.28.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F181843i3CB0856318258993%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-04-03%20at%2009.01.28.png%22%20alt%3D%22Screenshot%202020-04-03%20at%2009.01.28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPictures%20were%20taken%20in%20Excel%20for%20Mac%20but%20should%20look%20similar%20on%20Windows.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am trying to update information on my budget spreadsheet.  I keep receiving a "pop-up that says ,"  the cell or chart that you are trying to change is a protected sheet.  To make a change, unprotect the sheet.  You might be requested to enter a password."  I am unable to figure out how to do that. 

1 Reply
Highlighted

@Sr3TAsL05 Do you see the lock icon with the sheet name?

Screenshot 2020-04-03 at 08.59.15.png

If so, go to Tools, Protection, Unprotect Sheet...

Screenshot 2020-04-03 at 09.01.28.png

Pictures were taken in Excel for Mac but should look similar on Windows.