Protect worksheet so people can add values

%3CLINGO-SUB%20id%3D%22lingo-sub-2096084%22%20slang%3D%22en-US%22%3EProtect%20worksheet%20so%20people%20can%20add%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096084%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%20I%20have%20a%20large%20spreadsheet%20that%20many%20people%20will%20be%20editing.%20Someone%20recently%20removed%20the%20filtering%20in%20certain%20columns%2C%20so%20the%20data%20got%20scrambled%20when%20someone%20filtered.%20My%20question%20is%2C%20is%20there%20a%20way%20to%20protect%20the%20worksheet%20so%20you%20can%20allow%20people%20to%20add%20data%20but%20not%20change%20formatting%20such%20as%20filtering%2C%20data%20validation%2C%20etc.%3F%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22thread-message-content-body-text%20thread-full-message%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20protecting%20the%20sheet%20with%20the%20following%20boxes%20checked%2C%20but%20then%20couldn't%20edit%20the%20spreadsheet%20without%20unprotecting%20it.%20I've%20tried%20different%20combinations%20of%20these%20boxes%20as%20well.%20Along%20with%20protecting%20the%20workbook.%20I%20can't%20figure%20out%20another%20way%20to%20get%20this%20done.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20373px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249364iFF74E58EF684E372%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture2.PNG%22%20style%3D%22width%3A%20369px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249365i92346E02CC2C420C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture2.PNG%22%20alt%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2096084%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi, I have a large spreadsheet that many people will be editing. Someone recently removed the filtering in certain columns, so the data got scrambled when someone filtered. My question is, is there a way to protect the worksheet so you can allow people to add data but not change formatting such as filtering, data validation, etc.?

 

I tried protecting the sheet with the following boxes checked, but then couldn't edit the spreadsheet without unprotecting it. I've tried different combinations of these boxes as well. Along with protecting the workbook. I can't figure out another way to get this done.

Capture.PNGCapture2.PNG

2 Replies

@ShannonBuhman 

Depends on Excel version, Sheet Views in Excel - Office Support (microsoft.com) could be useful, but only for sorting and filtering