Skip to main content

How to switch between multiple workbooks?

In our daily work, we may work with multiple workbooks, to toggle between two workbooks may be easy for us, but, if there are multiple opened workbooks needed to be switched between from time to time, how could you switch between these multiple opened workbooks?

Switch between multiple opened workbooks with Switch Windows command

Switch between multiple opened workbooks with Quick Access Toolbar

Switch between multiple opened workbooks with shortcut keys

Switch between multiple opened workbooks with kutools for Excel

Switch between multiple opened workbooks with Office Tab


Switch between multiple opened workbooks with Switch Windows command

There is a command called Switch Windows in Excel, by using it, you can quickly switch between multiple workbooks.

In one of your opened workbook, click View > Switch Windows, and then from the Switch Windows drop down list, choose the workbook that you want to switch. See screenshot:

doc switch multipl workbooks 1


Switch between multiple opened workbooks with Quick Access Toolbar

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:

1. In the opened workbook, click the Customize Quick Access Toolbar in the Excel window, and then choose More Commands from the menu, see screenshot:

doc switch multipl workbooks 2

2. In the Excel Options dialog box, click Quick Access Toolbar from the left pane. Then select All Commands from the drop-down list under Choose commands from, scroll down and select Switch Windows, then click the Add>> button to move that command to the right-hand window. See screenshot:

doc switch multipl workbooks 3

3. 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.

doc switch multipl workbooks 4


Switch between multiple opened workbooks with shortcut keys

If you like to use the keyboards, here also have shortcut keys for you to quickly toggle between multiple workbooks.

Holding the Ctrl + Tab keys together can help you move from one window to the next window, if you have only two windows, this method will be faster. However, with more than two opened workbooks, this method doesn’t work very well because it will cycle through each opened workbook.


Switch between multiple opened workbooks with kutools for Excel

If you have Kutools for Excel, with its Navigation utility, you can quickly switch between multiple workbooks and worksheets.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. 

After installing Kutools for Excel, please do as following steps:

1. Click Kutools > Navigation, see screenshot:

2. In the Navigation pane, click Workbook & Sheet icon, and you can see all the opened workbooks are listed into the list box, you can switch between them quickly and conveniently.

Note: In the Navigation pane, you can also sort the opened workbooks in ascending or descending order with the doc switch multipl workbooks 7 and doc switch multipl workbooks 8 icons.

To know more about this powerful Navigation feature of kutools for Excel.

Download and free trial Kutools for Excel Now !


Switch between multiple opened workbooks with Office Tab

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.


Demo: Switch between multiple opened workbooks

Kutools for Excel and Office Tab are useful tools for most Microsoft users. Click to free trial them !

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations