How to Open 2 Excel Files in Separate Windows
Aug 16, · On the View tab, in the Window group, click View Side by Side. In the workbook window, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab. Note This option is available only when View Side by Side is turned on. Un-click or release the mouse button to have half of your screen covered. For the second half choose a second window and snap it to the opposite side. You can find online posts explaining how to achieve same thing with keyboard combination Start+Left/Right arrow to snap it .
Comparing two Excel files or comparing two sheets in gte same file can be tricky as an Excel workbook only shows one sheet at a time. This becomes more difficult and error-prone when you have a lot of data that needs to be compared. Thankfully, there are some exdel features in Excel that allow you to open and easily compare two Excel files. In this Excel tutorial, I will show you multiple ways to compare two different Excel files or sheets and check for differences.
If you want to compare two separate Excel files side by side or two sheets in the same workbookthere is an in-built feature in Excel to do this. This is recommended only when you have a small dataset and manually comparing these files is likely to be less time-consuming and error-prone. If you have a large dataset, I recommend using the dxcel method or the formula method covered later in this tutorial. Suppose you have two files for two different months and you want to check what values are different in these two files.
Even if you reduce the size, you always see one Excel file at the top. With the view side-by-side option, you can open two files and then arrange these horizontally or vertically. This allows you to easily compare the values without switching back and forth. As soon as you click on the View side by side option, Excel will arrange the workbook horizontally. In case you want to arrange the how to clean a gold vertically, click on the Arrange All option in the View tab.
At this point, if you scroll down in one of the worksheets, the other one would remain as is. You can change this so that when you scroll in one sheet, the other also scrolls at the same time. This makes it easier to do a line by line comparison and spot any differences. To enable Synchronous Scrolling, click on the View tab in any of the workbooks and then click on the Synchronous Scrolling option. This is a toggle how to know your psychic so if you want to turn it off, simply click on it again.
Once you have two instances open, you can arrange these side by side and then compare these. Suppose you have an Excel workbook that has two sheets for two different months Jan and Feb and you want to compare sire side by side to see how the sales per store have changed:. At this point in time, both the workbooks would have the same worksheet selected. In one of the workbooks, select sire other sheet that you want to compare with the active sheet.
When you click on New Window, it opens the same workbook again with a slightly different name. Note that these are still the same workbook. If you make any changes in any of these workbooks, it would be reflected in both. And when you close any one instance of the open file, the name would revert back to the original. So instead of doing this manually, you can use the spreadssheets of Conditional Formatting to quickly highlight how to train your shih tzu to do tricks differences in the two Excel sheets.
This method is really useful if you have two versions in two different sheets and you want to what is st alexander the patron saint of check what has changed.
Since Conditional Formatting can not refer to an external Excel file, the sheets you need to compare needs sppreadsheets be in the same Excel workbook. For this example, suppose you have a dataset as shown below for two months Jan and Feb in two different sheets and you want to quickly compare the data in these two sheets and check if the prices of these items have changed or not.
Conditional formatting highlights a cell when the given formula for that cell returns a TRUE. When conditional formatting finds any difference in the data, it highlights gef in the Jan sheet the one in which we have applied xecel conditional formatting. This method would work if want to compare two separate Excel workbook or worksheets in the same workbook.
Let me show you exceo example where I am comparing two datasets in two sheets in the same workbook. Suppose you have the dataset as shown below in a sheet called Tk and similar data in a sheet called Feband you want to know what values are different.
Copy and paste this formula for a range so that it covers the entire dataset in both the sheets. Since I have a small dataset, Hoa will only copy and paste this formula in Teo range.
The above formula uses an IF condition to check for differences. In case there is no difference in the values, it will return blank, and in case there is a difference, it will return the values from both the sheets in separate lines in the same cell. The good thing with this method is that it only gives you the differences and show you exactly what the difference is.
In this example, I can easily see that the price in cell B4 and B8 are different as well as the exact values in hlw cells. Suppose you have two sheets Jan and Feb and you want to compare and highlight differences in the Jan sheet, you can use the below VBA code:.
The above code uses the For Next loop to go through each cell in the Jan sheet the entire used range and sidde it with the corresponding cell in the Feb sheet.
In case it finds a difference which is checked using the If-Then statementit highlights those cells in yellow. In those ways, you will be able to do this comparison with a click of a button. Here vet the steps to save this code in the Personal Macro Workbook.
And here you will find the steps to add this macro code to the QAT. Another quick way to compare two Excel files and check for matches and differences is by using a free third-party tool such as XL Sode.
This is a web-based tool where you can upload two Excel files and it will create a what is the biggest mall in america file that will have the data that is common or different data based on what option you selected. Suppose you have two files that have customer datasets such tk name and email addressand you want to quickly check what customers are there is file 1 and not in file 2.
One concern you may have when using a third-party tool to compare Excel files is about privacy. Note spreadsheeets the XL Comparator website mentions that they sprfadsheets all the files after 1 hour of doing the comparison. These are some of the methods you can use to compare two different Excel files or worksheets in the same Excel file. Hope you found this Excel tutorial useful.
Thanks for this, very helpful. However, with 50 rows and how to launch netmeeting in xp columns to compare, the e. JanValueFebValue16 is fine other than I then have to go back manually to the Feb sheet to see eccel product was in cell How to organize your business for success that has changed values.
This Tutorial Covers:. Get 51 Excel Tips Ebook to skyrocket ge productivity and get work done faster.
Need more help?
To view the Active worksheets of all open Excel workbooks side by side, go to the View tab in the Excel ribbon > Arrange All Select Vertical Click OK 3 Workbooks arranged vertically To view different worksheets of the same workbook side by side, c.
Was this helpful? Yes 40 No Note This option is available only when View Side by Side is turned on. View two worksheets of different workbooks side by side. In this dialog box, under Compare Side by Side with , click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK. View multiple worksheets at the same time. Tip To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window. Walsh University LibAnswers.
Last Updated: Aug 16, Views: In the workbook window, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab. Tips If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings. To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.
View two worksheets of different workbooks side by side Open both of the workbooks that contain the worksheets that you want to compare. In each workbook window, click the sheet that you want to compare. View multiple worksheets at the same time Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following: If the worksheets that you want to view are in the same workbook, do the following: Click a worksheet that you want to view. On the View tab, in the Window group, click New Window. Repeat steps 1 and 2 for each sheet that you want to view. If the worksheets that you want to view are in different workbooks, continue with step 3.
On the View tab, in the Window group, click Arrange All. Under Arrange , click the option that you want. To view sheets only in the active workbook, select the Windows of active workbook check box. Comments 6. Thank you! Great instructions. Is there a way to save the view side by side setting so that when you bring the worksheet or workbooks back up they appear side by side?
I know that there is the save workplace option, but that seems to save all files that you had opened at the time. Greg - I've never heard of being able to do that and still have the excel sheets usable. If you want a still image of the side by side you could do a screenshot or use a program like the snipping tool.
It was the best useful answer that I've got. Can we run the VB code and scroll through the excel file simultaneously? Add a public comment to this FAQ Entry. Contact Us! Main Library: Email Us: library walsh. Like Us! Ask Us! Related Topics. Microsoft Office. Powered by Springshare ; All rights reserved. Report a tech support issue. Login to LibApps. North Canton, Ohio library walsh.