SOLVED
Home

Locking Hidden Columns/Rows so they cannot be unhidden?

%3CLINGO-SUB%20id%3D%22lingo-sub-835094%22%20slang%3D%22en-US%22%3ELocking%20Hidden%20Columns%2FRows%20so%20they%20cannot%20be%20unhidden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835094%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20that%20I%20would%20like%20to%20lock%20some%20rows%20and%20columns%20so%20they%20cannot%20be%20unhidden.%26nbsp%3B%20not%20just%20so%20they%20cannot%20be%20changed%2Fedited%2C%20but%20stay%20hidden.%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20do%20that%20(have%20not%20been%20able%20to%20find%20one%20yet%20%3A))%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-835094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20-%20locking%20hiding%20columns%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835634%22%20slang%3D%22en-US%22%3ERe%3A%20Locking%20Hidden%20Columns%2FRows%20so%20they%20cannot%20be%20unhidden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835634%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402806%22%20target%3D%22_blank%22%3E%40mdobbin99%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20you%20protect%20the%20sheet%2C%20hidden%20rows%20and%20columns%20cannot%20be%20unhidden.%20If%20the%20sheet%20has%20data%20entry%20cells%2C%20you%20first%20need%20to%20format%20each%20of%20these%20cells%20to%20be%20Unlocked.%20That%20is%20a%20tick%20box%20on%20the%20Protection%20tab%20of%20the%20Format%20dialog.%20Untick%20the%20%22Locked%22%20tick%20box%20for%20each%20cell%20that%20people%20should%20be%20able%20to%20edit.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20523px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130004i9CD35C9F3F4828DF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-04_10-08-01.png%22%20title%3D%222019-09-04_10-08-01.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20use%20the%20Protect%20Sheet%20command%20on%20the%20Review%20ribbon.%20You%20can%20add%20a%20password%20so%20that%20the%20sheet%20can%20only%20be%20unprotected%20with%20the%20correct%20password.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20535px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130005iD6F0CEF4838CFB6A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-04_10-08-22.png%22%20title%3D%222019-09-04_10-08-22.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBe%20aware%2C%20though%2C%20that%20this%20protection%20is%20just%20to%20prevent%20inadvertent%20changes%2C%20not%20malicious%20intent.%20This%20password%20can%20be%20broken%20if%20a%20person%20puts%20sufficient%20energy%20into%20the%20attempt.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835641%22%20slang%3D%22en-US%22%3ERe%3A%20Locking%20Hidden%20Columns%2FRows%20so%20they%20cannot%20be%20unhidden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThank%20you%20very%20much%20for%20the%20screen%20shots%20and%20the%20instructions.%20This%20worked%20perfectly%20and%20was%20the%20first%20set%20of%20instructions%20on%20this%20topic%20that%20actually%20made%20sense.%20Thanks%20again%2C%20Michael%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835679%22%20slang%3D%22en-US%22%3ERe%3A%20Locking%20Hidden%20Columns%2FRows%20so%20they%20cannot%20be%20unhidden%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402806%22%20target%3D%22_blank%22%3E%40mdobbin99%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20the%20feedback.%20Please%20mark%20my%20answer%20above%20(not%20this%20one)%20as%20the%20%22Best%20Response%22%2C%20so%20others%20can%20find%20it%20more%20easily.%3C%2FP%3E%3C%2FLINGO-BODY%3E
mdobbin99
New Contributor

I have an excel that I would like to lock some rows and columns so they cannot be unhidden.  not just so they cannot be changed/edited, but stay hidden.

is there a way to do that (have not been able to find one yet :))

Thanks!

2 Replies
Solution

Hello @mdobbin99,

 

if you protect the sheet, hidden rows and columns cannot be unhidden. If the sheet has data entry cells, you first need to format each of these cells to be Unlocked. That is a tick box on the Protection tab of the Format dialog. Untick the "Locked" tick box for each cell that people should be able to edit.

2019-09-04_10-08-01.png

 

Then use the Protect Sheet command on the Review ribbon. You can add a password so that the sheet can only be unprotected with the correct password.

 

 

2019-09-04_10-08-22.png

 

 

Be aware, though, that this protection is just to prevent inadvertent changes, not malicious intent. This password can be broken if a person puts sufficient energy into the attempt.

 

 

@Ingeborg Hawighorst 

 Thank you very much for the screen shots and the instructions. This worked perfectly and was the first set of instructions on this topic that actually made sense. Thanks again, Michael 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies