Kushaikwa formula bar muExcel - zvekuita. 3 mhinduro kudambudziko kana iyo formula bar yakanyangarika

Imwe yenzvimbo huru mukukosha muExcel application ndiyo formula bar. Chinangwa chayo chakavakirwa pakuita masvomhu uye kugadzirisa zviri mukati memasero. Iyo peculiarity yeformula bar ndeyekuti nekusimbisa sero ine kukosha kwekupedzisira, kuratidzwa kwezviito zvakaitwa mukuverenga kuchaverengerwa. Nehurombo, dzimwe nguva mamiriro anomuka kana bhatani iri rikanyangarika kubva paExcel panel. Tichaongorora mamiriro akati wandei anogona kukonzera matambudziko akadaro, uye kuti anogadziriswa sei nenzira dzakapfava.

Iyo formula bar yakanyangarika: chii chikonzero

Pane zvikonzero zviviri chete zvakakosha nei iyi interface element inogona kunyangarika kubva kune toolbar - iyi ishanduko yeExcel marongero uye kutadza kwesoftware. Asi dzakakamurwa kuva nyaya dzakadzama.

Chikonzero #1: Shandura marongero ezvekudya

Dambudziko rerudzi urwu rinogona kuitika mushure mekunge mushandisi aregedza netsaona chinhu chine basa rekushanda kweformula bar. Ngationei nzira yekugadzirisa dambudziko:

1. Pamusoro peturubhu pane bhatani rekuona.
2. Nekutenderedza chitubu uye nekudzvanya bhatani rekuruboshwe, tinoenda kune inoenderana tebhu.
3. Wawana fomula mutsara, ona kana paine chikwekwe pamberi pacho. Isa kana zvichidiwa.
4. Somugumisiro wezviito zvakatorwa, mutsara uchadzoka zvakare muchirongwa chepurogiramu.

Chenjerera! Iwe haufanire kutangazve chirongwa kana komputa kugadzirisa marongero.

 Chikonzero #2: Excel Options Settings Yakachinjwa

Iyo formula bar inogona kunyangarika mushure netsaona kana nechisimba kuimisa mumasarudzo echirongwa. Kugadzirisa dambudziko racho, nzira mbiri dzinoshandiswa: yekutanga yakarondedzerwa kare, uye kugadzirisa dambudziko nenzira yechipiri, iwe uchada kubereka matanho ose mukutevedzana kwakafanana nekudzima basa iri. Ndeipi iri nyore uye inonzwisisika iri kumushandisi wePC kusarudza. Mhinduro nenzira yechipiri:

1. Pa toolbar, tsvaga "Faira" uye enda mberi.
2. Mune tab inovhura, unofanirwa kuwana "Settings". Sekutonga, iyo interface element inowanikwa pazasi pechirongwa.

3. Tevere, muhwindo rinovhurwa, dzika pasi kune "Advanced" mutsara, mushure mekudzvanya pane iyo "Yakawedzerwa sarudzo dzekushanda neExcel" ichaonekwa kuruboshwe.
4. Nekutenderera gumbo rembeva, tinosimudza peji kumusoro, kwatinowana "Screen" boka rezvirongwa.
5. Pazasi zvishoma unogona kuwana "Ratidza fomula bar".
6. Pane zvakasiyana, tarisa bhokisi.

Zvinokosha! Kusiyana neyakapfuura nzira yekugadzirisa dambudziko, iyi inoda kusimbiswa kwekuchinja kwesetting. Naizvozvo, kuti shanduko dziite, pazasi pezvirongwa zvekuwedzera zvema parameter, unofanirwa kudzvanya bhatani rekuti "OK", izvo zvinoreva kupedzwa kwezviito.

Chikonzero #3: Kuparara kwechirongwa kana huori

Kugadzirisa dambudziko, kana zvikanganiso zvakaitwa muzvirongwa, zvinogadziriswa zviri nyore, asi zvekuita kana chirongwa chikaparara, kana kuti chikatadza zvachose. Muchiitiko ichi, unofanirwa kuedza kudzorera Excel. Unotevera muenzaniso wekudzoreredza chirongwa uchishandisa Windows 10 semuenzaniso. Kunyangwe zvigadziriso mumavhezheni ekutanga eWindows zvakada kufanana:

1. Mukona yezasi kuruboshwe, tinya "Start" bhatani.
2. Mubhokisi rekutsvaga tinonyora "Control Panel".
3. Mushure mekuonekwa nehurongwa, vhura iyo application nekudzvanya bhatani rekuruboshwe.
4. Muchishandiso chinovhura, iwe unofanirwa kuseta kutaridzika kwezvidhori kuita diki uye enda ku "Zvirongwa uye Zvimiro".
5. Iyo Uninstall / Shandura Zvirongwa hwindo rinovhurwa. Pano tinowana application yatinoda (mune iyi kesi, Microsoft Excel kana Hofisi) uye tinya-kurudyi pairi. Mubhokisi rebhokisi rinoonekwa, unofanirwa kuisa bhatani re "Shandura". Zvakare, kuvhiya kunogona kuitwa nekudzvanya pazita rechirongwa nebhatani rekuruboshwe uye nekudzvanya mumusoro weiyo rondedzero yeakaonekwa interface element "Change".

6. Pakangotanga shanduko ichisimbiswa, hwindo idzva rekudzoreredza chirongwa richavhurwa. Pano iwe unofanirwa kusarudza imwe yenzira. Sezvo mutemo, "Kurumidza Kudzoreredza" yakakwana, iyo isingadi kubatana kweInternet. Naizvozvo, tinomisa sarudzo yedu pane chinhu ichi uye tinya bhatani re "Dzosera".

Iwindo re "Uninstall uye shandura purogiramu" rine yakajairwa Microsoft Office package, mushure mekutanga shanduko, kudzoreredza kwakazara kwezvirongwa zvese zvinosanganisirwa muchigadzirwa ichi kubva kuMicrosoft zvichaburitswa. Mirira kuti maitiro apedze uye ita shuwa kuti formula bar inoonekwa panzvimbo yayo. Kana izvi zvikasaitika, tarisa nzira yechipiri.

Zano! Nzira yechipiri "Dzosera pamusoro pemambure" inosarudzwa chete kana pasina chachinja mushure mekutanga nzira. Zvinoda nguva yakawanda uye yakagadzikana internet yekubatanidza.

mhedziso

Paunenge uchiona dambudziko nekurasikirwa kweformula bar, haufanire kupererwa uye kutya. Ndapota verenga chinyorwa ichi kutanga. Zvichida chikonzero chaiva shanduko yetsaona muzvirongwa zvepurogiramu, iyo inogadziriswa munyaya yemaminitsi. Mumamiriro ezvinhu akaipisisa, apo purogiramu inoparara, iwe uchada kudzorera Microsoft Office, iyo inoitwawo nyore nyore kana iwe ukatevera mirairo yose.