Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel

Anonim

Abakoraga mumyandikire ya MS Word wabonye uburyo hamwe no kwandika nabi amagambo cyangwa bakeka ko typos bigaragara ko ari hasi yerekana ibara ritukura. Kubwamahirwe, muri Madamu Extl Porogaramu, iyi mikorere irabuze cyane. Biragaragara ko ubwoko bwose bwo gukata, amagambo ahinnye hamwe nandi magambo yo kwandika muburyo bwahinduwe birashobora kwinjiza gahunda ibeshya, kandi bizahita byerekana ibisubizo bitari byo. Nubwo bimeze, imikorere nkiyi irahari, kandi irashobora gukoreshwa.

Shyiramo Ikirusiya

Gucapura byikora kubimbe nabyo ni amagambo yanditse bitagukoreshwa kubisanzwe, ariko haribibazo mubundi buryo muri gahunda. Iyo inyandiko zagenzuwe muburyo bwikora, muri 9 kuri 10, porogaramu isubiza amagambo yanditse nabi. Kuki ibi bibaho nuburyo bwo kubikosora gerageza kubimenya:

  1. Hejuru ya Panel, kanda buto ya dosiye hanyuma ujye kuri "ibipimo".
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_1
imwe
  1. Kurutonde ibumoso, hitamo "ururimi".
  2. Idirishya rikurikira Igenamiterere rifite ibintu bibiri. Mu rwego rwa mbere "guhitamo indimi zihindura indimi" urashobora kubona ko isanzwe ari ururimi rwikirusiya.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_2
2.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_3
3.
  1. Ibikurikira, dumanuka mu ndimi "Guhitamo Imizifizi no gufasha" ikintu. Hano kubisanzwe, nkuko mubibona, ururimi rwa Windows rwa Microsoft rwashyizweho, kandi ururimi rwimigati rwemewe.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_4
Bane
  1. Birakenewe gusimbuza Ikirusiya. Urashobora gukora imwe muburyo bukurikira: Kanda kumurongo wa "Ikirusiya" hanyuma ukande buto "Mburabuzi", cyangwa ukande kuri buto ikora hamwe numwambi hasi.
  2. Biracyayemera gusa, ukande kuri "ok". Idirishya rizagaragara hamwe nisaba kugirango risubiremo gahunda kugirango iko impinduka zitangire gukurikizwa. Turemeranya kandi tugasubira muburyo bwintoki.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_5
bitanu

Nyuma yo gutangira, gahunda igomba guhita ikora ururimi rwikirusiya.

Ibikenewe kugirango ushiremo imyandikire muri excel

Ibi ntabwo byuzuye kuri ibi, kandi ugomba gukora ibindi byinshi:

  • Muri porogaramu nshya yo gukora, jya kuri "dosiye" hanyuma ufungure "ibipimo".
  • Ubutaha dushishikajwe nigikoresho cya "imyandikire". Koresha idirishya rifungura ukanda umugozi wa LKM.
  • Turasanga umugozi "ibipimo byigihingwa cyimodoka ..." hanyuma ukande kuri lkm.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_6
6.
  • Jya ku idirishya ryafunguwe, aho ukeneye gukora igishushanyo "auto" igishushanyo (nk'itegeko rikorwa hamwe no gufungura idirishya).
  • Mu mutwe "erekana buto yibyo wahisemo" dusangamo imikorere. Hano, kugirango byoroshye gukorana nimbonerahamwe, birasabwa guhagarika imirimo myinshi, kurugero, "kora inyuguti zambere zibyifuzo" hanyuma "Andika amazina yiminsi uhereye ku nyuguti nkuru."
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_7
7.

Turamanuka kumanuka tukabona ko muri iyi myanda idirishya kandi irimo urutonde rwijambo ryifashisha. Igice cyibumoso cyasabye amahitamo yanditse nabi, kandi muburyo bukwiye bwo gukosora. Birumvikana ko uru rutonde ntirushobora kwitwa Byuzuye, ariko ni amagambo nyamukuru namakosa kururu rutonde arahari.

Mugice cyo hejuru hari imirima yamagambo akwiye yo gushakisha. Kurugero, tuzandika "Mashyna". Porogaramu ihita mumurima wibumoso izatanga ijambo ryo gucuruza imodoka. Ku bitureba, iyi ni "imodoka". Birashoboka ko amagambo yitonze atazaba. Noneho bizaba ngombwa kwinjira mubyanditse neza kandi hepfo kanda kuri buto yongeyeho. Igenamiterere rirarangiye, kandi urashobora kujya mutangizwa kuri cheque yimyandikire yikora muri Excel.

Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_8
umunani

Gukora Igenzura ryikora

Nyuma yameza no gufata amajwi yamakuru yose asabwa, hakenewe kugerageza imyandikire yinyandiko ibaho. Kugirango ukore ibi, kora urutonde rukurikira rwibikorwa:

  • Niba ukeneye kugenzura igice cyinyandiko gusa, hanyuma ugaragaze ukeneye kugenzurwa. Bitabaye ibyo, inyandiko yo guhitamo ntabwo ari ngombwa.
  • Hejuru ya porogaramu, shakisha "igikoresho cyo gusuzuma".
  • Ibikurikira, muri "imyandikire", shakisha buto "imyandikire" hanyuma ukande kuri lkm.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_9
icyenda
  • Idirishya rizafungura, aho rizasabwa gukomeza kugenzura imyandikire kuva mu ntangiriro y'urupapuro. Kanda buto Yego.
  • Igikoresho gimaze kubona ijambo rifite ikosa, ikiganiro agasanduku gazerekanwa nijambo ryakozwe na gahunda.
Nigute ushobora Gushoboza Kugenzura Igenzura muri Excel 12513_10
10
  • Muburyo bwa "Amahitamo", hitamo ijambo ryukuri hanyuma ukande "Gusimbuza" niba ijambo nkiryo riri mumyandiko, cyangwa "gusimbuza byose", niba hari amahirwe yo kubona amakuru yatoranijwe aboneka inshuro nyinshi.

Umwanzuro

Ibyo ari byo byose impuguke y'ururimi rw'ikirusiya utari, ntushobora na rimwe kwigirira icyizere rwose mu buryo bukwiye bw'inyandiko yanditse. Ikintu cyabantu kirimo gutekereza kumakosa yubwoko butandukanye. By'umwihariko kuri ibyo, gahunda ya Madamu Excel itanga igikoresho cyikizamini, gukoramo ushobora gukosora amagambo yanditse nabi.

Ubutumwa nkuko biri muri Excel birimo ikizamini cyandika cyagaragaye mbere kugirango ubone amakuru yamakuru.

Soma byinshi