Ma^(Are) waxaad raadinaysaa hab aad ula socoto isbeddelada lagu sameeyay xaashida xaashida ee Excel ? Waxaa jira kiisas badan oo ay tahay inaad u qaybiso fayl dad badan oo aad la socoto isbeddellada la sameeyay. Waxaa laga yaabaa inaad rabto inaad raadiso markii isbeddelku dhacay, cidda isbeddelka samaysay, unugga isbeddelku ku dhacay iyo xogta la beddelay.

Excel waxa uu leeyahay sifooyin daba gal ku dhisan oo xamili kara dhammaan kiisaska kor ku xusan. Waxaad si fudud dib ugu eegi kartaa dhammaan isbeddellada si toos ah xaashida shaqada oo waxaad sidoo kale aqbali kartaa ama diidi kartaa isbeddel kasta. Waxaa jira dhowr dhibcood oo lagu xasuusto oo ku saabsan sifooyinka raadraaca ee Excel :

1. Daarida raadraaca macnaheedu maaha inaad dib ugu soo celin karto xaashida xaashida oo aad ku noqon karto xaalad hore adiga oo dib u dhigista isbedelada. Asal ahaan waa fayl log ah oo wax walba diiwaangeliya waana taas. Waxaad gacanta ku tagi kartaa oo arki kartaa xogta la tirtiray ama lagu daray, laakiin waa inaad adigu isbeddel ku samayso xaashida.

2. Daarida raadraaca macnaheedu maaha in isbedel kasta oo aad samayso la duubayo. Xog kasta oo lagu kaydiyo unugga waa la raad raacaa, laakiin isbeddellada kale sida qaabaynta maaha. Isbeddellada kale ee aan la raadin waxaa ka mid ah qarinta/qarinta safafka iyo tiirarka, faallooyinka, iyo qiyamka unugga ee isu beddela dib-u- xisaabinta caanaha.

3. Beddelka^(Change) taariikhda waxa kaliya oo loo hayaa 30 maalmood si toos ah. Haddii aad wax ka beddesho xaashida shaqada ee Excel oo aad haddana furto buugga shaqada 45 maalmood ka dib, markaa waxaad awoodi doontaa inaad aragto taariikhda isbeddelka dhammaan 45 maalmood ilaa aad xidhayso buugga shaqada. Markaad xidho, taariikh kasta oo isbeddel ah oo ka weyn 30 maalmood way tagi doontaa. Taas macnaheedu waa marka xigta ee aad furto, ma awoodi doontid inaad aragto isbeddelkaas aad samaysay 45 maalmood ka hor.

4. Mar kasta oo aad daarato la socodka, buuga shaqadu waxa uu noqonayaa buug shaqo oo la wadaago. Tani waxay ka dhigan tahay in isticmaaleyaal badan ay isbedel ku sameyn doonaan dukumeentiga.

Hadda oo aad ogtahay qaar ka mid ah aasaaska sida raadraaca u shaqeeyo Excel , aan ka hadalno sida loo suurtageliyo, beddelo goobaha iyo la socoshada isbeddelada!

Ogolaanshaha Dabagalka

Aan hore u socono oo marka hore shid raadraaca. Fur Excel oo guji tabka dib u eegista^(Review)  ee ribbon. Midigta fog, waa inaad ku aragtaa ikhtiyaarka la yiraahdo Isbeddellada La Soco ^{(Track Changes )} Qaybta Isbeddellada^(Changes) .

Guji badhanka oo dooro  Iftiiminta Isbedelada^{(Highlight Changes)} . Waxaad heli doontaa sanduuqa wada-hadalka oo aad hadda u baahan tahay inaad iska hubiso ikhtiyaarka "Raac isbeddelada markaad tafatireyso. Tani waxay sidoo kale la wadaagtaa buuggaaga shaqada"^{(“Track changes while editing. This also shares your workbook”)} .

Waxaad halkan ku haysaa dhawr ikhtiyaar oo ay ku jiraan  Goorma^(When) , Yaa^(Who) , iyo Halkee^(Where) . Marka ,^(When) Dhammaan macnaheedu waa isbeddel kasta^(All) waa la iftiimin doonaa. Waxa kale oo aad haysataa ikhtiyaarka ah in aad muujiso isbeddelada markii ugu dambaysay ee aad kaydisay dukumeentiga, ilaa taariikh gaar ah, ama isbeddelada aan weli dib loo eegin.

Haddii aad hubiso  cidda^(Who) , waxaad dooran kartaa inaad la socoto isbeddelada uu qof kasta sameeyay ama isbeddelada qof kastaa sameeyo marka laga reebo adiga. Doorashada Halkee^(Where)  ayaa kuu ogolaanaysa inaad la socoto isbeddelada kaliya qayb gaar ah oo xaashida faafinta ah. Kaliya^(Just) dhagsii badhanka midigta oo dooro tirada unugyada aad rabto inaad la socoto.

