Select cells with special characteristics by using shortcut keys CTRL+SHIFT+* (ASTERISK) If you want to keep the same selection as you scroll, turn on SCROLL LOCK first. Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. Scroll the screen left or right one columnĮxtend the selection to the cell in the upper-left corner of the windowĮxtend the selection to the cell in the lower-right corner of the window With an object selected, select all objects on a sheetĪlternate between hiding objects, displaying objects, and displaying placeholders for objectsĮxtend the selection to the last cell in the current row this keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) If multiple cells are selected, select only the active cell Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)Įxtend the selection to the last nonblank cell in the same column or row as the active cellĮxtend the selection to the beginning of the rowĮxtend the selection to the beginning of the worksheetĮxtend the selection to the last cell used on the worksheet (lower-right corner) If I find something, I'll try to remember to come back and update.Very Important Shortcut Keys for MS Excel Key But I haven't used it long term to verify if any weird situations break it. Note: I've wrote this in Excel 365 just a few moments ago, and it seems to work well. But, either way, that will call the ShortcutERoutine that resides in the workbook you are in, which will direct you to the correct macro you want. What this will do: When you hit Ctrl + e from either workbook, it will run the sub ShortcutE from whatever workbook that Excel feels like using. Point Ctrl + e to the sub "ShortcutE" for both.Īpplication.Run "'" & ActiveWorkbook.Name & "'!ShortcutERoutine" Say Ctrl + e is the shortcut used in two workbooks. With this, you do not need to know what workbooks are open, or what the macros are even named. Reading this article and understanding the problem, I was able to write this to avoid the issue. EXCEL MACRO SHORTCUT KEYS CODEIf it does not match, then the code can activate the other workbook and directly run the macro in that one. If the name matches the expected name for that macro, then the code can continue to execute. Have each macro check the name of the active workbook. You could maintain the same shortcut keys by adding some code to the beginning of each macro. The easy change would be to modify the shortcut keys so they are not the same. If you tire of remembering to open the workbooks in this manner, the only other option is to start making changes to macros. Don't use the Open dialog box to load the second workbook instead double-click the workbook's icon in Windows. Since the index table maintained by Excel is created by application instance, you could get around the conflict by making sure that you open each workbook in its own instance of Excel. If the macros have the same name, the first one opened is run. Also if you have a shortcut that uses one of the built-in shortcuts, the created macro will always run before the built-in one. When you use a shortcut key, Excel looks at the index and picks the first matching shortcut in the index. This index seems to be sorted alphabetically, by workbook name. As workbooks are opened, their shortcuts are added to an internal table that functions as an index of all the shortcuts and the macro they are designated to run. Shortcut keys are "global" to the instance of the application that is running (in this case, Excel). The short answer is that there is no way to make this happen without making some changes to the macros themselves. He wonders if there is a way for Excel to treat the shortcuts independently so that if both workbooks are open the keyboard shortcuts will work harmoniously. When both workbooks are open at the same time, William never knows exactly what will run. When only one of the workbooks is open, the shortcut works great. Even though the macros are different, they are invoked by using the same keyboard shortcut. William has two workbooks, each containing macros.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |