1 Open the workbooks you need to compare. You can find these by opening Excel, clicking File then Open, and selecting two workbooks to compare from the menu that appears.
2 Click the View tab. Once you've opened one of the workbooks, you can click on the View tab in the top-center of the window. Advertisement
3 Click View Side by Side. This is located in the Window group of the ribbon for the View menu and has two sheets as its icon. This will pull up both worksheets into smaller windows stacked vertically.
4 Click Arrange All. This setting lets you change the orientation of the workbooks when they're displayed side-by-side.
5 Enable Synchronous Scrolling. Once you have both worksheets open, click on Synchronous Scrolling (located under the View Side by Side option) to make it easier to scroll through both Excel files line-by-line to check for any differences in data manually.
6 Scroll through one workbook to scroll through both. Once Synchronous Scrolling is enabled, you'll be able to easily scroll through both workbooks at the same time and compare their data more easily. Advertisement
Method 2 Method 2 of 4:Using the Lookup Function
Advertisement
Method 3 Method 3 of 4:Using XL Comparator
Advertisement
Method 4 Method 4 of 4:Accessing an Excel File Directly from a Cell
Advertisement
Community Q&A
Search Add New QuestionAsk a Question
200 characters left Include your email address to get a message when this question is answered. Submit
Advertisement
Tips
Submit a Tip All tip submissions are carefully reviewed before being published Submit Thanks for submitting a tip for review!
Advertisement
You Might Also Like
Advertisement
About This Article
wikiHow Staff wikiHow Staff Writer This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 202,883 times.
How helpful is this?
Co-authors: 5 Updated: May 25, 2022 Views:202,883 Categories: Software Article SummaryX 1. Open two Excel documents. Did this summary help you?YesNo
In other languages
Bahasa Indonesia:Membandingkan Dua Berkas Excel العربية:مقارنة ملفي إكسل 中文:对比两个Excel文件 Nederlands:Twee Excel bestanden vergelijken Deutsch:Zwei Excel Dateien vergleichen Español:comparar dos archivos de Excel Italiano:Confrontare Due File Excel 日本語:2つのExcelファイルを比較する हिन्दी:दो एक्सेल फाइल्स को कंपेयर करें (Compare Two Excel Files) Tiếng Việt:So sánh hai tập tin Excel ไทย:เปรียบเทียบ 2 ไฟล์ Excel 한국어:두 엑셀 파일을 비교하는 방법 Français:comparer deux fichiers Excel Português:Comparar Dois Arquivos do Excel
Thanks to all authors for creating a page that has been read 202,883 times.
Is this article up to date?Yes No
Advertisement |