hi
see this site. all known shortcut keys. may not include 2007. http://www.cpearson.com/excel/KeyboardShortcuts.htm
I am not aware of any shortcut key that do what you want but you can
write(or record) macros to do this and asign shortcut keys to the macros.