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.

During the past few months, I’ve had the opportunity to do some traveling with my instruments, on a number of airlines and through quite a few airports. Here are a few thoughts on getting instruments safely and smoothly to your destination.
It seems like there’s very little I do these days without a computer. Here are some ways I have used a laptop to boost my practice sessions.