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.' To change the background color of a cell, select the cell that you wish to change the color of. Right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Fill tab. 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. 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. I don't think the toolbar for Mac Word 2011 is coming back unless Apple or Microsoft fix it (which I don't expect they would), so you will have to rely on the AppleScript menu option for Zotero (or the keyboard shortcuts as displayed in the menu). 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. ![]() ![]() 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. Did I do something wrong, or did the latest Microsoft update actively prevent Butler from working? Office 365 + Todoist Integrations In a matter of minutes and without a single line of code, Zapier allows you to connect Office 365 and Todoist, with as many as 57 possible integrations. Are you ready to find your productivity superpowers? Microsoft Dynamics 365; Microsoft 365; Data platform; Shop for Business; Microsoft Advertising. Please note that if you purchase Todoist Premium in Microsoft's Windows Store, refunds cannot be issued by either Doist or Microsoft. Totally worth it) across iOS mobile, Mac, and Windows. The Windows app is the newest, and my only issue is. Whenever you flag an email in your Office 365 Outlook inbox, a new task will be created in a Todoist project you choose. Todoist and outlook 365 for mac. Download Todoist for free on mobile and desktop. Get organized with our apps for iPhone, Android, Mac, Windows & more.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |