Pali mitundu itatu ya katatu yoyera - yofiira ndi yobiriwira - yomwe imagwiritsidwa ntchito ku Excel kusonyeza chidziwitso kwa wogwiritsa ntchito ponena za:
- zolakwika zomwe zingatheke mu selo
- kukhalapo kwa ogwiritsa ntchito ndemanga mu selo
Kuwonjezera pa mtundu, chitatuchi chikuwonekera m'makona osiyana a selo lamasewera :
- Chomera - pamwamba kumanzere
- Ofiira - pamwamba pomwe
Green Triangle
Kachipinda kamtundu wobiriwira kamapezeka mu selo pamene zomwe zili m'kati mwa selo zikuphwanya malamulo ena olakwika a Excel.
Malamulowa amatembenuzidwa ndi osasintha ndipo amayang'anitsitsa zolakwa zomwe zimachitika monga:
- maselo okhala ndi mayendedwe omwe amachititsa zolakwika - monga #VALUE! kapena # DIV / 0!
- Maonekedwe omwe ali osagwirizana kapena osiyana ndi mawonekedwe m'maselo oyandikana nawo
- Nambala zasinthidwa ngati deta
Ngati inu mutsegula pa selo lokhala ndi katatu wobiriwira, botani la zosalungama likuwonekera pafupi nalo.
Bulu la zolakwika zomwe mungasankhe ndi mawonekedwe a daimondi omwe ali ndi mzere wofiira umene uli ndi njira zothetsera zolakwikazo.
Kutembenukira pa Triangle
Kuwonongeka koyang'ana kumayendetsedwa mwachisawawa ku Excel kotero katatu katatu akuwonekera nthawi iliyonse ndipo paliponse pamene Excel imakhazikitsa kuti pali kuphwanya malamulo.
Izi zosasinthika zingasinthidwe mu bokosi la bokosi la Excel Options .
Kutseka zolakwika zowunika:
- dinani Fayilo> Zosankha kuti mutsegule bokosi la dialog
- mu gawo loyang'ana zolakwika pazanja lamanja, chotsani chizindikiro chochokera ku Lolani chotsatira cholakwika chakumbuyo
- dinani Cholondola kuti muvomere kusintha ndikutsegule Zokambirana za bokosi
Kusintha Kosayesa Kufufuza Malamulo
Kusintha kwa zolakwika pofufuza malamulo ogwiritsidwa ntchito mu bukhuli amapangidwa mu Excel Options dialog box.
Kusintha zolakwikazo kufufuza malamulo:
- Dinani Fayilo> Zosankha
- Mphindi Yoyang'anitsitsa Chigawo cha Gawolo muzanja lamanja, yonjezerani kapena kuchotsani zizindikiro zowunika kuti mutseke kapena kusiya njira zosiyanasiyana
- dinani Cholondola kuti muvomere kusintha ndikutsegule Zokambirana za bokosi
Kusintha Mtundu wa Triangle & # 39; s
Mtundu wosasintha wobiriwira wa katatu uwu ukhoza kusinthidwa mu Excel Options dialog box.
Kusintha mtundu wa katatu:
- Dinani Fayilo> Zosankha
- mu gawo loyang'ana zolakwika pazanja lamanja, sankhani mtundu wosiyana kuchokera pa pepala lapafupi pafupi ndi Kuwonetsa zolakwika pogwiritsa ntchito mtundu uwu
- dinani Cholondola kuti muvomere kusintha ndikutsegule Zokambirana za bokosi
Red Triangle
Kapepala kamene kali kofiira kumtunda wa kumanja kwa selo kumasonyeza kuti ndemanga yowonjezera yawonjezedwa ku selo.
Kuti muwerenge ndemanga, tumizani mouse pakhungu pa selo yomwe ili ndi triangle yofiira; bokosi lokhala ndi ndemanga lidzawonekera pafupi ndi selo.
Zowonjezera zomwe mungachite kuti muwonetse ndikuwonetsa ndemanga ndi:
- osayamika ndemanga kapena zizindikiro - ngakhale pamene amayendayenda pa selo lokhala ndi ndemanga
- nthawi zonse kusonyeza ndemanga ndi zizindikiro kwa maselo onse okhala ndi ndemanga
Kusintha kwa ndemanga kusinthika kumapangidwa mu Excel Options dialog box.
Kusintha zosankhazo:
- dinani Fayilo> Zosankha> Zowonjezera
- pansi pa> Kuwonetsera gawo kumanja lamanja, pangani kusintha Kwa maselo okhala ndi ndemanga amasonyeza: kusankha
- dinani Cholondola kuti muvomere kusintha ndikutsegule Zokambirana za bokosi
Zosankha za Excel zokonza, kusinthira, kusunthira, kapena kuchotsa ndemanga za selo zili pansi pa tabu Yoyongosoledwa mu gawo la Comments la riboni.