• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to open 2 Excel files simultaneously on the screen for easy comparison

0 Comments

How to open 2 Excel files simultaneously on the screen for easy comparison: In Excel, sometimes you need to compare content to cross-reference data between statistical tables, or process 2 data files at the same time. Therefore, you need to open 2 Excel files on the same screen to make it easier to view content and data. In Word, you can open 2 Word files at the same time using the split-screen feature. But Excel does not integrate this feature. Read the article from Buffcom.net to learn how to open 2 Excel files simultaneously on the screen for easy comparison and data analysis.

Method 1: Open 2 Excel files simultaneously on the screen using the built-in feature in Excel

For Microsoft Excel 2013 and later versions, the feature of opening multiple files at the same time on Excel is supported. Users can easily open multiple Excel files at the same time by double-clicking on the Excel files to be opened. The screen will simultaneously display multiple Excel files that you have opened.

How to open 2 Excel files simultaneously on the screen for easy comparison

How to open 2 Excel files simultaneously on the screen for easy comparison

For versions of Excel older than Excel 2010

First, you open one Excel file. Then, hold down the Shift key and click on the Excel icon on the Taskbar to open another Excel window. Next, on the new Excel window that just opened, click on the Office icon or File tab to select and open another Excel file.

With this method, you can view 2 Excel files on the screen at the same time. However, with this method, you can view multiple Excel files at the same time but it is difficult to track or analyze data in 2 Excel worksheets simultaneously. The next method of opening 2 Excel files will help you to analyze data in a more clear and detailed way in 2 Excel files.

Method 2: Open 2 Excel files simultaneously on the screen using the multi-screen feature in Windows

Step 1: Open the 2 Excel files you want to view simultaneously.

Step 2: Open the Excel file you want to view first. Then use the combination of the Window key + right arrow key (or at the first Excel window, hold down the mouse on the file and drag the mouse cursor to touch the right edge of the computer screen). At this point, the screen will display as illustrated below. Then, the Excel file will be minimized and displayed on the right side of the screen.

How to open 2 Excel files simultaneously on the screen for easy comparison

How to open 2 Excel files simultaneously on the screen for easy comparison

Step 3: Click on the second Excel file you want to display on the screen to view simultaneously. At this point, the screen will return the result as illustrated below.

How to open 2 Excel files simultaneously on the screen for easy comparison

How to open 2 Excel files simultaneously on the screen for easy comparison

If it does not appear as illustrated above, click on the second file and then press the Windows key + left arrow key, or right-click on the file and drag the mouse cursor to touch the left edge of the screen.

Opening two Excel files on one screen can greatly enhance your productivity and streamline your work processes. We have demonstrated two methods to achieve this, using either Excel’s native feature or Windows’ multiple monitors feature. Depending on your Excel version and personal preference, you can choose the method that suits you best. With this knowledge, you can now easily compare and analyze data across two Excel files, saving time and effort in the process.

Rate this post
34
271 Views
How to fix the error of not being able to copy data in Excel filePrevHow to fix the error of not being able to copy data in Excel fileMarch 13, 2023
How to number pages without starting from 1March 13, 2023How to number pages without starting from 1Next

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
Products
  • Microsoft Office Home And Business 2019 CD Key for MAC Global Microsoft Office Home And Business 2019 CD Key for MAC Global
    Rated 4.95 out of 5
    $30.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Project Professional 2024 Project Professional 2024 $33.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.