- Related videos
- Switching Between Workbooks in Excel
- NMSU KnowledgeBase
- How to Switch Between Worksheets in Excel
There is a command called Switch Windows in Excel, by using it, you can quickly switch between multiple workbooks. See screenshot:.
With the above method, you need to toggle the tabs time and time again when you do other operations, here, I can help you to add the Switch Windows command to the Customize Quick Access Toolbar , and this will cut down your clicks. Please do as follows:. In the opened workbook, click the Customize Quick Access Toolbar in the Excel window, and then choose More Commands from the menu, see screenshot:. Then click OK button, and you can see the Switch Windows command has been displayed in the Quick Access Toolbar , and you can switch between the workbooks easily with one click.
If you like to use the keyboards, here also have shortcut keys for you to quickly toggle between multiple workbooks. If you have Kutools for Excel , with its Navigation utility, you can quickly switch between multiple workbooks and worksheets. After installing Kutools for Excel , please do as following steps:. To know more about this powerful Navigation feature of kutools for Excel. Download and free trial Kutools for Excel Now!
Switching Between Workbooks in Excel
If you have installed Office Tab in your computer, it helps you view and edit multiple files within a single tabbed window, to know more about Office Tab Office Tab and download it free trial in 30 days. After installed Office Tab , and open multiple workbooks, you will see all the workbook names have been displayed within a single tabbed window as following screenshot shown, and then you can quickly switch among them by a click. Press and release the PgUp key on the keyboard. To move another sheet to the left press and release the PgUp key a second time.
Select the Edit menu bar option. Select Find in the list.
Choose the Go To Click OK or press the Enter key on the keyboard. Other Ways to 'Go To'.
The Go To command can also be activated with these keyboard shortcuts:. By pressing the F5 key on the keyboard. Storing Cell References for Reuse.
Type in the cell reference of the desired destination in the Reference line of the dialog box. Click on the OK button or press the Enter key on the keyboard. The black box that surrounds the active cell should now jump to the new active cell.
How to Switch Between Worksheets in Excel
Navigating With the Name Box. Comments To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key. You must select the row starting with the active cell. After pressing Return, move selection, select the direction you want to move in. Use charts F11 Insert a new chart sheet. Excel Shortcuts Comments