SOLVED

Filtrer certaines colonnes

%3CLINGO-SUB%20id%3D%22lingo-sub-2146413%22%20slang%3D%22fr-FR%22%3EFiltering%20out%20some%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2146413%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20put%20a%20filter%20on%20my%20columns%20but%20only%20on%20some%3A%20%3CBR%20%2F%3E%20column%20A%2C%20B%2C%20C%20and%20F%20for%20example.%3C%2FP%3E%3CP%3EDo%20you%20know%20how%20to%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2146413%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2146464%22%20slang%3D%22en-US%22%3ERe%3A%20Filtrer%20certaines%20colonnes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2146464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F971011%22%20target%3D%22_blank%22%3E%40Oreo75%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20filters%20by%20hiding%20entire%20rows%2C%20so%20it%20is%20not%20possible%20to%20filter%20individual%20columns%20only.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETranslation%20by%20Google%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20filtre%20en%20masquant%20des%20lignes%20enti%C3%A8res%2C%20il%20n'est%20donc%20pas%20possible%20de%20filtrer%20uniquement%20des%20colonnes%20individuelles.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

Je souhaite mettre un filtre sur mes colonnes mais uniquement sur certaines:
colonne A, B, C et F par exemple.

Savez-vous comment faire?

 

Merci d'avance.

4 Replies

@Oreo75 

Excel filters by hiding entire rows, so it is not possible to filter individual columns only.

 

Translation by Google:

 

Excel filtre en masquant des lignes entières, il n'est donc pas possible de filtrer uniquement des colonnes individuelles.

@Hans Vogelaar 

Ok. Existe-t-il une macro qui pourrait faire cette manipulation?

Merci

@Oreo75 

Je suis désolé, mais c'est impossible pour la même raison...

best response confirmed by Oreo75 (New Contributor)
Solution

@Hans Vogelaar 

 

OK

 

Merci pour ton retour.