The F4 function is used for one of two tasks: 1) Cycle between absolute and relative references (in a formula) and 2) Repeat the last action. These are the ways by which you’ll be able. The Redo Shortcut key which is use for Apple and Mac Operating System. Tip: The shortcut key for Excel or the shortcut key in Word to redo an undo is Ctrl+Y most of the times (and ⌘+Y on Mac).
Every time I want to press F4 on my MacBook Pro also have to press the fn button. I'm using a program that uses the F4 key as an important shortcut which I use heavily. Method for using F4 key without pressing function button on MacBook Pro.