Use the macro function to have excel follow exactly what you want to do. Hit record macro do exactly what you want to do then hit stop recording. You can then set this as a shortcut command to do the functions over and over again as a simple command of your choosing.
Cheers!