For many things, F4 repeats the last thing you did, whether it's put a border on a cell, change its colour, insert a row, right-align etc.
It's a bit hit and miss—it doesn't, for example, repeat data entry. But it's often useful and easier to access than the corresponding buttons would be.

Trouble with formulae? Lookups not going so well? The Wizard of Excel can help. Dan Harrison offers practical tips and examples, as well as Excel training and consulting.