A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right.
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.Where Is F4 On Mac
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.
In later versions of Excel on Windows, Control + P has the same result. Use this shortcut to open the print preview window. In later versions of Excel on Windows, Control + P has the same result. 222 Excel Shortcuts for Windows and Mac. Download 200+ Excel Shortcuts. Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For a complete list of Windows and Mac shortcuts, see our side-by-side list. Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. 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 2016 for Mac Excel for Mac. Press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. Result =IMLOG2('3+4i') Base-2.
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.Excel For Mac 2016Default 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.F2 On A MacReassign 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 Mac 2019 Tutorial
*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.