Besoin d'aide pour les formules

%3CLINGO-SUB%20id%3D%22lingo-sub-1587863%22%20slang%3D%22fr-FR%22%3ENeed%20help%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587863%22%20slang%3D%22fr-FR%22%3EGood%20evening%20to%20you%20all.%20%3CBR%20%2F%3E%20I%20need%20help%20on%20how%20to%20protect%20or%20hide%20formulas%20on%20excel.....%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587863%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588914%22%20slang%3D%22en-US%22%3ERe%3A%20Besoin%20d'aide%20pour%20les%20formules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759017%22%20target%3D%22_blank%22%3E%40Affouda_93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20protect%2C%20go%20to%20the%20Review%20tab%20and%20select%20Protect%20Sheet.%20Check%20the%20items%20you%20want%20to%20protect%20or%20just%20let%20it%20default.%20Put%20in%20a%20password%20or%20don't.%20For%20hiding%20formulas%2C%20you%20can%20go%20to%20the%20View%20tab%20and%20deselect%20the%20formula%20bar%20under%20%22show%22%2C%20or%20you%20can%20hide%20an%20entire%20column%20or%20row%2C%20if%20that's%20what%20you%20meant.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588956%22%20slang%3D%22de-DE%22%3ESubject%3A%20Besoin%20d'aide%20pour%20les%20formules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588956%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759017%22%20target%3D%22_blank%22%3E%40Affouda_93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIl%20existe%20diff%C3%A9rentes%20mani%20%C3%A9res%20d'obtenir%20des%20cellules%20%2F%20colonnes%20%2F%20certaines%20zones%20%2F%20feuilles%20de%20calcul%20%2F%20etc.%3C%2FSPAN%3E%20%3CSPAN%3Epeut%20verrouiller.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EVoici%20quelques%20information%20en%20fran%20ais%20%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E(traduit%20de%20google)%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CH1%20id%3D%22toc-hId-502606226%22%20id%3D%22toc-hId-502606226%22%20id%3D%22toc-hId-502606226%22%20id%3D%22toc-hId-502606226%22%3E%3CFONT%20size%3D%223%22%3EVerrouiller%20ou%20d%C3%A9verrouiller%20des%20zones%20sp%C3%A9cifiques%20d'une%20feuille%20de%20calcul%20prot%C3%A9g%C3%A9e%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fverrouiller-ou-d%25c3%25a9verrouiller-des-zones-sp%25c3%25a9cifiques-d-une-feuille-de-calcul-prot%25c3%25a9g%25c3%25a9e-75481b72-db8a-4267-8c43-042a5f2cd93a%3Fui%3Dfr-fr%26amp%3Brs%3Dfr-fr%26amp%3Bad%3Dfr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fverrouiller-ou-d%25c3%25a9verrouiller-des-zones-sp%25c3%25a9cifiques-d-une-feuille-de-calcul-prot%25c3%25a9g%25c3%25a9e-75481b72-db8a-4267-8c43-042a5f2cd93a%3Fui%3Dfr-fr%26amp%3Brs%3Dfr-fr%26amp%3Bad%3Dfr%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESi%20vous%20trouvez%20cela%20utile%2C%20veuillez%20le%20marquer%20comme%20%22Meilleure%20r%C3%A9ponse%22%20et%20comme%20J'aime%20(cliquez%20sur%20les%20pouces%20vers%20le%20haut)%2C%20cela%20sera%20b%C3%A9n%C3%A9fique%20pour%20plus%20de%20membres%20de%20la%20communaut%C3%A9%20qui%20liront%20ici.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EJe%20sais%20que%20je%20ne%20sais%20rien%20(Socrate)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588984%22%20slang%3D%22fr-FR%22%3ERe%3A%20Need%20help%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588984%22%20slang%3D%22fr-FR%22%3EThanks%20you%20for%20your%20answer%20for%20me%2C%20but%20it's%20not%20exactly%20what%20I%20meant.%20%3CBR%20%2F%3E%20I%20whish%20to%20protect%20all%20expression%20in%20my%20sheet%20to%20avoid%20all%20modification%20offers%20them.%20%3CBR%20%2F%3E%20NB%3A%20I%20Try%20in%20English%20please%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589017%22%20slang%3D%22de-DE%22%3ERe%3A%20Besoin%20d'aide%20pour%20les%20formules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589017%22%20slang%3D%22de-DE%22%3EThere%20are%20many%20different%20ways%20to%20protect%20something%20in%20Excel%2C%20it%20depends%20on%20what%20exactly%20you%20want%20to%20protect.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20can't%20understand%20what%20you%20mean%20with%20%22I%20whish%20to%20protect%20all%20expression%20in%20my%20sheet%20to%20avoid%20all%20modification%20offre%20them.%22%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Is%20it%20not%20possible%20to%20view%20a%20worksheet%20(without%20sensitive%20data)%20so%20that%20it%20is%20easier%20for%20us%20to%20understand%20what%20you%20want%20and%20at%20the%20same%20time%20that%20you%20are%20offered%20the%20best%20possible%20solution%3F%3C%2FLINGO-BODY%3E
New Contributor
Bonsoir à tous.
J'ai besoin d'aide sur comment protéger ou masquer des formules sur excel.....
4 Replies

@Affouda_93 

To protect, go to the Review tab and select Protect Sheet. Check the items you want to protect or just let it default. Put in a password or don't. For hiding formulas, you can go to the View tab and deselect the formula bar under "show", or you can hide an entire column or row, if that's what you meant.

@Affouda_93 

 

Il existe différentes manières d'obtenir des cellules / colonnes / certaines zones / feuilles de calcul / etc. peut verrouiller. Voici quelques informations en français (traduit de google).

Verrouiller ou déverrouiller des zones spécifiques d’une feuille de calcul protégée

https://support.microsoft.com/fr-fr/office/verrouiller-ou-d%c3%a9verrouiller-des-zones-sp%c3%a9cifiq...

 

Si vous trouvez cela utile, veuillez le marquer comme "Meilleure réponse" et comme J'aime (cliquez sur les pouces vers le haut), cela sera bénéfique pour plus de membres de la communauté qui liront ici.


Nikolino
Je sais que je ne sais rien (Socrate)

Thanks you for your answer for me, but it's not exactly what I meant.
I whish to protect all expression in my sheet to avoid all modification offre them.
NB: I Try in English please
There are many different ways to protect something in Excel, it depends on what exactly you want to protect.

I can not understand what you mean with "I whish to protect all expression in my sheet to avoid all modification offre them."

Is it not possible to view a worksheet (without sensitive data) so that it is easier for us to understand what you want and at the same time that you are offered the best possible solution?