Shintsha ukufaka ikhodi ku-Microsoft Excel

Isidingo sokushintsha ukufakwa kombhalo kwesinye isikhathi kubhekwana ngaso nabasebenzisi abasebenza iziphequluli, abahleli bemibhalo nezinhlelo zokusebenza. Kodwa-ke, lapho usebenza nge-processor yespredishithi ye-Excel, isidingo esinjalo naso singavela, ngoba lolu hlelo alwenzi izinombolo kuphela, kodwa futhi nombhalo. Ake sibheke ukuthi ungayishintsha kanjani ikhodi ku-Excel.

Isifundo: Ukubhalwa ku-Microsoft Word

Sebenza ngokubhalwa kombhalo

Ukubhalwa kombhalo kuyisethi yezitatimende zedijithali zedijithali eziguqulwa zibe izinhlamvu ezisebenziseka kalula. Kunezinhlobo eziningi zokubhala ngekhodi, ngayinye yazo inemithetho nolimi lwayo. Amandla wohlelo lokubona ulimi oluthile futhi aluhumushe lube yizimpawu eziqondakala kumuntu ojwayelekile (izinhlamvu, izinombolo, nezinye izimpawu) inquma ukuthi uhlelo lokusebenza lungasebenza nombhalo othize noma cha. Phakathi kokufakwa kombhalo okudumile kukhona okulandelayo:

• IWindows-1251;
• KOI-8;
• ASCII;
• ANSI
• I-UKS-2;
• UTF-8 (Unicode).

Igama lokugcina livame kakhulu phakathi kokufakelwa emhlabeni, ngoba lithathwa njengohlobo lwenqubo yendawo yonke.

Kaningi, uhlelo uqobo lwalo lubona ukufakwa kwikhodi futhi kushintshela kulo ngokuzenzakalelayo, kepha kwezinye izikhathi umsebenzisi kudingeka atshele uhlelo lokusebenza ukubukeka kwalo. Kungaleso sikhathi kuphela lapho kungasebenza khona kahle ngezinhlamvu ezifakiwe.

I-Excel ihlangabezana nenombolo enkulu kunazo zonke yezinkinga zokufihla ukuguquguqula lapho izama ukuvula amafayela we-CSV noma ukuthumela amafayela e-txt. Imvamisa, esikhundleni sezinhlamvu ezijwayelekile lapho sivula lawa mafayili nge-Excel, singabona izinhlamvu ezingejwayelekile, okuthiwa "krakozyabry". Kulezi zimo, umsebenzisi udinga ukwenza ngamacebo athile ukuze uhlelo luqale ukubonisa idatha kahle. Kunezindlela eziningana zokuxazulula le nkinga.

Indlela yoku-1: shintsha ukufaka ikhodi usebenzisa i-Notepad ++

Ngeshwa, i-Excel ayinathuluzi eligcwele eligcwele elizokuvumela ukuthi ushintshe ukushumeka ngokushesha kunoma yiluphi uhlobo lombhalo. Ngakho-ke, umuntu kufanele asebenzise izixazululo zezinyathelo eziningi ngalezi zinhloso noma asebenzise usizo kosizo lomuntu wesithathu. Enye yezindlela ezinokwethenjelwa ukusebenzisa umhleli wombhalo we-Notepad ++.

1. Sethula uhlelo lokusebenza lwe-Notepad ++. Chofoza entweni Ifayela. Ukusuka ohlwini oluvulayo, khetha "Vula". Ngenye indlela, ungathayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + O.



2. Ifayela elivulekile lefayela liqala. Siya kumkhombandlela lapho khona idokhumenti, ekhonjiswe ngokungafanele ku-Excel. Khetha bese uchofoza inkinobho. "Vula" phansi kwewindi.



3. Ifayela livula ewindini lomhleli we-Notepad ++. Phansi kwewindi ngakwesokunene sebha yesimo ukufakwa kwembhalo kwamanje. Njengoba i-Excel ingakhombisi kahle, kudingeka izinguquko. Sithayipha ukuhlanganiswa kwezinkinobho I-Ctrl + A kukhibhodi ukukhetha wonke umbhalo. Chofoza entweni yemenyu "Okubhaliwe". Kuluhlu oluvulayo, khetha Guqula ku-UTF-8. Lokhu kufakwa i-Unicode futhi i-Excel isebenza nayo ngokunembe ngangokunokwenzeka.



