In Excel 2003 you can press f4 which will repeat the last thing you've done,
in 2007 this doesnt work. Does anyone know the keyboard short cut in 2007?