Zvekuita kana fomula bar muExcel yanyangarika

MuExcel program interface, imwe yenzvimbo dzakakosha inogarwa neformula bar, iyo inokutendera kuti utarise uye uchinje zviri mukati memasero. Zvakare, kana sero riine fomula, rinoratidza mhedzisiro, uye fomula inogona kuoneka mumutsara wepamusoro. Saka, kubatsira kwechishandiso ichi kuri pachena.

Mune zvimwe zviitiko, vashandisi vanogona kuona kuti fomula bar yanyangarika. Muchikamu chino, tichaona kuti tingaidzorera sei kunzvimbo yayo, uye kuti sei izvi zvingaitika.

Solution 1: Vhura Kuratidza paRibhoni

Kazhinji kazhinji, kusavapo kweformula bar imhaka yekuti chiratidzo chakakosha chakabviswa muzvirongwa zveribhoni. Hezvino izvo zvatinoita munyaya iyi:

1. Chinja kune tab "Ona". Pano muboka rekushandisa "Ratidza" tarisa bhokisi riri pedyo nesarudzo "Formula Bar" (kana zvisina kukodzera).
2. Nekuda kweizvozvo, iyo formula bar inozoonekwa zvakare muhwindo rechirongwa.

Solution 2: Kuita shanduko kune zvigadziriso

Iyo formula bar inogona zvakare kudzimwa mumasarudzo echirongwa. Unogona kuidzorera zvakare uchishandisa nzira yatsanangurwa pamusoro, kana kushandisa chirongwa chekuita pazasi:

1. Vhura menyu "Faira".
2. Mufafitera rinovhurwa, pane runyorwa rwuri kuruboshwe, tinya chikamu "Parameters".
3. Mune parameters, chinja kune chikamu “Kuwedzera”. Muchikamu chikuru chehwindo kurudyi, penya mukati memukati kusvika tawana block yezvishandiso "Ratidza" (mune mavhezheni ekutanga echirongwa, boka rinogona kunge riine zita "Screen") Kutsvaga sarudzo "Ratidza formula bar", isa chiratidzo pamberi payo uye simbisa shanduko nekudzvanya bhatani OK.
4. Sezvakaitwa nenzira yakambokurukurwa yekugadzirisa dambudziko, mutsara unodzokera panzvimbo yawo.

Solution 3: dzosa application

Mune zvimwe zviitiko, iyo formula bar inomira kuratidza nekuda kwekukanganisa kana kuparara kwechirongwa. Excel kupora kunogona kubatsira mumamiriro ezvinhu aya. Ndokumbira utarise kuti matanho ari pasi apa ndee Windows 10, zvisinei, mumashanduro ekutanga eiyo sisitimu yekushandisa, anenge akafanana:

1. Open Control panel munzira ipi neipi yakanakira, semuenzaniso, kuburikidza Bha yekutsvaga.
2. Mushure mekugadzirisa kutarisa muchimiro chezvidhori zvakakura kana zvidiki, enda kuchikamu "Zvirongwa uye Zvimiro".
3. Mune uninstall uye shandura zvirongwa hwindo, tsvaga uye maka mutsara "Microsoft Office" (kana "Microsoft Excel"), wobva wadzvanya bhatani "Chinja" mumusoro werondedzero.
4. Mushure mekusimbisa shanduko, hwindo rekudzoreredza chirongwa richatanga. Kazhinji, matambudziko anogona kugadziriswa ne “Kukurumidza Kupora” (pasina kubatanidza kune network), saka, uchiisiya, tinya bhatani “Gadzirisazve”.Cherechedza: Yechipiri sarudzo ndeye "Network Recovery" inoda nguva yakawanda, uye inofanira kusarudzwa kana nzira yekutanga isina kubatsira.
5. Kudzorerwa kwezvirongwa zvakabatanidzwa muchigadzirwa chakasarudzwa kuchatanga "Microsoft Office". Mushure mekunge maitiro apera zvinobudirira, iyo formula bar nyaya inofanirwa kugadziriswa.

mhedziso

Saka, haufanirwe kunetseka kana kamwe kamwe iyo formula bar yanyangarika kubva kuExcel. Zvingangodaro zvinongoremara muzvirongwa zviri paribhoni kana mumasarudzo ekushandisa. Unogona kuibatidza nekungodzvanya zvishoma. Muzviitiko zvisingawanzoitiki, iwe unofanirwa kutendeukira kune maitiro ekudzoreredza chirongwa.