Ugu dambayntii, waad ka-fiirsan kartaa isbeddellada Highlight ee ikhtiyaarka shaashadda^{(Highlight changes on screen)} haddii aadan rabin in kuwa kale ogaadaan inaad la socoto isbeddellada. Sida caadiga ah, marka aad bilowdo raadraaca oo doorashadan la doorto, unug kasta oo la beddelo waxa uu tusi doonaa falaar yar oo bidixda sare ah si ay u muujiso in la beddelay.

Sidoo kale, haddii aad gujiso unug la beddelay (oo leh isbeddello Highlight ah oo shaashadda^{(Highlight changes on screen)} ah), waxaad heli doontaa daaqad popup yar oo muujinaysa waxa qiimihii laga beddelay oo loo beddelay iyo wakhtiga. Haddii aad dooratid isbeddellada Highlight ee ikhtiyaarka shaashadda, in yar oo saddex xagal madow ah ma soo baxayaan.

Haddaba waxa aad samayn karto, tusaale ahaan, qari isbeddellada shaashadda ku yaal adiga oo aan calaamadin sanduuqa, u dir faylkaaga qof kasta oo ay tahay in uu wax ka beddelo, marka aad dib u hesho, kaliya u tag Isbeddelka Isbeddelka^{(Track Changes)} oo dib u hubi. sanduuqa.

Habee Dabagalka

Talaabada xigta waa inaad eegto goobaha raadraaca oo aad hagaajiso si ay ugu habboonaato baahiyahaaga. Si tan loo sameeyo, dhagsii badhanka La wadaag Buug^{(Share Workbook)} - hawleedka oo si toos ah dhanka bidix uga yaal badhanka Isbeddellada Raadraaca . ^{(Track Changes)}Guji tab Advanced marka Wada -hadalka Buug -hawleedku soo baxo.^{(Share Workbook)}

Halkan waxa aad ku bedeli kartaa tirada maalmaha taariikhda beddelka wax aan ahayn 30 maalmood. Sida caadiga ah, isbeddelada waa la cusboonaysiiyaa marka faylka la kaydiyo, laakiin waxaad samayn kartaa si toos ah dhowrkii daqiiqoba mar. Ugu dambeyntii, waxaad dooran kartaa sida aad rabto inaad wax uga qabato isku dhacyada: ha ahaato in lagu weydiiyo ama si fudud u oggolow isbeddelka ugu dambeeya markaad badbaadinayso faylka.

Daawashada Isbadalada

Marka aad karti u siiso la socodka oo aad sameyso dhowr isbeddel, waxaad riixi kartaa batoonka Isbeddelka Raadraaca^{(Track Changes)} mar labaad, dhagsii Isbeddellada Highlight^{(Highlight Changes)} oo waxaad ogaan doontaa in Liiska isbeddelka ee^{( List changes on a new sheet)} sanduuqa xaashida cusub aanu sii urin.

Hubi taas oo guji OK. Warqad^{(OK. A)} shaqo oo cusub oo la yiraahdo History ayaa lagu dari doonaa taasoo kuu ogolaan doonta inaad aragto dhammaan isbeddellada lagu sameeyay buuggaas shaqada.

Mar waxaad u baahan doontaa inaad ogolaato ama diido isbeddellada. Waxaad dib u eegi kartaa dhammaan isbeddellada ka dibna dooran kartaa oo dooran kartaa kuwa aad rabto inaad hayso ama tuurto.

Kaliya dhagsii Raad-raac Isbedelka^{(Track Changes)} mar labaad oo dooro Accept/Reject Changes . Dooro ikhtiyaarada aad ku dooranayso isbeddelada aad rabto inaad aqbasho ama diido. Haddii aad rabto inaad dib u eegto dhammaan isbeddellada, kaliya ka tag Marka la^(When) hubiyo oo hubi in loo dhigay inaan dib loo eegin^{(Not Reviewed)} .

Guji OK^{(Click OK)} iyo Excel wuxuu bilaabi doonaa inuu ku tuso isbeddel kasta oo la sameeyay wuxuuna ku siin doonaa ikhtiyaarka ah inaad aqbasho^(Accept) ama diido^(Reject) . Waxaad sidoo kale aqbali kartaa Dhammaan^{(Accept All)} ama diidi kartaa Dhammaan^{(Reject All)} isbeddellada haddii aad rabto.

Haddii aad diido isbeddel, isla markaaba waxay ku noqonaysaa wixii markii hore ku jiray unuggaas. Waxaa xusid mudan in haddii unug kale uu tixraaco waxa ku jira unugga la diiday, markaas qiimahaasi wuxuu sidoo kale isbeddeli doonaa marka qiimihii unugga tixraacay uu dib u soo noqdo. Tani waxay keeni kartaa inay jebiyaan qaaciidooyinka iyo wixii la mid ah, markaa taxaddar.

Waa kaas! Hadda waxaad si fudud ula socon kartaa isbeddel kasta oo lagu sameeyo xaashida Excel -ka adiga oo isticmaalaya habkan ku dhex jira. Haddii aad wax su'aalo ah qabtid, ku dheji faallo. Ku raaxayso!

