Command-D: Duplicate the selected files.; Command-E: Eject the selected disk or volume.; Command-F: Start a Spotlight search in the Finder window.; Command-I: Show the Get Info window for a selected file.; Command-R: (1) When an alias is selected in the Finder: show the original file for the selected alias.(2) In some apps, such as Calendar or Safari, refresh or reload the page.
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 Pastecommand, which is driving me crazy so I decided to do something about it.
How to locate the F4 function key in Excel. Many might have wondered, “ Where is the F4 key on Excel?” Well, this key is on the first row of the keyboard where we have the function keys. Note that function keys run from F1 to F12. The F4 key is found in between the Excel F3 function key and the Excel F5 function key. How to use F4 in Excel. Excel also works like a charm now. I used to have to google “F4/F2 shortcut in mac excel” every time I needed such shortcut. I made me so angry, that I even considered using my MBP always on bootcamp, and using OSX only to watch movies and stuff. Thank you very much for sharing this.
Default Excel 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.
![Excel Excel](/uploads/1/2/6/5/126546916/989853851.png)
The Excel F4 button will now work with the Redo command, which is similar to how Excel for Windows is setup.
Microsoft Excel For Macbook
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.