Thus, you have added the button in the quick access toolbar. After that, click the button “OK” in the window.Next drag the scroll bar until you see the option “Switch Windows”.In the “Excel Options” window, choose the option “All Commands” in the “Choose commands from” window.And then choose the option “More Commands” in the menu.Click the small arrow in the quick access toolbar.Method 3: Add a Button in the Quick Access ToolbarĮxcept for the above 2 methods, you can also add a button in the quick access toolbar. When you click in the option, you will immediately switch to the workbook. And then click the button “Switch Windows” in the toolbar.You need to use the “Switch Windows” feature in the toolbar in this method. And you can try to use the two different combos in your computer. Therefore, in using this method, you can not only switch between Excel workbooks, you can also move to other applications.
And at this moment, you can release the button “Alt”. Keep holding the button “Alt”, and press the “Tab” until the name of the target workbook appear in the list. Now you can see this list as the image show below. And then press the button “Tab” on the keyboard. If you continue using this combo, you will switch to other workbooks one by one.ĭifferent from the above combo, if you press this shortcut combo, you will switch between two certain windows. Therefore, when you press this combo, you can switch between those workbooks quickly.
#Mouseless excel windows
This shortcut keys can switch between the different windows of the same application. And there are two different combos that you can apply. Here you can also use shortcut keys to switch between workbooks. Shortcut keys combos are a very useful tool in Excel. In the image below, we have opened 3 workbooks.īelow are the 3 methods that can help you to finish this task quickly. And switch between multiple workbooks quickly can save you a lot of time. If you need to deal with many Excel workbooks at the same time, you will certainly switch between those workbooks. Here we will demonstrate 3 methods to switch between multiple Excel workbooks. You will certainly need to work with many workbooks.
0 kommentar(er)
