Protect lines in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-1467049%22%20slang%3D%22en-US%22%3EProtect%20lines%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467049%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20keep%20lines%20together%2C%20such%20that%20information%20assembled%20in%20a%20line%20cannot%20accidentally%20be%20scrambled%3F%3C%2FP%3E%3CP%3ETo%20make%20my%20point%20clear%3A%20I%20organize%20data%20in%20rather%20large%20tables%20with%2C%20e.g.%20%26gt%3B1000%20lines%20and%20columns%20up%20to%20AD.%20Every%20single%20line%20combines%20information%20on%20a%20certain%20item.%20What%20I%20want%20to%20avoid%20is%20that%20anybody%20disrupts%20this%20association%2C%20e.g.%20by%20inserting%20or%20deleting%20fields%20in%20one%20column%20only%2C%20or%20by%20sorting%20a%20single%20column.%20Both%20has%20happened%20before%20and%20caused%20a%20lot%20of%20work%20to%20fix.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EKonrad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1467049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467141%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20lines%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467141%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F700523%22%20target%3D%22_blank%22%3E%40Konrad_L%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20protect%20the%20sheet%20(including%20a%20password%20if%20required).%20This%20is%20not%20fool%20proof%20but%20will%20stop%20mist%20users%20amending%20the%20data.%3C%2FP%3E%3CP%3ELook%20up%20PROTECT%20SHEET%20-%20it%20should%20be%20relatively%20easy%20to%20follow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467175%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20lines%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3Ethanks%20for%20your%20quick%20reply.%20I%20was%20aware%20of%20that%20option%20but%20didn't%20think%20it%20would%20solve%20my%20problem.%20Just%20to%20check%3A%20Will%20users%20still%20be%20able%20to%20sort%20or%20filter%20the%20data%3F%20Cause%20that%20would%20be%20okay%20with%20me%2C%20as%20long%20as%20they%20don't%20mix%20them%20up.%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EKonrad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1467182%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20lines%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F700523%22%20target%3D%22_blank%22%3E%40Konrad_L%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20have%20a%20PW%20on%20then%20sorting%20will%20not%20work.%3C%2FP%3E%3CP%3EFiltering%20will%20work%20but%20you%20must%20remember%20to%20tick%20the%20AUTOFILTER%20option%20(see%20below)%20when%20you%20protect%20the%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22peteryac60_0-1592300745348.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198988iB0B0FEBF71B020F1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22peteryac60_0-1592300745348.png%22%20alt%3D%22peteryac60_0-1592300745348.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there,

is there a way to keep lines together, such that information assembled in a line cannot accidentally be scrambled?

To make my point clear: I organize data in rather large tables with, e.g. >1000 lines and columns up to AD. Every single line combines information on a certain item. What I want to avoid is that anybody disrupts this association, e.g. by inserting or deleting fields in one column only, or by sorting a single column. Both has happened before and caused a lot of work to fix.

Thanks,

Konrad

3 Replies
Highlighted

@Konrad_L 

 

Hi 

 

You can protect the sheet (including a password if required). This is not fool proof but will stop mist users amending the data.

Look up PROTECT SHEET - it should be relatively easy to follow.

 

hope this helps.

 

Peter

Highlighted

@peteryac60 

Hi Peter,

thanks for your quick reply. I was aware of that option but didn't think it would solve my problem. Just to check: Will users still be able to sort or filter the data? Cause that would be okay with me, as long as they don't mix them up.

Best,

Konrad

Highlighted

@Konrad_L 

 

if you have a PW on then sorting will not work.

Filtering will work but you must remember to tick the AUTOFILTER option (see below) when you protect the sheet.

 

peteryac60_0-1592300745348.png

 

Thanks

 

Peter