Raccourcis Excel pour trier une colonne par ordre décroissant

%3CLINGO-SUB%20id%3D%22lingo-sub-2377557%22%20slang%3D%22fr-FR%22%3EExcel%20shortcuts%20to%20sort%20a%20column%20in%20descending%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377557%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20starting%20to%20know%20Excel%20shortcuts%20when%20I'm%20working%20on%20a%20simple%20database.%3C%2FP%3E%3CP%3EBut%20I%20bug%20on%20a%20shortcut%3A%3C%2FP%3E%3CP%3EIn%20the%20same%20way%20as%20the%20Ctrl%20shortcut!%20separates%20the%20thousands%20of%20an%20encrypted%20column%2C%20I'm%20looking%20for%20a%20shortcut%20that%20allows%20you%20to%20sort%20these%20numbers%20in%20ascending%2Fdecreasing%20order%20with%20the%20ctrl%20key.%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20please%3F%20As%20an%20attachment%20to%20my%20example.%3C%2FP%3E%3CP%3EAttention%20I%20speak%20well%20of%20a%20simple%20database%3A%20neither%20a%20tcd%2C%20nor%20a%20painting.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2377557%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377575%22%20slang%3D%22en-US%22%3ERe%3A%20Raccourcis%20Excel%20pour%20trier%20une%20colonne%20par%20ordre%20d%C3%A9croissant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060532%22%20target%3D%22_blank%22%3E%40Laetitia2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMalheureusement%2C%20Excel%20ne%20dispose%20pas%20de%20raccourcis%20pour%20trier%20une%20plage.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

 

Je commence à connaître les raccourcis Excel, lorsque je travaille sur une base de données simple.

Mais je bug sur un raccourci:

De la même manière que le raccourci Ctrl+! permet de de séparer les milliers d'une colonne chiffrée, je recherche un raccourci qui permet de trier ces chiffres par ordre croissant/décroissant avec la touche ctrl.

Pouvez-vous m'aider svp? En pièce jointe mon exemple.

Attention je parle bien d'une base de donnée simple : ni d'un tcd, ni d'un tableau.

Merci pour votre aide!

 

2 Replies

@Laetitia2021 

Malheureusement, Excel ne dispose pas de raccourcis pour trier une plage.

You can do this two ways.

1 - Alt-D, S, then tab multiple times until you get to the order field, and press "L" or down arrow to change that sort order, then press enter

2 - Alt, H, S, O