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.
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)
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel. And paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the. Using the View - Customize Toolbars & Menus menu item (in Excel 2008; View - Toolbars - Customize Toolbars/Menus in Excel 2004), you can change the shortcuts on your Mac to match those on your PC.
- Click Add
- Click OK to reassign the Paste command to the Redo command.
The Excel 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.
![Excel Excel](https://content.edupristine.com/images/ca/Hide_and_unhide_ribbon_menu.jpg)
Switching to a Mac has its advantages but Excel shortcuts isn’t one of them. The main gripe I have is that keyboard shortcuts should be the same in every version of Excel, yet the Windows and Mac worlds are light-years apart. The F2 key is a fundamental shortcut I learned early in my Excel life. It edits the active cell and positions the cursor at the end of the cell contents.
You want to edit a formula, hit the F2 key. But wait! In Excel for Mac the F2 key cuts text from the active cell. How could they do this? What were they thinking? Window users are screwed when it comes to keyboard shortcuts in Excel for Mac. Remember that well.
F2 Equivalent In Mac
Edit the Active Cell in Excel for Mac
Excel Mac F2 Edit
CONTROL+U is the new F2 when you’re using Excel with a Mac. If you want to edit the active cell use the keyboard shortcut CONTROL+U.
Excel F2 Shortcut
Malware cleaning for mac. If you use F2 to edit a cell on a Mac, remember your screwed, and think FU. Then take control of the situation and use CONTROL+U to edit that cell and get on with your life.
No related posts.