Home

excel ne verrouille que certaines cellules

%3CLINGO-SUB%20id%3D%22lingo-sub-792565%22%20slang%3D%22fr-FR%22%3Eexcel%20only%20locks%20certain%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792565%22%20slang%3D%22fr-FR%22%3EHello%2C%20When%20I%20use%20the%20function%20protect%20the%20sheet.%20my%20cell%20sizes%20are%20well%20locked%2C%20however%20some%20cells%20remain%20modifiable.%20Does%20anyone%20know%20if%20it's%20a%20setting%20problem%20or%20excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-792565%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792595%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20ne%20verrouille%20que%20certaines%20cellules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387872%22%20target%3D%22_blank%22%3E%40GGabds35%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20it's%20a%20setting%20in%20Format%20Cells%2C%20Protection%2C%20before%20Protect%20Sheet%20is%20applied.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792621%22%20slang%3D%22fr-FR%22%3ERe%3A%20excel%20only%20locks%20certain%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792621%22%20slang%3D%22fr-FR%22%3Eyes%20it%20works%20from%20line%201%20to%2015%2C%20but%20not%20then%20...%3C%2FLINGO-BODY%3E
New Contributor
Bonjour, Quand j’utilise la fonction protéger la feuille. mes formats de cellules sont bien verrouillés, cependant certaines cellules restent modifiables. Quelqu'un sait-il si c'est un problème de paramétrage ou excel?
2 Replies
Highlighted

@GGabds35 

I believe it's a setting in Format Cells, Protection, before Protect Sheet is applied. 

Highlighted
oui ça fonctionne de la ligne 1 a 15, mais pas ensuite...
Related Conversations
Advice please
dandc910 in Excel on
1 Replies
Formulas Excel assistance
DEAF_DWJr98 in Excel on
4 Replies
Rearrangement and initials.
Ocasio27 in Excel on
3 Replies
Page vs Image Scaling
DarylA in Excel on
0 Replies
return max in date range based on X column #
mryno in Excel on
1 Replies