With only two workbooks open it will toggle between them quickly and is faster than using Switch Windows from the QAT. The keyboard shortcut Ctrl+Tab will move to the next window. Did I mention that? Use a Keyboard Shortcut to Switch Windows Now you’ve saved yourself one click and any associated aggravation every time you want to switch workbooks in Excel 2010. You can move it up or down according to where you would like it placed on the QAT toolbar. Under Choose commands from, select All Commands from the drop-down list, scroll down and select Switch Windows, then click the Add> button to move that command to the right-hand window.
In the Excel Options dialog box (shown below) the Quick Access Toolbar should be selected in the left pane. In Excel 2010 right-click the menu, then select Customize Quick Access Toolbar from the pop-up menu. Add the Switch Windows Command to the Quick Access Toolbar Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cells are blank, move to the last cell in the row or column. So I added the Switch Windows command to the Quick Access Toolbar in Excel 2010 and now have my customary two clicks back. Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. This doesn’t seem like a big deal, but it bugs the heck out of me. In the menu conflagration for Excel 20 it’s three clicks: View, Switch Windows, then pick the workbook.
To Open a Workbook: Click the Office Button and select Open, or press