The F4 key saves me from retyping references, repeating formatting, and reopening the Find dialog.
If you're using Microsoft Excel on a Windows PC and enjoy using keyboard shortcuts to improve your productivity, you should definitely learn the many ways in which F4 can save you lots of time. To ...