For today’s Stupid Microsoft Office Trick, we will be teaching Excel how to sort musical instruments into score order. This has lots of uses for musicians and music educators:
- Inventories of instruments, sheet music, CD’s, you name it
- Rosters of students, orchestra members, sub lists, and so forth
For example, suppose I have a list of sheet music for various woodwind instruments:
If I sort alphabetically by column C, I’ll get bassoon pieces first, then clarinet, flute, oboe, and saxophone. But as a musician I rarely have reason to sort things that way. I would rather have the flute pieces on the top, followed by oboe, clarinet, bassoon, and saxophone—a typical score ordering.
I’ll show you three easy steps to make this happen. I’m using Excel 2007 and Windows Vista, but I believe this feature exists in earlier versions of Excel as well. You are on your own for the exact details, unless someone cares to share in the comments section. Continue reading “MS Excel music hack: Sort musical instruments by score order”