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.
Edit the Active Cell in Excel for Mac
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.
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.