4. Ngemuva kwalokho, ukuze ugcine izinguquko kufayela, chofoza inkinobho kubha yamathuluzi ngendlela yediski. Vala i-Notepad ++ ngokuchofoza inkinobho ngesiphambano esimhlophe esikweleni esibomvu ekhoneni elingakwesokudla lewindi.



5. Sivula ifayili ngendlela ejwayelekile ngokusebenzisa umgubuzeli noma sisebenzise noma iyiphi enye indlela ku-Excel. Njengoba ukwazi ukubona, zonke izinhlamvu manje ziboniswa kahle.

Ngaphandle kokuthi le ndlela isuselwa ekusetshenzisweni kwesoftware evela eceleni, ingenye yezinketho ezilula zokudlulisa okuqukethwe kwamafayili ku-Excel.

Indlela yesi-2: Sebenzisa i-Umbhalo Wizard

Ngaphezu kwalokho, ungenza ukuguqulwa usebenzisa amathuluzi wohlelo owakhelwe ngaphakathi, okuyi-Umbhalo Wizard. Ngokudabukisayo, ukusebenzisa leli thuluzi kuyinkimbinkimbi kakhulu kunokusebenzisa uhlelo lomuntu wesithathu oluchazwe ngendlela yangaphambilini.

1. Siqala uhlelo lwe-Excel. Kuyadingeka ukwenza uhlelo lokusebenza uqobo, futhi ungavuli idokhumenti ngosizo lwalo. Lokho wukuthi, ishidi elingenalutho kufanele livele phambi kwakho. Iya kuthebhu "Idatha". Chofoza inkinobho kubambo "Okusuka embhalweni"ibekwe ebhokisini lamathuluzi "Ukuthola imininingwane yangaphandle".



2. Kuvulwa iwindi lefayela lombhalo wokungenisa. Ixhasa ukuvulwa kwamafomethi alandelayo:
   • I-Txt;
   • CSV;
   • I-PRN.

   Iya kumkhombandlela wendawo yefayela elingenisiwe, likhethe bese uchofoza inkinobho "Ngenisa".



3. Kuvulwa iwindi le-Wizard Njengoba ukwazi ukubona, endimeni yokubuka kuqala izinhlamvu zikhonjiswa ngokungalungile. Ensimini "Ifomethi yefayela" vula uhlu olwehlayo bese ushintsha okubhalwe kulo I-Unicode (UTF-8).

   

   Uma idatha iboniswa ngokungalungile, khona-ke sizama ukuzama ukusetshenziswa kwamanye ama-encodings kuze kube yilapho umbhalo osendimeni yokubuka kuqala ukufundeka. Uma umphumela usenelisa, chofoza inkinobho "Okulandelayo".



4. Ukuvula iwindows wizard elandelayo. Lapha ungashintsha umlingisi we-delimiter, kepha kunconywa ukushiya izilungiselelo ezizenzakalelayo (ithebhu). Chofoza inkinobho "Okulandelayo".



5. Ewindini lokugcina, ungashintsha ifomethi yedatha yekholomu:
   • Okujwayelekile;
   • Umbhalo
   • Usuku
   • Yeqa ikholamu.

   Lapha amasethingi kufanele asethwe, kucatshangelwa uhlobo lokuqukethwe okusetshenzwe. Ngemuva kwalokho chofoza inkinobho Kwenziwe.



6. Ewindini elilandelayo, chaza izixhumanisi zeseli eliphezulu elingakwesobunxele lobubanzi kushidi lapho idatha izofakwa khona. Lokhu kungenziwa ngokushayela ngesandla ikheli ngekheli elifanele noma ngokugqamisa iseli elifunayo ekhasini. Ngemuva kokufakwa kwezixhumanisi, chofoza inkinobho enkombeni yewindi "Kulungile".



