Mararka qaarkood sifada weyn ee arjiga waligeed ma helin aqoonsiga uu u qalmo iyo Daaqadda Daawashada^{(Watch Window)} ee Excel waa tusaale weyn oo ka mid ah astaamahan.

Haddii aad si joogto ah u isticmaasho Excel, waxa ay u badan tahay in aad ka soo shaqeysay waraaqo shaqo oo aad u waaweyn kuwaas oo gaaraya boqollaal, haddaysan ahayn kumannaan saf. Waxay noqon kartaa mid faa'iido leh haddii qaar ka mid ah unugyada aad u baahan tahay inaad la socoto inta badan laga yaabo in lagu soo bandhigo daaqad gaar ah si aad u aragto qiimaha hadda iyo qaaciddada ee jaleecada. Microsoft waxay^(Microsoft) u abuurtay Daaqadda Watch Excel^{(Excel Watch Window)} ujeedadaas saxda ah.

Isticmaalka Daaqadda Watch Excel

Isticmaalka daaqadda daawashada^{(Watch Window)} , waxaad ka soo saari kartaa unugyada muhiimka ah daaqad gooni ah oo aad halkaas kula socon karto, taas oo kaa badbaadinaysa inaad ku duubto dhammaan xaashida shaqada.

Bal aynu eegno tusaalaha hoose. Aynu nidhaahno xogtani waa qayb ka mid ah xogta aad u weyn, waxaanan rabnaa inaan la soconno dhowr unug oo muhiim ah oo badanaa isbedela.

Guji tabka Formulas ee ku yaal ^(Formulas)Ribbon oo hel badhanka cinwaankiisu yahay Daaqadda Daawashada^{(Watch Window)} ee qaybta Hanti-dhawrka Formula^{(Formula Auditing)} .

Tani waxay furi doontaa sanduuqa wada hadalka ee daaqadda^{(Watch Window)}  . Sanduuqa, dabcan, waa faaruq maadaama aynaan weli ku darin wax unugyo ah oo la socdo.

Hadda aan ku darno unug daaqadda daawashada. Si tan loo sameeyo, dhagsii isku xirka ku dar Watch^{( Add Watch)} oo ku yaal xagga sare ee sanduuqa wada hadalka.

Sanduuqa wadahadalka ku dar Watch^{(Add Watch)} , waxaad ku dooran kartaa unugyo laba siyaabood midkood. Waxaad si toos ah ugu qori kartaa tixraaca unugga ama waxaad dooran kartaa unugyada jiirkaaga. Ku qorista unugyada si toos ah ayaa faa'iido leh marka aad haysato hal ama laba unug oo kaliya oo aad rabto inaad la socoto.

Si kastaba ha ahaatee, kuma koobna inaad doorato hal ama dhawr unug markiiba. Waxaad ku dari kartaa unugyo iskuxiran daaqada daawashada^{(Watch Window)} adigoo gujinaya oo jiidaya jiirkaaga si aad u doorato unugyo taxane ah. Markaad dhammayso, dhagsii badhanka Add .

Waxaad ogaan doontaa waxyaabo yar ka dib markaad ku darto unugga (yada) Daaqadda Daawashada^{(Watch Window)} . Marka hore, Excel wuxuu bilaabay la socodka unugyada. Isbeddel kasta oo lagu sameeyo qiimaha ama qaaciidada unuggaas ayaa isla markaaba ka muuqan doona dariishada daawashada^{(Watch Window)} .

Marka labaad, Daaqadda Daaqadda^{(Watch Window)} ayaa sidoo kale kuu soo sheegaysa macluumaad kale oo muhiim ah oo ku saabsan unugyada, oo ay ku jiraan buugga shaqada iyo xaashida shaqada ee ay unugyadu deggan yihiin iyo magaca unugga, haddii aad mid siisay.

Haddii aad door bidayso, waxaad xitaa u jiidi kartaa daaqadda daaqadda^{(Watch Window)} mid ka mid ah dhinacyada Excel si aad ugu xidhato si aanay meel qiimo leh ugu qaadan xaashida shaqada ee sabbaynaysa.

