Look Who it Was Random video

Excel - Comparing Side by Side Part 1: Episode 1342

1,470 views · Published 16 February 2011 · 3:27 · Indexed 4 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Compare Worksheets in Excel | Easy Side-by-Side Comparison Method | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing how to compare worksheets in Excel. This is a common task that many Excel users face, and we have a simple solution for you.

The question for today's episode comes from James, who has two different worksheets - one for the United States and one for Denmark. He wants to compare the values in these worksheets side by side. While there are more complex ways to do this, we will be showing you a low-tech solution that is quick and easy.

First, we will open the Denmark worksheet and go to View, then New Window. If you are using Excel 2003, go to Window, then New Window. This will open a new window with the same worksheet. Next, we will go to the United States worksheet and open it in a new window as well. Now, we will go to the View tab in Excel 2007 or 2010, or the Window menu in Excel 2003, and select "View Side by Side". This will give us a side-by-side view of both worksheets.

As we scroll through one worksheet, the other will also scroll in sync. This is a great feature that was introduced in Excel 2003. However, we may need to make some adjustments to get the view just right. We can adjust the column widths and use the Freeze Panes feature to keep certain columns in place as we scroll. We may also need to unmerge any cells in the worksheets to ensure that the data lines up correctly.

And there you have it - a simple and efficient way to compare worksheets in Excel without using any formulas. This method works best when the data is in the same sequence in both worksheets. Thank you for tuning in to this episode of the MrExcel podcast. We hope this tip will save you time and make your Excel tasks easier. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Comparing Worksheets
(00:15) Setting Up the Worksheets
(00:25) Low-Tech Solution
(00:36) Using View New Window
(00:46) Comparing Side-by-Side
(01:06) Adjusting the View
(01:29) Scrolling and Adjusting Merged Cells
(02:22) Finalizing the View
(02:32) Freezing Panes
(03:03) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Compare Worksheets
Data in same sequence
Easy way to compare worksheets
Excel 2003 Window, New Window
Excel 2007/2010 View tab
Freezing panes
Merged cells in spreadsheet
MrExcel podcast episode 1342
Removing merged cells
Scrolling synchronized worksheets
Side-by-side comparison


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153022/


James asks if it is possible to compare two worksheets from the same workbook side by side. Today, in Episode #1342, Bill shows us a low-tech way to do this comparison. Tune in to The Learn Excel from MrExcel Podcast for Part 2, airing tomorrow.

More from this channel