Test out the F4 key in Excel to make sure it’s working, and you should be good to go. Repeat the steps above for the F4 key, replacing “Control+U” with “Command-T” and “F2” with “F4”.ġ2.
If it works, you’re done with the F2 key. Checkout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more. Some laptops have Fn Lock Mode so that you dont have to press Fn with the the function keys. It should now cause you to enter the selected cell (like in Excel on PCs) instead of copying the cell.ġ1. You might also need to press the Fn (function) key in combination with the function keys F1 to F12. Change the Exceptions drop down to “Only” instead of “Not” and then type “Excel,Microsoft Excel” in the Exceptions box.ġ0. You’ll get a “Some applications might not respond properly to your input with the key combination “F2″ being reserved as a hot key.” message. Click on the Triggers tab and click in the “Hot Key” field. If you did it correctly, you should now see “” in the box.Ĩ. In Windows, restart your computer and press the key displayed before the startup to open the BIOS/UEFI and activate the corresponding function. On a Mac, you can find the Keyboard settings via the System Preferences.
#F4 KEY FOR EXCEL MAC MAC#
hold down the Control key and hit the U key). You can activate the function keys on both Mac and Windows keyboards without using the Fn key. The F4 key has a lot of different uses in Excel. Click on the Keys tab, click in the empty text box, and then type Control+U (i.e. Although that was not a really big thing for many Mac users, it does help the users who often use the. In the Inspector on the right side of the Configuration page, name the item “Excel F2” where it currently says “Keystrokes.”ħ. Right click in the “Hidden” section on of the Items section, hover over Smart Item, and then click on Keystrokes.Ħ. Here’s what the gears icon (on the far left) looks like in the Mac menu bar:ĥ. In the Items section on the left side of the Configuration page, right click on the “Menu Bar (Left)” section, hover over Control in the popup menu, and select “Customize configuration…” This will add a little gears icon to the shortcuts area in the top of the Mac menu bar so it’s easy to get back to Butler in the future. To give you some context, here’s what the Configuration page looks like when all of the default options have been deleted and the Excel ones have been added (per the steps below):Ĥ. Your call on how you want to handle that.) (I’m sure there are some good ones so you may want to keep some of them, but I found them getting in the way of my regular shortcuts when I initially left them in place. Click on the “Configuration” tab and delete all the default shortcuts. Open up Butler and click on the Preferences tab and check the box next to “Launch Butler on log-in” (so Butler always starts up automatically in the background).ģ.
#F4 KEY FOR EXCEL MAC INSTALL#
Download & install Butler from Many Tricks.Ģ.
#F4 KEY FOR EXCEL MAC HOW TO#
Here’s how to use Butler get the F2 and F4 keys to work in Excel for Macs:ġ.
0 kommentar(er)
