Waxa jira laba faylal oo la magac baxay Excel oo^{(Excel files)} ku jira faylal kala duwan oo ku jira kombuyutarkaaga. Sideed u go'aamin kartaa haddii faylalku yihiin nuqullo ama noocyo kala duwan oo isla buug- shaqeedka Excel^(Excel) ? Casharradan, waxaan ku tusi doonaa sida loo barbar dhigo labada faylal ee Excel , xitaa haddii aadan ku rakibin Excel kombiyuutarkaaga.

Qalabkan isbarbardhigga ayaa kaa caawin kara inaad ogaato xogta aan iswaafaqsanayn, qiyamka duugoobay, qaababka jaban, xisaabinta khaldan, iyo dhibaatooyinka kale ee xaashidaada Excel .

1. Is barbar dhig labada xaashi ee ^(Side)Excel : Dhinac^{(View Side)} ka eeg

Haddii aad xogta xaashida si jaleec ah u arki karto, ku fur daaqad gaar ah oo samee isbarbardhigga dhinac-dhinac addoo isticmaalaya astaanta “View Side by Side” ee Excel.

1. Fur hoyga faylka Excel labadaba xaashiyaha shaqada, madaxa View tab, oo dooro Daaqadda Cusub^{(New Window)} .

1. Daaqadda cusub, dooro ama u beddel warqadda shaqada (labaad) ee^{(switch to the (second) worksheet)} aad rabto inaad is barbar dhigto.

Dib u habeyn ama dib u habeyn ku samee daaqadaha si aad u yeelato muuqaal dhinac-dhinac ah ee labada warqadood ee shaqada ee shaashadda kombiyuutarkaaga. Mar labaad^(Again) , habkani wuxuu ugu fiican yahay isbarbardhigga waraaqaha shaqada ee Excel oo leh dhowr saf ama tiirar.

1. Haddii aad doorbidi lahayd inaad isticmaasho qalabka isbarbardhigga ee Excel si aad labada daaqadood u dhigto dhinac-dhinac, hubi tab "View" oo dooro View Side by Side icon.

Excel wuxuu isla markaaba labada warqadood ee shaqada u habayn doonaa si siman shaashadda kombiyuutarkaaga. Waxa laga yaabaa inay yara adag tahay in la is barbar dhigo xaashiyaha muuqaalkan muuqaalka ah, markaa u gudub tallaabada xigta si aad u bedesho hanuuninta qaab toosan/sawirro ah.

1. Tag tab "View" mar labaad oo dooro Arrange All .

1. Ka dooro Toosan^(Vertical) daaqadda "Habeeb" oo dooro OK .

Taasi waxay ku dhejin doontaa labada waraaqood ee shaqada meel dhinac-dhinac ah oo shaashaddaada ah. Waxaa jira hal goob oo kale oo aad u baahan tahay si aad awood ugu yeelato si aad isbarbardhigga uga dhigto mid aad u fudud.

1. Taabo Isku^{(Synchronous Scrolling)} -laabashada Isku-dhafka oo hubi in la iftiimiyay. Tani waxay kuu ogolaanaysaa inaad isku mar dhex rogto labada waraaqood ee shaqada, taasoo kuu ogolaanaysa isbarbardhigga xogtaada oo isku xigta.

Haddii safafka sare ee labada waraaqood ee shaqadu ay yihiin madax, hubso inaad qaboojiso si aanay ula dhaqaaqin inta ka hadhay xogta marka aad dhex socoto.

1. Dooro barafyada qaboojiya^{(Freeze Panes)} oo dooro Barafka Barafka^{(Freeze Top Row)} . Ku soo celi tallaabadan xaashida shaqada ee labaad.

1. Dooro Dib-u-dejinta booska daaqadda^{(Reset Window Position)} si aad ugu celiso hanuuninta isbarbardhigga qaabka muuqaalka.

1. Marka aad dhammayso isbarbardhigga, dooro View Side by side si aad ugu celiso xaashida shaqada cabbirkooda hore.

Hadda waxaad ku dhex rogi kartaa labada warqadood ee shaqada oo waxaad barbardhigi kartaa line-by-line. Faa'iidada ugu weyn ee habkan waa in lagu dhex dhisay dhammaan noocyada Excel . Si kastaba ha ahaatee, weli waa inaad qabataa farabadan shaqada - tusaale ahaan, soo saarista unugyo leh tirooyin kala duwan, macros, qaabab, iwm.

2. Is barbar dhig labada faylal ee Excel Adigoo isticmaalaya Aalado Online ah^{(Online Tools)}

