Switch Between Command And Edit Mode In Excel 2011 For Mac
If you switch between Excel for the PC and Excel on the Mac (either 2004 or 2008), you probably know that there are many differences in the keyboard shortcuts between the two platforms. To make switching back and forth more seamless, you can use Excel's ability (or the system's) to remap keyboard. Switch to full screen and other two types of screen view with Kutools for Excel The third party add-in Kutools for Excel can help get 4 options to maximize the Excel work area. The options appear as a floating bar in the upper right space of the window. Oct 04, 2013 Switch between command and edit mode in Excel 2011 for MAC (former blue geo tri-angle button).
- Switch Between Command And Edit Mode In Excel 2011 For Mac Free
- Switch Between Command And Edit Mode In Excel 2011 For Mac
If you switch between Excel for the PC and Excel on the Mac (either 2004 or 2008), you probably know that there are many differences in the keyboard shortcuts between the two platforms. To make switching back and forth more seamless, you can use Excel's ability (or the system's) to remap keyboard shortcuts on the Mac to match those on the PC (or vice versa, of course). However, there's an undocumented but often-used keyboard shortcut that seems immune to these solutions - the keyboard shortcut for 'edit in cell.' On a PC, you can edit the current cell's contents by pressing F2; on a Mac, it's Control-U (F2 copies the cell's contents). I much prefer the simplicity of F2 over Control-U, however, it doesn't seem possible to customize this shortcut.
This 'edit in cell' command doesn't appear in any of Excel's menus, nor does it appear in the list of all commands in the keyboard shortcuts section of Excel's customization dialog. Google searching didn't turn up any simple solutions, so I built my own using, although any tool capable of creating macros should work fine.
Open Butler's configuration screen, and create a new Shortcuts item. Download qq 2011 for mac free. On the Keys tab, type Control-U, then switch to the Triggers tab.
In the Hot Key box, press F2 (you'll see a warning about some programs not responding if you use F2; just click 'Use F2 Anyway' to ignore the warning. Change the Exceptions pop-up from Not to Only, and in the text box below, type Excel,Microsoft Excel to specify the programs where this shortcut works. (On my Macs, I had to list both versions of the name to make this trick work in Excel 2004 and Excel 2008.) That's it; from now on, you can press F2 to edit the current cell in Excel on the Mac. I've tried this - using Butler 4.1.6 and Microsoft Excel 2008 (v12.1.2) and it doesn't work. After setting up the Keystroke in Butler (F2) to send the keystrokes CTRL-U, I restarted Excel and tried it, sadly, F2 still initiates a pasteboard copy.
Switch Between Command And Edit Mode In Excel 2011 For Mac Free
I double checked that I had the Exceptions setup properly in Butler and I did indeed. Next, to test, I removed all the exceptions, and for kicks, replaced the Keystrokes with 'This is a test'. Again, restarting Excel to test, F2.still. does a copy and ignores my Butler settings. I tried F2 in Skype and Text Wrangler (stuff I just had open) and it did type 'This is a test'. I also tried adding a delay, with no difference in results in Excel.
Switch Between Command And Edit Mode In Excel 2011 For Mac
Did I do something wrong, or did the latest Microsoft update actively prevent Butler from working?