How to Track Changes in Excel

Arе you looking for a way to track changes made to an Excel spreadsheet? There are many cases whеre you have to distribute a file to multiple people and keep track of what changes were made. You might want to track when the change was made, who made the change, what cell the сhange occurred in and what data was changed.

Excel has built-in tracking features that can handle all of the above cases. You can easily review all of the changes directly on the worksheet and you can also accept or reject each change. There are a few points to remember about the tracking features of Excel:

1. Turning on tracking does not mean that you can revert the spreadsheet back in time to a previous state by undoing the changes. It’s basically a log file that records everything and that’s it. You can manually go and see what data was deleted or added, but you’ll have to make the changes to the spreadsheet yourself.

2. Turning on tracking doesn’t mean every single change you make will be recorded. Any data stored in a cell is tracked, but other changes like formatting are not. Other changes that are not tracked include hiding/unhiding rows and columns, comments, and cell values that change to due a formula recalculation.

3. Change history is only kept for 30 days by default. If you make changes to an Excel worksheet and then open the workbook again 45 days later, then you’ll be able to see the change history for all 45 days until you close the workbook. When you close it, any change history older than 30 days will be gone. That means the next time you open it, you won’t be able to see that change you had made 45 days earlier.

4. Whenever your turn on tracking, the workbook becomes a shared workbook. This means that multiple users will be making changes to the document.

Now that you know some basics of how tracking works in Excel, let’s talk about how to enable it, change settings and keep track of changes!

Enabling Tracking

Let’s go ahead and turn on tracking first. Open Excel and click on the Review tab on the ribbon. At the far right, you should see an option called Track Changes under the Changes section.

Click the button and choose Highlight Changes. You’ll get a dialog box where you now need to check off the option “Track changes while editing. This also shares your workbook”.

You have several options here including When, Who, and Where. For When, All means every change will be highlighted. You also have the option of highlighting changes from the last time you saved the document, since a specific date, or changes that have not yet been reviewed.

If you check Who, you can choose to track changes made by anyone or changes made by everyone except you. The Where option allows you to track changes only for a specific portion of the spreadsheet. Just click the button at the right and select the range of cells you want to keep track of.

Finally, you can un-check the Highlight changes on screen option if you do not want others to know you are tracking changes. By default, once you start tracking and this option is selected, any changed cell will show a small arrow at the top left to indicate it was changed.

Also, if you click on a changed cell (with Highlight changes on screen turned on), you’ll get a little popup window showing what the value was changed from and changed to and at what time. If you deselect the Highlight changes on screen option, that little black triangle won’t show up.

So what you can do, for example, is hide the changes on the screen by not checking the box, send out your file to everyone who has to make changes to it, and when you get it back, just go to Track Changes and recheck the box.

Configure Tracking

The next step is to take a look at the settings for tracking and adjust them to fit your needs. To do this, click on the Share Workbook button that is directly to the left of the Track Changes button. Click on the Advanced tab when the Share Workbook dialog pops up.

Here you can change the number of days for keeping change history to something other than 30 days. By default, changes are updated when the file is saved, but you can make it so that it is automatically done every few minutes. Lastly, you can choose how you want to deal with conflicts: either by being asked or simply letting the last change when saving the file win.

Viewing Changes

Once you have enabled tracking and made a few changes, you can click on the Track Changes button again, click on Highlight Changes and you’ll notice that the List changes on a new sheet box is no longer grayed out.

Check that and click OK. A new worksheet called History will be added that will let you view all the changes that have been made to that workbook.

At some point you’ll need to either approve or reject the changes. You can review all the changes and then pick and choose which ones you want to keep or discard.

Simply click on Track Changes again and choose Accept/Reject Changes. Select the options to choose which changes you want to accept or reject. If you want to review all changes, just leave When checked and make sure it is set to Not Reviewed.

Click OK and Excel will begin to show you each change that was made and give you the option to Accept or Reject. You can also Accept All or Reject All changes if you like.

If you reject a change, it will immediately revert back to what was originally in that cell. It’s worth noting that if another cell references the contents of the rejected cell, then that value will also change when the referenced cell value reverts back. This can cause formulas to break, etc, so be careful.

That’s it! Now you can track any changes made to your Excel spreadsheet easily by using this built-in feature. If you have any questions, post a comment. Enjoy!

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

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

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida loo Kooxeeyo Waraaqaha Shaqada ee Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Sida Taariikhaha Looga Jaro Excel

• Adeegso Excel si aad u ogaato dulsaarka waxtarka leh ee ka imanaya heerka dulsaarka magaca ah

• Sida loo Furo Tusaalooyin Badan oo Excel ah

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Sida loo isticmaalo COUNTIFS, SUMIFS, AVERAGEIFS gudaha Excel

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

• Sida Loo Bedelo Taariikhda Kooxda Microsoft

• 13 Tabaha OneNote & Tabaha loogu Abaabulayo Qoraaladaada si ka Wanagsan

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo barbar dhigo labada faylal ee Excel oo loo muujiyo faraqa u dhexeeya