Home

Excel sheet protection

%3CLINGO-SUB%20id%3D%22lingo-sub-212109%22%20slang%3D%22en-US%22%3EExcel%20sheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212109%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%201%20excel%20file%20.xlsx%20with%20Office%202016%20with%26nbsp%3B2%20Sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20protect%20the%20view%20of%20both%20these%20sheets%20but%20with%202%20different%20passwords%20so%20that%20someone%20can%20see%20only%20the%20first%20sheet%20and%20others%20can%20see%20only%20the%20second%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EDiego%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-212109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213305%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213305%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3BSatyajit%2C%3C%2FP%3E%3CP%3Ethanks%20for%20your%20idea%2C%20but%20I%20need%20something%20where%20people%20can%20see%20the%20data%20only%20with%20their%20password.%20I%20can't%20ask%20them%20to%20change%20the%20color%20of%20the%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20else%20have%20any%20idea%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EDiego%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213031%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20protection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213031%22%20slang%3D%22en-US%22%3EIt%20is%20doable%2C%20but%20your%20users%20need%20to%20do%20one%20extra%20step%20to%20view%20the%20contents.%3CBR%20%2F%3E%3CBR%20%2F%3EA1%20Cell%20will%20be%20visible%20to%20all%2C%20but%20not%20the%20others.%3CBR%20%2F%3EStep%3A%3CBR%20%2F%3E1.Fill%20in%20the%20workbook%20and%20sheets%20as%20required%3CBR%20%2F%3E2.Ctrl%2BA%20select%20all%20the%20content%20%5Ctext%20set%20white%20as%20the%20font%20color%2C%20it%20makes%20it%20invisible%3CBR%20%2F%3E3.%20Review-%26gt%3BProtect%20sheet%2C%20remove%20all%20the%20check%20boxes%20and%20set%20the%20password.%3CBR%20%2F%3E4.%20Repeat%20the%20steps%20for%20each%20sheet%20and%20separate%20passwords%20can%20be%20set%20on%20each%20one.%3CBR%20%2F%3E%3CBR%20%2F%3EThey%20can%20move%20the%20boxes%20and%20view%2C%20but%20not%20the%20selected%20cell%20hence%20the%20data%20remains%20hidden.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20the%20users%20unlock%2C%20they%20need%20to%20just%20select%20all%20and%20change%20the%20color%20back%20to%20automatic.%3C%2FLINGO-BODY%3E
Highlighted
Diego Terzi
New Contributor

Hello,

I have 1 excel file .xlsx with Office 2016 with 2 Sheets.

 

I need to protect the view of both these sheets but with 2 different passwords so that someone can see only the first sheet and others can see only the second sheet.

 

Thanks,

Diego

2 Replies
It is doable, but your users need to do one extra step to view the contents.

A1 Cell will be visible to all, but not the others.
Step:
1.Fill in the workbook and sheets as required
2.Ctrl+A select all the content \text set white as the font color, it makes it invisible
3. Review->Protect sheet, remove all the check boxes and set the password.
4. Repeat the steps for each sheet and separate passwords can be set on each one.

They can move the boxes and view, but not the selected cell hence the data remains hidden.

When the users unlock, they need to just select all and change the color back to automatic.

Hi Satyajit,

thanks for your idea, but I need something where people can see the data only with their password. I can't ask them to change the color of the text.

 

Anyone else have any idea?

 

Thanks,

Diego

Related Conversations