I use the Trax editor to do just this very thing in a lot of my dynamics sims

I believe you can do that in the dope sheet too, but I have less experience with that as opposed to the Trax editor.

Good luck!