Haddii aad wax badan ku shaqayso qaacidooyinka Excel , waxaad ogtahay in qiimaha hal unug loo isticmaali karo qaacido unugyo badan oo kala duwan ah. Dhab ahaantii, unugyada xaashi kale ayaa sidoo kale tixraaci kara qiimahaas. Taas macnaheedu waa in unugyadaas ay ku tiirsan yihiin unugga kale.

Ku-tiirsanaanta ku-tiirsanaanta Excel

Haddii aad beddesho qiimaha unuggaas keliya, waxa ay beddeli doontaa qiimaha unug kasta oo kale oo ku dhaca tixraaca unuggaas qaacido. Aan tusaale u soo qaadano si aan u aragno waxa aan ula jeedo. Halkan waxaan ku haynaa xaashi aad u fudud oo aan ku hayno saddex lambar ka dibna soo qaad wadarta iyo celceliska tirooyinkaas.

Markaa aynu nidhaahno waxaad rabtay inaad ogaato unugyada ku tiirsan ee unugga C3, kaasoo qiimahiisu yahay 10. Unugdee^(Which) ayaa qiyamkooda beddeli doona haddii aan u beddelno qiimaha 10 wax kale? Sida cad, waxay bedeli doontaa wadarta iyo celceliska.

Gudaha Excel , waxaad arki kartaa tan muuqaal ahaan adiga oo raadraaca kuwa ku tiirsan. Waxaad tan ku samayn kartaa adiga oo aadaya Formulas tab, ka dibna riixaya unugga aad rabto inaad raad raacdo ka dibna dhagsii^{(Trace Dependents)} badhanka Raad-raacayaasha.

Markaad tan sameyso, waxaad isla markiiba arki doontaa fallaadho buluug ah oo laga soo sawiray unuggaas una gudbaya unugyada ku tiirsan sida hoos ku cad:

Waxaad ka saari kartaa fallaadhaha adiga oo si fudud u gujinaya unugga oo gujinaya badhanka Ka saar fallaadhaha . ^{(Remove Arrows)}Laakin aan nidhaahno waxaad haysaa qaacido kale Sheet2 kaas oo isticmaalaya qiimaha C1. Ma ka raadin kartaa kuwa kugu tiirsan xaashi kale? Waa hubaal inaad awooddo! Waa kan sida ay u ekaan doonto:

Sida aad arki karto, waxa jira khad madow oo dhibco leh oo tilmaamaya waxa u eg astaanta xaashida. Taas macnaheedu waa in uu jiro unug ku tiirsan xaashi kale. Haddii aad laba-gujiso xariiqda madow ee dhibco leh, waxay kuu keenaysaa Go To dialog halkaas oo aad u boodi karto unuggaas gaarka ah ee xaashidaas.

Markaa taasi aad bay ugu fiican tahay dadka ku tiirsan. Way adag tahay in aan laga hadlin waxyaalihii hore marka laga hadlayo kuwa ku tiirsan sababta oo ah aad ayay isaga mid yihiin. Sida aan rabnay inaan aragno unugyada ay saameeyaan qiimaha C3 ee tusaalaha kore, waxaa laga yaabaa inaan sidoo kale rabno inaan aragno unugyada saameeya qiimaha G3 ama H3.

Sida aad arki karto, unugyada C3, D3, iyo E3 waxay saameeyaan qiimaha unugga wadarta. Saddexdaas unug waxa lagu iftiimiyay sanduuq buluug ah oo leh fallaadho tilmaamaysa unugga wadarta. Way toosan tahay, laakiin haddii aad haysato qaar ka mid ah qaacidooyin aad u adag oo sidoo kale isticmaala hawlo adag, markaa waxaa laga yaabaa inay jiraan fallaadho badan oo ku socda meel kasta. Haddii aad wax su'aalo ah qabtid, xor u noqo inaad faallo ka bixiso waxaan isku dayi doonaa inaan ku caawiyo. Ku raaxayso!

How to Trace Dependents in Excel

If you work with formulas a lot in Excel, you know that the valυe of a single cell can be used in a formula in many different cells. In fact, cells on a different sheet may reference that value alsо. This means that those cells are dependеnt on the other cell.

Trace Dependents in Excel

If you change the value of that single cell, it will change the value of any other cell that happens to reference that cell in a formula. Let’s take an example to see what I mean. Here we have a very simple sheet where we have three numbers and then take the sum and the average of those numbers.

So let’s say you wanted to know the dependent cells of cell C3, which has a value of 10. Which cells will have their values changed if we change the value of 10 to something else? Obviously, it will change the sum and the average.

In Excel, you can visually see this by tracing dependents. You can do this by going to the Formulas tab, then clicking on the cell you want to trace and then clicking on the Trace Dependents button.

When you do this, you will instantly see blue arrows drawn from that cell to the dependent cells like shown below:

You can remove the arrows by simply clicking on the cell and clicking the Remove Arrows button. But let’s say you have another formula on Sheet2 that is using the value from C1. Can you trace dependents on another sheet? Sure you can! Here’s what it would look like:

As you can see, there is a dotted black line that points to what looks like an icon for a sheet. This means that there is a dependent cell on another sheet. If you double-click on the dotted black line, it’ll bring up a Go To dialog where you can jump to that specific cell in that sheet.

So that’s pretty much it for dependents. It’s kind of hard not to talk about precedents when talking about dependents because they are so similar. Just as we wanted to see which cells are affected by the value of C3 in the example above, we may also want to see which cells affect the value of G3 or H3.

As you can see, cells C3, D3, and E3 affect the value of the sum cell. Those three cells are highlighted in a blue box with an arrow pointing to the sum cell. It’s pretty straight-forward, but if you have some really complicated formulas that use complicated functions too, then there may be a lot of arrows going all over the place. If you have any questions, feel free to post a comment and I’ll try to help. Enjoy!

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida Loo Dhaqaajiyo Columns gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Ku xidhida Excel iyo MySQL

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Sida looga saaro Gridlines gudaha Excel

• Sida Loo Raadiyo Excel

• Sida loo Hagaajiyo #N/A Khaladaadka gudaha Foomamka Excel sida VLOOKUP

• Sida Loo Isticmaalo Shaqada PMT ee Excel