Waxaa jira qalab ku salaysan mareegaha oo bixiya adeegyada isbarbardhigga ee Excel . Waxaad ka heli doontaa qalabkan faa'iido leh haddii aadan ku rakibin Excel kombiyuutarkaaga. Qalabkan Isbarbardhigga Excel ee Aspose^{(Excel Comparison tool by Aspose)} waa aalad shabakad wanaagsan oo lagu barbar dhigo laba faylal oo Excel ah.^(Excel)

Soo rar faylka koowaad (primary) ee Excel sanduuqa koowaad, ku jiid faylka kale sanduuqa labaad, oo dooro badhanka Isbarbardhigga Hadda^{(Compare Now)} .

Haddii faylalku leeyihiin xaashiyo badan, dooro xaashida aad rabto inaad ku barbar dhigto tabka xaashida . ^(Sheets)Haddii labada xaashi ay leeyihiin unug leh qiyam kala duwan ama nuxur, Aspose Excel qalab isbarbardhigga ayaa muujin doona kala duwanaanshaha jaalaha.

Xaddidaadda qalabkan shabakada ku salaysan ayaa ah in ay inta badan muujiyaan qiyam kala duwan. Ma muujin karaan qaacidooyinka is khilaafsan, xisaabinta, iwm.

3. Is barbar dhig labada ^{(Compare Two)} faylal ee Excel^(Excel) Adigoo isticmaalaya "Spreadsheet Compare"

Isbarbardhigga Isbarbardhigga waa software la isku halayn karo oo lagu barbar dhigo laba faylal^(Excel) ama waraaqo shaqo. Nasiib darrose, waxa kaliya oo diyaar u ah aaladaha Windows wakhtigan xaadirka ah. Waxay u timaadaa sidii barnaamij gooni-gooni ah waxaana sidoo kale lagu dhex dhisay Microsoft Excel oo lagu daray noocyada/package-yada Xafiiska: Office Professional Plus^{(Office Professional Plus)} (2013 iyo 2016) ama Microsoft 365.

Is barbar dhig xaashida faafinta ee Excel^{(Use Spreadsheet Compare in Excel)}

Haddii app kaaga Excel uu ka mid yahay xirmooyinka ^(Excel)Xafiiska^(Office) ee kor lagu soo sheegay , waxaad geli kartaa aaladda Isbarbardhigga^{(Spreadsheet Compare)} warqadda faafinta adigoo isticmaalaya "Weydii" ku-darka. Haddii aysan jirin tab “Weydiiso” abkaaga Excel , waa kan sida loo shido.

1. Dooro File on the menu bar menu.

1. Dooro Ikhtiyaarada^(Options) dhinaca bar-side.

1. Dooro Add-ins ee dhinaca bar-side, dooro COM Add-in ee "Maaraynta" hoos-hoos menu, oo dooro Go .

1. Calaamadee sanduuqa Weydii^(Inquire) oo dooro OK .

Fiiro gaar ah:^(Note:) Haddii aadan ka helin sanduuqa hubinta "Weydiiso" bogga COM Add-ins , noocaaga Excel^(Excel) ama Xafiiskaagu^(Office) ma taageerayo xaashida isbarbardhigga^{(Spreadsheet Compare)} . Ama laga yaabee, maamulka ururkaaga ayaa curyaamiyay sifada. Ku rakib noocyada Xafiiska^(Office) oo wata xaashida faafinta Isbarbar dhig^{(Spreadsheet Compare)} horay loo rakibay ama la xidhiidh maamulka ururkaaga.

1. Fur labada faylal ee Excel aad rabto inaad ku barbar dhigto daaqad gooni ah, madaxa u tag tabka Weydii^(Inquire) ee ku yaal bar Menu, oo dooro Isbarbardhiga Files^{(Compare Files)} .

1. Excel wuxuu si toos ah ugu dari doonaa faylalka koowaad iyo labaad sanduuqyada wada hadalka "Is barbar dhig" iyo "To", siday u kala horreeyaan. Dooro faylalka^{(Swap Files)} is-beddelka si aad isku beddesho faylasha aasaasiga ah iyo kan sare, ama dooro Isbarbardhigga^(Compare) si aad u bilowdo isbarbardhigga.

Taasi waxay soo saari doontaa Isbarbardhigga^{(Spreadsheet Compare)} daaqad cusub, taasoo muujinaysa farqi kasta oo ka dhex jira kaydka xogtaada. Unugyada joogtada ah ee leh qiimayaal kala duwan waxay yeelan doonaan iftiin cagaaran. Unugyada qaaciidooyinka leh ayaa loo qaabeeyey guduud halka unugyo leh makro ay ku ciyaari doonaan midab turquoise ah.

