MS Excel music hack: Sort musical instruments by score order

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:

Chaos!

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”

MS Word music hack: Automatic sharps, flats, and naturals

Here’s how to set up Microsoft Word to automatically insert sharp, flat, and natural signs for you. Instructions are for Word 2007 running on Windows Vista, and may need to be adapted slightly for your setup.

example
Continue reading “MS Word music hack: Automatic sharps, flats, and naturals”