Copier une cellule qui contient une formule

%3CLINGO-SUB%20id%3D%22lingo-sub-2160494%22%20slang%3D%22fr-FR%22%3ECopy%20a%20cell%20that%20contains%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160494%22%20slang%3D%22fr-FR%22%3E%3CP%3EI%20want%20to%20copy%20a%20cell%20that%20contains%20a%20formula%3C%2FP%3E%3CP%3EOne%20of%20the%20parameters%20of%20the%20formula%20must%20remain%20FIXE%2C%3C%2FP%3E%3CP%3Ehow%20to%20avoid%20incrementalation%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2160494%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2160530%22%20slang%3D%22en-US%22%3ERe%3A%20Copier%20une%20cellule%20qui%20contient%20une%20formule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F976571%22%20target%3D%22_blank%22%3E%40PierreD627%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20take%20a%20very%20simple%20example.%3C%2FP%3E%0A%3CP%3EIn%20C1%2C%20you%20have%20the%20formula%20%3DA1%2BB1%3C%2FP%3E%0A%3CP%3EIf%20you%20copy%20this%20formula%20to%20C2%2C%20it'll%20become%20%3DA2%2BB2.%3C%2FP%3E%0A%3CP%3EBut%20if%20you%20change%20the%20formula%20in%20C1%20to%20%3D%24A%241%2BB1%20and%20copy%20it%20to%20C2%2C%20it'll%20become%20%3D%24A%241%2BB2.%3C%2FP%3E%0A%3CP%3EThe%20%24%20characters%20in%20%24A%241%20fix%20the%20reference%20to%20A1.%3C%2FP%3E%0A%3CP%3EFor%20more%20information%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fbasculer-entre-les-r%25C3%25A9f%25C3%25A9rences-relatives-absolues-et-mixtes-dfec08cd-ae65-4f56-839e-5f0d8d0baca9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EBasculer%20entre%20les%20r%C3%A9f%C3%A9rences%20relatives%2C%20absolues%20et%20mixtes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Je désire copier une cellule qui contient une formule

L'un des paramètre de la formule doit reste FIXE, 

comment faire pour éviter l'incrémentation?

2 Replies

@PierreD627 

Let's take a very simple example.

In C1, you have the formula =A1+B1

If you copy this formula to C2, it'll become =A2+B2.

But if you change the formula in C1 to =$A$1+B1 and copy it to C2, it'll become =$A$1+B2.

The $ characters in $A$1 fix the reference to A1.

For more information, see Basculer entre les références relatives, absolues et mixtes 

@PierreD627 

Il suffit d'ajouter un $ devant la lettre et le chiffre

Merci