Chii Chirairo kana fx Bhari muExcel uye Chii Chandingaishandisa?
Bhuku rinoshandiswa - rinonziwo fx bar nemhaka yefx icon iri pedyo neyo - ibha yemhando yakawanda iri pamusoro pemisoro yema column in Excel neGoogle Spreadsheets.
Kazhinji kutaura kwayo, kushandiswa kwayo kunosanganisira kuratidza, kuchinja, uye kuisa dhiyabhorosi iri mumashizha ekushanda kana mumataiti.
Kuisa Data
Kunyanya kunyanya, bharamu yekuburitsa icharatidza:
- iyo nhamba kana nhamba yedata iyo iri mune ikozvino kana inoshanda sero;
- mazano anowanikwa mumusero unoshanda pane kupindura mhinduro;
- rutivi rwemasero anomiririra sarudzo dzakasarudzwa dzakasiyana mune imwe Excel chati.
Sezvo bharamu yakarongeka inoratidza maitiro ari mumasero panzvimbo pemigumisiro yemigumisiro, zviri nyore kuwana kuti masero ane zvinyorwa zvese kuburikidza nazvo.
Bhuku rekutsvaga rinoratidzawo kukosha kwakakwana kwenhamba dzakange dzakagadzirirwa kuratidzira zvishomanana nzvimbo dzepakati muchitokisi.
Kugadzirisa Mafomu, Matati, uye Dhiyabhorosi
Bhuku rekushandisa rinogonawo kushandiswa kugadzirisa mafomu kana imwe dhesi iri mukati memusero unoshandiswa chete nekunyanya pane data iri mubharuti yemurairi pamwe nemushonga we mouse.
Inogonawo kushandiswa kugadzirisa mararamiro ezvimwe nyaya dzakasiyana-siyana dzakasarudzwa mune imwe Excel chati.
Izvo zvinogonawo kuisa dhamusi mumatare anoshingaira, zvakare kuburikidza nekudhonza ne mouse hointer kuti uise insertion point.
Kuwedzera yeExcel Formula Bar
Nokuda kwemashoko akareba emadhaka kana mazano akaoma, bhora rekutsvaga muExcel rinogona kuwedzerwa uye fomu kana deta rakaputirwa pamiganhu yakawanda sezvinoratidzwa mumufananidzo uri pamusoro. Bhora rekugadzira haigoni kuwedzerwa muGoogle Spreadsheets.
Kuti kuwedzere bhadha yebharuti nemushonga:
- Hover the mouse pointer pedyo nechokumucheto chemuti webhandi kusvikira ichinjira mumuromo, museve wemisoro miviri - sezvinoratidzwa mumufananidzo;
- Pano apa, shandisa uye ubatisise bhodhi rezasi ye mouse uye tora pasi kuti uwedzere bhari yefomu.
Kuti uwedzere bharamu yemurairi nemakona ekutsvaga:
Tsananguro yebhokisi yekutsvaga bharamu yemuti ndiyo:
Ctrl + Shift + U
Izvi zvinogona kugadziriswa uye kusunungurwa zvose panguva imwechete, kana kuti, Ctrl uye Shift keys zvinogona kubatwa pasi uye tsamba U yekunyora yakasununguka uye yakasunungurwa yoga.
Kuti udzorere usingaenzaniswi hukuru hwemurairi wefomu, chengetedza zvitsva zvakafanana kechipiri.
Rongedza Mafomu kana Dhairiro paMiti Mirefu muBuromu Yomutemo
Kana imwe nguva Excel formula bar yakawedzerwa, danho rinotevera ndokuputira mafomu akawanda kana deta pamiganhu yakawanda, sezvinoonekwa mumufananidzo uri pamusoro,
Mutsara wekushandisa:
- Dzvanya pachitokisi mune pepa rekushanda iri rine formula kana data;
- Dzvanya nehomwe pointer kuti uise iyo insertion point pakuronga kwemuti;
- Dhinda vhii Alt + Pinda maikeri pane keyboard.
Nzira iyo kana deta iri kubva pakaputsika kusvika mberi ichaiswa pamutsara unotevera muburani remurairi. Dzokorora matanho ari pamusoro apa kuwedzera mamwe mapoka.
Ratidza / Viga Bhari Yemufomu
Pane nzira mbiri dziripo dzekuviga / kuratidza bharamu yekuisa mu Excel:
Nzira inokurumidza-inoratidzwa mumufananidzo uri pamusoro:
- Dzvanya paZviona tab yebhoni;
- Chengetedza / kusanudza Bhodhi yeBuramu sarudzo iri muBurisa boka rebhoni .
Nzira refu:
- Dzvanya paDhiyabhorosi tab yebhoni kuitira kuti uzarure mhando yekunyorera;
- Dzvanya pane Zvimwe zviri mu menyu kuti uzarure Excel Options dialog box ;
- Dzvanya paZvikudziridzirwa muboshwe riri kuruboshwe rwebhokisi rebhokisi;
- Muchikamu cheGurisa chekona pane, chengetedza / usatora Bhodhi yeBuramu.
- Dzvanya OK kuti ushandise kuchinja uye uvhare bhokisi rebhokisi.
NeGoogle Spreadsheets:
- Dzvanya paIndangariro yeMenu kuti uzarure pasi rezasi yezvinyorwa;
- Dzvanya paBuramu yepaBurudzo chingaita kuti uone (ona) kana kuti usabvisa (chivanze).
Kudzivirira Maitiro kubva Mukuratidzira muExcel Formula Bar
Excel's worksheet yokudzivirira inosanganisira chisarudzo chinodzivirira maitiro mumasero akavharidzirwa kubva pakuonekwa muburani remurairi.
Kuvhara mafomu, sekuvhara masero, inhano mbiri.
- Masero ane zvinyorwa akavanzwa;
- Chikwangwani chekushanda chekushandiswa chinoshandiswa.
Kusvikira danho rechipiri richiitwa, mazita acho acharamba achionekwa mubhairi remukati.
Danho 1:
- Sarudza uwandu hwemasero ane zvinyorwa zvakavanzwa;
- PaImba yebhu yebhoni, tsvaga paItemikirwo yokusarudza kuti uzarure mhando yezvidzidzo;
- Mune menyu, chengetai ma Format Cells kuti uzarure maDenesi eDaily dialog box;
- Mubhokisi rebhokisi, chengetedza paKachengetedzwa tab;
- Pano tab, sarudza Hidden check box;
- Dzvanya OK kuti ushandise shanduko uye uvhare bhokisi rebhokisi.
Danho 2:
- PaImba yebhu yebhoni, tsvaga paItemikirwo yokusarudza kuti uzarure mhando yezvidzidzo;
- Dzvanya paKachengetedza Sheet sarudzo pazasi kwerwendo kuti uzarure Bhokisi rekudzivirira Sheketi yebhokisi;
- Chengetedza kana kusanudza zvaunoda
- Dzvanya OK kuti ushandise kuchinja uye uvhare bhokisi rebhokisi.
Panguva ino, mazita akasarudzwa anofanira kunge akavanzwa kubva pakuona muburani remurairi.
✘, ✔ uye fx Icons mu Excel
The ✗, ✔ uye fx zviratidzo zviri pedyo ne-bar bar in Excel zvinogona kushandiswa ku:
- ✘ - kubvisa kushandiswa kana kupinda muchidimbu chekutsvaga kwemashoko mumusero unoshanda;
- ✔ - kupedzisa kupinda kana kugadzirisa kwedhesi iri mumasaiti anoshingaira - hausi kutamisa shingaira kushandiswa kune imwe sero;
- fx - kupa mutsvagwa wekuisa mabasa mukati memusero unoshandiswa nekuvhura Insert function dialog box kana ukasungirirwa.
Ikobhokisi yakaenzana yezvifananidzo, zvakafanana, ndeyi:
- chechi Esc - kanzura inogadziridza kana kupinda muchidimbu chepasita;
- Enter Key - inopedza kupinda kana kugadzirisa kwedhidhi mumusasa unoshandiswa - unofambisa kushandiswa kwesero kunowedzera kune rimwe sero;
- Shift + F3 - inovhura Insert dialog box;
Kugadziriswa muBuromu yeFomu ne Shortcut Keys muExpcel
Nzira yekutsvaga kemikisi yekodhi yekugadzirisa deta kana mazano ndeye F2 yezvose Excel neGoogle Spreadsheets. Nokutadza, izvi zvinobvumira kugoverwa mumusero unoshandiswa - iyo insertion point iri munzvimbo yesero apo F2 yakamanikidzwa.
MuExcel, zvinogoneka kuchinja mafomu uye deta mubhairi yebasa panzvimbo yesero. Kuita izvi:
- Dzvanya paDhiyabhorosi tab yebhoni kuitira kuti uzarure mhando yekunyorera;
- Dzvanya pane Zvimwe zviri mu menyu kuti uzarure Excel Options dialog box;
- Dzvanya paZvikudziridzirwa muboshwe riri kuruboshwe rwebhokisi rebhokisi;
- Muchikamu chezvikamu zvekugadzirisa chekona pane, chengetedza kubvumira kubvumira zvakananga mumusero ;
- Dzvanya OK kuti ushandise shanduko uye uvhare bhokisi rebhokisi.
Google Spreadsheets haibvumiri kutarisa zvakananga mubhadha rekushandisa kushandisa F2.