7. Ngemuva kwalokho, umbhalo uzokhonjiswa eshidini ekubhalweni kwesikhombi esikudingayo. Kuyasala ukufometha noma ukubuyisa ukwakheka kwetafula, uma bekuyidatha yetafula, ngoba ukuyiguqula kuyayibhubhisa.

Indlela 3: gcina ifayela kusikhombi esithile

Kunesimo sokubuyela emuva lapho ifayili lingadingi kuvulwa ngesiboniso sedatha esifanele, kodwa lilondolozwe kokufakwa kukhodi okusunguliwe. E-Excel, ungawenza lo msebenzi.

1. Iya kuthebhu Ifayela. Chofoza entweni Gcina Njengo.



2. Iwindows yedokhumenti iyavula. Sisebenzisa isikhombimsebenzisi sokuhlola, sinquma umkhombandlela lapho ifayili lizogcinwa khona. Ngemuva kwalokho sibeka uhlobo lwefayela uma sifuna ukugcina ibhuku lokusebenza ngefomethi ehlukile kufomethi evamile ye-Excel (xlsx). Bese uchofoza ipharamitha "Insizakalo" futhi ohlwini oluvulayo, khetha Izinketho Zedokhumenti yeWebhu.



3. Ewindini elivulayo, iya kuthebhu "Ukufaka ikhodi". Ensimini Gcina Idokhumenti Njengo vula uhlu olwehlayo bese usetha ohlwini lolohlobo lokufakiwe esikubona kudingekile. Ngemuva kwalokho chofoza inkinobho "Kulungile".



4. Buyela emuva ewindini "Gcina Idokhumenti" bese uchofoza inkinobho Gcina.

Idokhumenti izogcinwa kukhompiyutha eqinile noma imidiya ekhiphekayo kokufakwa kwekhodi ngokwakho. Kepha udinga ukubheka ukuthi manje amadokhumenti ahlala egcinwe ku-Excel azosindiswa kulokhu kufakwa ikhodi. Ukuze ushintshe lokhu, kufanele uye ewindini futhi Izinketho Zedokhumenti yeWebhu futhi ushintshe izilungiselelo.

Kukhona enye indlela yokushintsha izilungiselelo zokubhalwa kombhalo ogciniwe.

1. Ukuba kuthebhu Ifayelachofoza entweni "Izinketho".



2. Kuvulwa iwindows ongakhetha kukho. Khetha isigaba "Kuthuthukile" kusuka kuhlu olusekwe ohlangothini lwesobunxele lwewindi. Skrolela phansi maphakathi nefasitela uye kwibhulokhi yezilungiselelo "Okujwayelekile". Bese uchofoza inkinobho Izilungiselelo Zekhasi leWebhu.



3. Iwindi selivele lisijwayele Izinketho Zedokhumenti yeWebhu, lapho senza zonke izinto ezifanayo esasikhulume ngazo ngaphambili.



Manje noma yimuphi umqulu ogcinwe ku-Excel uzoba nokufaka ngqo okufakiwe.

Njengoba ukwazi ukubona, i-Excel ayinathuluzi elingakuvumela ukuthi uguqule ngokushesha futhi ngokuvumelanayo umbhalo usuka kokunye ukufakwa kwesinye kuya komunye. I-wizard yombhalo inokusebenziseka okuyinqaba futhi inezici eziningi ezingadingeki ngenqubo enjalo. Ukuyisebenzisa, kuzodingeka ukuthi uhambe ngezinyathelo ezimbalwa ezingathinti ngqo le nqubo, kepha usebenzela ezinye izinhloso. Ngisho nokuguqula ngokusebenzisa umhleli wombhalo wesithathu we-Notepad ++ kuleli cala kubukeka kulula. Ukulondolozwa kwamafayela kokufakiwe okukhishwe ku-Excel kubuye kube yinkimbinkimbi yokuthi njalo lapho ufuna ukushintsha lo mkhakha, kufanele ushintshe izilungiselelo zohlelo lomhlaba jikelele.

Share
Pin
Tweet
Send
Share
Send