Sorting in Excel

  golfpro 10:19 27 Jun 06
Locked

I am busy cataloging my CD collection in Excel, is there a way to sort the different lists alphabetically by either album name or artist after they have been inserted. This would also help for the future insertion of new Cd's.

  VoG II 10:22 27 Jun 06

Select the data, Data > Sort and follow the wizard.

Excel's sort feature only allows you to pick up to 3 columns to sort by - here is how to get around this. The trick is sorting by the last key first and working back to the first key. Say your data is in Columns A:E and you want to sort by A, B, C, D then E:


1. Select all of Columns A:E
2. Go to Data>Sort> sort by C then by D then by E
3. Click Sort
4. Now again with Columns A:E selected
5. Go to Data>Sort> sort by A then by B
6. Click Sort

  pj123 10:29 27 Jun 06

Good one, thanks VoG™.

In My Postings for future ref.

  golfpro 18:18 27 Jun 06

Thanks VoG a big help.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…