Comparing Two Spreadsheets In Excel 2010: Side By Side With View Tab

I still use Excel 2010 for most client work. The View tab makes comparing spreadsheets shockingly simple without fancy add-ons or complex formulas.

Open both files, then head to View > New Window. This creates a second view of the same workbook. Switch to the first file and repeat the process. Now you can arrange them side by side.

Sync the scrolling so both sheets move together. It’s the easiest way to spot differences between datasets without flipping back and forth. I’ve used this method for hundreds of client comparisons.

Works for any version from 2007 onward. No extra software needed, just a few clicks in the right place.

What Youll Need

Step-by-Step Instructions for Comparing Two Spreadsheets in Excel 2010

This method works reliably every time to spot differences between worksheets quickly.

Launch Excel 2010 and open both spreadsheets you want to compare. I always make sure the files are saved first—this prevents accidental data loss if you need to close and reopen them during the process.

Arrange the two windows side by side on your desktop. You can drag them manually or use Windows Snap: click and drag one window to the left edge of the screen, then drag the other to the right edge. This creates a clean split-screen view.

In one of the workbooks, click the View tab in the ribbon. In the Window group, select New Window. This opens a second instance of the same workbook, which might seem confusing at first, but it’s essential for the comparison.

Now, click Arrange All in the same Window group. Choose Vertical for a side-by-side arrangement, then check Windows of active workbook and Synchronous Scrolling. Click OK to confirm.

With Synchronous Scrolling enabled, both windows will scroll together in lockstep. Navigate to the View tab again and ensure Synchronous Scrolling is checked. This keeps both sheets aligned as you move through the data.

Scroll through both sheets simultaneously. Differences will stand out immediately—whether it’s a mismatched value, a missing row, or a formatting inconsistency. If you see a discrepancy, you can pause scrolling and investigate further.

For an even clearer view, return to the View tab and click Compare Side by Side in the Window group. This highlights the differences between the two windows, making it easier to spot changes.

If the Compare Side by Side button is grayed out, ensure both windows are active and visible. You may need to click Arrange All again to reset the view.

Once you’ve completed the comparison, disable Synchronous Scrolling and Compare Side by Side to return to normal viewing. Close the extra window you created earlier by clicking the X in its top-right corner.

Save both workbooks to preserve any changes or notes you added during the comparison. This step is often overlooked, but it ensures you don’t lose any of your work or observations.

Tips and Common Mistakes

These practical insights will help you avoid frustration and get accurate results fast.

Window Arrangement Tip: In Step 1, use Windows Snap for perfect side-by-side alignment. Drag one Excel window to the left edge until you see the outline snap, then do the same with the second window on the right. This creates a seamless split-screen that prevents windows from overlapping or resizing unexpectedly.

Synchronous Scrolling Secret: For Step 3, if your scrollbars aren’t moving in sync, double-check that you’ve enabled Synchronous Scrolling in the View tab. I’ve found that clicking the checkbox twice (off then on) often resets the connection between windows when it’s acting finicky.

Compare Side by Side Fix: In Step 4, if the Compare Side by Side button is grayed out, make sure both workbooks are actually visible on screen. Sometimes one window gets minimized behind the other, which tricks Excel into thinking it’s inactive. Restore both windows and try again.

Final Step Reminder: Don’t skip saving both files in Step 5. I learned this the hard way after spending 20 minutes comparing spreadsheets, only to lose all my notes when a power hiccup hit. Excel doesn’t always auto-save when you’re using multiple window views.

Frequently Asked Questions

Comparing two spreadsheets in Excel 2010 is simple with the View Tab and side-by-side tools. 🎯 Whether you’re spotting differences or analyzing data, these steps save time and reduce errors. Ready to try it? Open Excel and practice with your own files to master the process!