How to open two Excel workbooks in separate windows

MS Excel Helps users record data in the form of rows and columns and then perform various analyzes on it. It is important to note that when you try to open multiple files in Excel, they do not open in separate windows. Only one file can be seen at a time, and you must then switch between different Excel windows using the Switch Window option in the View tab.

If you are one of the people who performs most of the tasks, then you may need to be able to open and access both Excel files in different windows at the same time.

In this article, we discussed a method to open two or more Excel files in separate windows.

Add Office Tab to Excel

For this method, you need to install an

add-in/extension for Excel called Office Tab. This utility has an option to open the spreadsheet in a new window.

1. Click this link to download the trial version of

Office Tab for Windows.

NOTE: It comes with a one-month free trial, after which you need to purchase to use it.

2. Go to the location where you downloaded this file.

Double-click this setting to start the installation process.

Click Yes when prompted by User Account Control .

Accept the End User License Agreement. Then, click

Install.

Wait for the installation to complete.

3. After installing Office Tab, open any

Excel file.

Then, click on the "

File" menu in the top ribbon.

Select Office Tab in the panel on the left.

Click the Excel tab tab on the right

.

#4. In the window that opens, select the

General and Positions tabs.

Here,

Uncheck the box next to the option Single-window mode.

Click

OK.

#5. Close the Excel file.

Now open

two different workbooks that you want to view in different windows.

You will see an

alternative tab for a separate Excel worksheet.

Right-click the spreadsheet tab and select the Open in new window option in the context menu.

#The Excel worksheet will now open in a separate window. You can then drag the windows to the left and right sides of the desktop to view the contents of both worksheets.

The above is the detailed content of How to open two Excel workbooks in separate windows. For more information, please follow other related articles on the PHP Chinese website!