Forum Discussion
sorting columnes
Can I sort a double column of names with the sorting taking place A-Z maintaing the entry in the second column staying with the name in the first
As Sergei already has said, yes. Just select both columns and go through the sort.
For the record, you can sort MANY columns and keep all entries on the same row together, and you can sort by multiple criteria. For example, if you're dealing with a set of names of people in your club, along with their addresses, one column of which is CITYNAME, you could sort by City first, secondly by Last Name.
A rule of thumb you might find helpful when using Excel: If you think Excel ought to be able to do X [sort multiple columns keeping all on a row together, for example, as you did here] you can safely assume that Excel can do X. You just need to go find how it does it. It's powerful. Don't hesitate to play around.