![]() ![]() There are several reasons behind problems related to shortcut keys. Shortcuts are important in Excel and help us in speeding up routine tasks. This change of macro shortcuts will solve any issues related to Excel shortcuts. Change the shortcut key according to your needs and then click OK.Click on the Developer tab at the top of the screen and open the macro in the newly appeared window.The following section will explain the procedure of checking your macros shortcut keys for troubleshooting such problems. There is a possibility that the user might assign a shortcut key to their macro which contradicts the usual shortcuts and thus results in problems while using that shortcut key. Microsft Excel provides its users with the capability of assigning a shortcut key to start the macro. ![]() Macros enable us to record a set of steps that we perform on regular basis and then automate it. Macros are an important part of Microsft Excel and are used to avoid doing repetitive tasks. Also read: How to Turn OFF Scroll Lock In Excel? Issue # 5 Excel Shortcut not working because the same shortcut is assigned to a macro Thus while using Excel on MacBook, one must search for shortcuts applicable to it rather than trying shortcuts on the windows keyboard. The comparison between some excel shortcuts is given in the following table for demonstration. The function of the command key is similar to that of the control key on the windows keyboard, however, shortcuts involving the Alt key get altered significantly. The below diagram shows the illustration of editing a cell using Fn + F11 similarly to open the chart press Fn +11 instead of just the F11 key.įurthermore, with all media keys press the Fn key this will resolve the problem. This addition of the function key deactivates the media keys for time being and thus Excel shortcuts will work as if there are no media keys.įor instance, in order to edit a cell press Fn + F2 instead of just F2 on the keyboard. The interference of media keys in the working of Excel shortcuts can be quickly rectified by the addition of a function key to the already known combination of keys. So how to fix it? Solution 1: Use Function Key in Combination with Media Key Similarly, the F11 key is used to open charts in Excel but with media keys on a keyboard, it won’t work. Such as, normally F2 shortcut key is used to edit a cell in Excel but in the presence of media keys pressing F2 decrease the brightness of your screen instead of editing a cell. In addition, these keys are set as primary by default. The media keys could be handy when we are watching some videos or movies., etc but on the other hand, when we are working in Excel it conflicts with Excel’s shortcut keys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |