I've always played with the help of Dwarf Therapist, a second program that helps you manage everything spreadsheet-style.
Endlessly fiddling with Dwarf Therapist is not a rewarding use of anyone's time.
I think they're adding a similar feature to the premium release.