The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it.
Default F4 Keyboard Assignment in Excel for Mac
There are four keyboard shortcuts assigned to the Paste command in Excel for Mac — Shift+Del, Control+V, F4, and Command+V.
Overkill, don’t you think? So I’m thinking the F4 button can be reassigned with no problems, unless, of course, you’re in the habit of using the F4 key for the Paste command.
Reassign the F4 button in Excel for Mac
- Select the Tools menu, and click Customize Keyboard…
- In the Categories: box select Edit
- In the Edit box, select Redo
- Select the Press new shortcut key: box
- Press the keyboard combination fn+F4 key (or just F4 key if you’ve setup the Mac function keys normally)
- Click Add
- Click OK to reassign the Paste command to the Redo command.
The F4 button will now work with the Redo command, which is similar to how Excel for Windows is setup.
Note: You have to make this change to each version of Excel for Mac. For instance the above procedure was done in Excel 2011, but my Excel 2008 version of Excel for Mac wasn’t affected and has to be done separately.