Dooro Natiijooyinka Dhoofinta^{(Export Results)} si aad u soo saarto una kaydiso koobiga natiijooyinka kumbuyuutarkaaga dukumeenti Excel ahaan ah.

Warbixintu waxay tilmaami doontaa xaashida iyo tixraacyada unugga oo wata xog-ururineed oo kala duwan, iyo sidoo kale qiyamka saxda ah ee xogtii hore iyo tan cusub.

Waxaad la wadaagi kartaa warbixinta Excel^{(share the Excel report)} asxaabtaada, kooxdaada, ama dadka kale ee si wada jir ah uga shaqeeya faylka.

Isticmaal xaashida faafinta Isbarbardhigga sidii Barnaamij taagan^{(Use Spreadsheet Compare as a Standalone Program)}

Haddi nooca Excel ama Office aanuu lahayn xaashida isbarbardhiga^{(Spreadsheet Compare)} wax-ku-darka, ku rakib software-ka goonida ah mareegta horumariyaha. Markaad rakibayso faylka dejinta, hubi inaad hubiso Diiwaanka oo aad dhaqaajiso ku-darka^{(Register and activate the add-in in Excel)} sanduuqa Excel.

Ka dib marka la rakibo, billow Spreadsheet Compare^{(Spreadsheet Compare)} oo raac tillaabooyinkan si aad u isticmaasho barnaamijka si aad u barbar dhigto dukumeentiyada Excel .

1. Dooro Is barbar dhig faylalka^{(Compare Files)} gudaha tabka "Guriga".

1. Dooro summada galka^{(folder icon)} ku xigta “Is barbar dhig (faylalka duugga ah)” sanduuqa wada-hadalka si aad ugu darto dukumeentiga ugu horreeya ee aad rabto inaad barbar dhigto qalabka. Ku dar faylka labaad sanduuqa "To (faylalka cusub)" oo dooro OK si aad u sii wadato.

Isbarbardhigga xaashida faafinta^{(Spreadsheet Compare)} ayaa habayn doona faylalka oo muujin doona unugyo leh qiimayaal kala duwan oo cagaar ah.

Kala Duwanaanshaha Baro

Qalabka isbarbardhigga "Deeg dhinaca dhinac" ayaa ah ikhtiyaarka ugu macquulsan ee isticmaalayaasha Xafiiska Guriga^{(Office Home)} ama Ardayda^(Students) . Haddii aad Excel u isticmaaleyso Microsoft 365 ama Office Professional Plus (2013 ama 2016), aaladda ku dhex dhisan ee “Spreadsheet Compare” waa gacantaada. Laakiin haddii aadan ku jirin Excel kombuyutarkaaga, aaladaha isbarbardhigga Excel ee shabakada ku saleysan ayaa heli doona shaqada. Runtii aad bay u fududahay.

How to Compare Two Excel Files and Highlight the Differences

There are two similarly-named Excel files in different folders on your computer. How do you determine if the files are duplicates or different versions of the same Excel workbook? In this tutorial, we’ll show you how to compare two Excel files, even if you don’t have Excel installed on your computer.

These comparison tools can help you spot inconsistent data, outdated values, broken formulas, incorrect calculations, and other problems in your Excel worksheet.

1. Compare Two Excel Sheets: View Side by Side

If you can peruse the sheet’s data at a glance, open them in a separate window and perform a side-by-side comparison using Excel’s “View Side by Side” feature.

1. Open the Excel file housing both worksheets, head to the View tab, and select New Window.

1. In the new window, select or switch to the (second) worksheet you want to compare.

Resize or rearrange the windows so you have a side-by-side view of both worksheets on your computer’s display. Again, this method is best for comparing Excel worksheets with only a few rows or columns.

1. If you’d rather use Excel’s comparison tool to place both windows side-by-side, check the “View” tab and select the View Side by Side icon.

Excel will immediately arrange both worksheets horizontally on your computer’s screen. It might be a bit difficult to compare sheets in this landscape view, so proceed to the next step to change the orientation to a vertical/portrait arrangement.

1. Head to the “View” tab again and select Arrange All.

1. Select Vertical in the “Arrange” window and select OK.

That’ll stack both worksheets in a side-by-side position on your screen. There’s one more setting you need to enable to make the comparison a lot easier.

1. Tap Synchronous Scrolling and make sure it is highlighted. This lets you scroll through both worksheets simultaneously, allowing for a synchronous row-by-row comparison of your dataset.

If the top rows of both worksheets are headers, make sure you freeze them so they don’t move with the rest of the dataset when you scroll through.

