Forum Discussion
coraya63
Oct 27, 2019Copper Contributor
Trier sous excel
Bonjour, je suis novice sous excel. J'ai voulu enregistrer des noms avec leur adresse correspondante dans la colonne en face et tout cela sans me soucier de l'ordre. Mais maintenant j'aimerai trier...
mathetes
Oct 27, 2019Silver Contributor
Select (highlight) all the columns you want to sort. Then use Data....Sort and select the column of names as the basis for the sorting.
- PaulTipsOct 28, 2019Copper Contributor
mathetes Hi Mathetes, you are right: If you select the entire base, the ordering process works well. However, it is not necessary to select the entire base: if you select only one cell in the base and then proceed to sort the base, the process of selecting the Current Region of the selected cell is triggered automatically, and the result is the same. Therefore, it is not necessary to select the entire base but only one cell. Regards!
- mathetesOct 28, 2019Silver Contributor
Thank you, PaulTips I was only looking at the image, not at the downloaded file, so didn't realize it was actually set up as a formal TABLE.... (although this still leaves me with the question "If it was that easy, why was he asking the question in the first place?") 🙂