Waxaad ku dari kartaa unugyo waraaqo shaqo oo kale isla buuga shaqada ee  Excel , laakiin kuma dari kartid unug buug shaqo kale ah. Buug kasta oo shaqo waxa uu leeyahay daaqadda daawashada^{(Watch Window)} oo gooni ah . Haddii aad ku shaqeyso xaashiyaha waaweyn, Daaqadaha Daawashada^{(Watch Window)} waa badbaadiyaha waqtiga dhabta ah waxayna u badan tahay inay kordhiso wax soo saarkaaga adiga oo kuu oggolaanaya inaad waqti badan ku qaadato shaqadaada iyo waqti yar oo aad gujiso agagaarka Excel . Haddii aad wax su'aalo ah qabtid, xor u noqo inaad faallo ka bixiso. Ku raaxayso!

Sidoo kale, hubi inaad hubiso maqaaladeyda kale ee Excel halkaas oo aad ka baran karto shaandhaynta xogta^{(filter data)} , geliso xaashida Excel ee Word^{(insert an Excel spreadsheet into Word)} , fur marar badan oo Excel ah^{(open multiple instances of Excel)} , la soco isbeddelada Excel^{(track changes in Excel)} iyo ka jar taariikhaha Excel^{(subtract dates in Excel)} .

Use the Excel Watch Window to Monitor Important Cells in a Workbook

Sometimes a great featurе in an application never gets the recognition it deserves and the Watch Window in Excel is a great еxample of one such fеature.

If you use Excel regularly, you probably have worked on some very large worksheets that span hundreds, if not thousands of rows. It could be useful if some of the cells you need to monitor often could be displayed in a separate window so that you could see the current value and formula at a glance. Microsoft created the Excel Watch Window for that exact purpose.

Using the Excel Watch Window

Using the Watch Window, you can pull out important cells into a separate window and keep track of them there, which saves you from having to scroll all over your worksheet.

Let’s take a look at the example below. Let’s say this data is part of a much bigger data set and we want to monitor a few important cells that change quite often.

Click on the Formulas tab on the Ribbon and locate the button titled Watch Window under the Formula Auditing section.

This will open up the Watch Window dialog box. The box, of course, is empty since we haven’t added any cells yet to monitor.

Now let’s add a cell to the watch window. To do this, click on the Add Watch link located at the top of the dialog box.

In the Add Watch dialogue box, you can choose cells in one of two ways. You can either type the cell reference in directly or you can select the cells with your mouse. Typing in the cells directly is useful when you have only one or two cells you want to monitor.

However, you are not limited to selecting only one or a few cells at a time. You can add contiguous cells to the Watch Window by clicking and dragging your mouse to select a series of cells. When you are done, click on the Add button.

You’ll notice a few things after you add the cell(s) to the Watch Window. Firstly, Excel has started monitoring the cells. Any changes to the value or formula for that cell will immediately show up in the Watch Window.

Secondly, the Watch Window also reports other important information to you about cells, including the workbook and worksheet in which the cells reside and the name of the cell, if you gave it one.

If you prefer, you can even drag the Watch Window to one of the sides of Excel to dock it so that it doesn’t take up valuable space on the worksheet floating around.

You can add cells from other worksheets within the same Excel workbook, but you can’t add cells from another workbook. Each workbook has its own separate Watch Window. If you work with large spreadsheets, Watch Window is a real time saver and is likely to increase your productivity by allowing you to spend more time on your work and less time clicking around in Excel. If you have any questions, feel free to comment. Enjoy!

Also, make sure to check out my other Excel articles where you can learn to filter data, insert an Excel spreadsheet into Word, open multiple instances of Excel, track changes in Excel and subtract dates in Excel.

Related posts

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

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

• U qaabeeya Unugyada iyadoo la isticmaalayo Habaynta Shuruudaha ah ee Excel

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

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Sida loo xisaabiyo kala duwanaanshaha Excel

• Sida Loo Sameeyo Kaarka Salaan ee MS Word

• Sida Loo Abuuro Liiska Qaybinta Muuqaalka

• Sida loo daro oo loo daabaco sawirada asalka ah ee Excel

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive

• Sida loo xafido erayga sirta ah ee Excel File

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

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

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

• Sida loo saaro, loo jebiyo, ama loo jebiyo erayga sirta ah ee Excel XLS ee la iloobay