1. Select Freeze Panes and select Freeze Top Row. Repeat this step for the second worksheet.

1. Select Reset Window Position to revert the comparison orientation to landscape format.

1. When you’re done with the comparison, select View Side by Side to revert the worksheets to their initial sizes.

Now you can scroll through both worksheets and compare them line-by-line. The major advantage of this feature is that it’s built into all Excel versions. However, you’ll still have to do a bunch of the work—i.e., spotting cells with varying figures, macros, formulas, etc.

2. Compare Two Excel Files Using Online Tools

There are web-based tools that offer Excel comparison services. You’ll find these tools beneficial if you don’t have Excel installed on your computer. This Excel Comparison tool by Aspose is a good web tool for comparing two Excel files.

Upload the first (primary) Excel file in the first box, drag the other file in the second box, and select the Compare Now button.

If the files have multiple sheets, select the sheets you want to compare in the Sheets tab. If both sheets have cells with different values or content, the Aspose Excel comparison tool will highlight the differences in yellow.

The limitation of these web-based tools is that they mostly highlight different values. They can’t highlight discrepant formulas, calculations, etc.

3. Compare Two Excel Files Using “Spreadsheet Compare”

Spreadsheet Compare is a reliable software for comparing two Excel files or worksheets. Sadly, it’s only available for Windows devices at the moment. It comes as a standalone program and is also built into Microsoft Excel included in the Office versions/packages: Office Professional Plus (2013 and 2016) or Microsoft 365.

Use Spreadsheet Compare in Excel

If your Excel app is part of the above-mentioned Office packages, you can access the Spreadsheet Compare tool via the “Inquire” add-in. If there’s no “Inquire” tab in your Excel app, here’s how to turn it on.

1. Select File on the menu bar.

1. Select Options on the sidebar.

1. Select Add-ins in the sidebar, select COM Add-in in the “Manage” drop-down menu, and select Go.

1. Check the Inquire box and select OK.

Note: If you don’t find an “Inquire” checkbox in the COM Add-ins page, your Excel or Office version doesn’t support Spreadsheet Compare. Or perhaps, your organization’s admin has disabled the feature. Install the Office versions with Spreadsheet Compare pre-installed or contact your organization’s admin.

1. Open both Excel files you want to compare in a separate window, head to the Inquire tab in the Menu bar, and select Compare Files.

1. Excel will automatically add the first and second files to the “Compare” and “To” dialog boxes, respectively. Select Swap Files to interchange the primary and secondary files, or select Compare to start the comparison.

That’ll launch Spreadsheet Compare in a new window, highlighting any disparity within your dataset. Regular cells with different values will have a green highlight. Cells with formulas are formatted purple while cells with a macro will sport a turquoise fill color.

Select Export Results to generate and save a copy of the results to your computer as an Excel document.

The report will indicate the sheet(s) and cell references with varying datasets, as well as the exact values of the old and new data.

You can share the Excel report with your colleagues, team, or other people working collaboratively on the file.

Use Spreadsheet Compare as a Standalone Program

If your Excel or Office version doesn’t have the Spreadsheet Compare add-in, install the standalone software from the developer’s website. When installing the setup file, make sure you check the Register and activate the add-in in Excel box.

After installation, launch Spreadsheet Compare and follow these steps to use the program to compare the Excel documents.

1. Select Compare Files in the “Home” tab.

1. Select the folder icon next to the “Compare (older files)” dialog box to add the first document you want to compare to the tool. Add the second file to the “To (newer files)” box and select OK to proceed.

Spreadsheet Compare will process the files and highlight cells with varying values in green.

Spot the Differences

The “View Side by Side” comparison tool is the most viable option for Office Home or Students users. If you’re using Excel for Microsoft 365 or Office Professional Plus (2013 or 2016), the built-in “Spreadsheet Compare” tool is at your disposal. But if you don’t Excel on your computer, web-based Excel comparison tools will get the job done. It’s really that easy.

Related posts

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Isticmaal daaqada daawashada Excel si aad ula socoto unugyada muhiimka ah ee buug-shaqeedka

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida loo isticmaalo Excel AutoRecover iyo AutoBackup Features

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida loo shaandheeyo xogta gudaha Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• Sida Taariikhaha Looga Jaro Excel

• Sida Loo Sameeyo Liiska hubinta gudaha Excel

• Sida loo isticmaalo COUNTIFS, SUMIFS, AVERAGEIFS gudaha Excel

• Sida loola socdo isbedelada Excel

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Geli xaashida shaqada ee Excel Word Doc

• Sida loo duubo Macro gudaha Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive