Izindlela Ezi-3 Zokushintsha Ikesi Lohlamvu ku-Excel 2013, 2010 kanye no-2007

Kulesi sihloko, ngifuna ukukutshela ngezindlela ezimbalwa zokushintsha isimo sezinhlamvu ku-Excel kusuka phezulu kuye kwezansi noma indlela yokubhala igama ngalinye ngosonhlamvukazi. Uzofunda ukuthi ungabhekana kanjani nemisebenzi enjalo ngosizo lwemisebenzi OKULAWULAYO и AMANDLA, usebenzisa i-VBA macros, futhi usebenzisa i-Microsoft Word.

Inkinga ukuthi i-Excel ayinikezi ithuluzi elikhethekile lokushintsha isimo sombhalo ekhasini lokusebenza. Kuseyimpicabadala ukuthi kungani iMicrosoft inikeze i-Word isici esinamandla kangaka futhi ayizange isingeze ku-Excel. Lokhu kungenza imisebenzi eminingi ibe lula kubasebenzisi abaningi. Kodwa ungajahi ukuthayipha kabusha yonke idatha yombhalo wetafula lakho ngesandla! Ngenhlanhla, kunezindlela ezinhle zokuguqula amanani ombhalo kumaseli ukuya kosonhlamvukazi noma abancane, noma ukubhala ngosonhlamvukazi igama ngalinye. Ake ngihlanganyele nawe ngalezi zindlela.

• Imisebenzi ye-Excel yokushintsha ikesi lombhalo
• Shintsha umbhalo werejista usebenzisa i-Microsoft Word
• Ikesi elishintshayo lisebenzisa i-VBA macro

Imisebenzi ye-Excel yokushintsha ikesi lombhalo

I-Microsoft Excel inezici ezintathu ezinhle ongazisebenzisa ukushintsha isimo sombhalo. yona Phezulu (UBHALISIWE), AMANDLA (AMAPHANSI) kanye OKUFANELE (PROPANACH).

• Umsebenzi Phezulu (UPPER) iguqula zonke izinhlamvu ezingosonhlamvukazi zibe ngosonhlamvukazi.
• Umsebenzi AMANDLA (LOWER) yenza zonke izinhlamvu ezingofeleba zibencane.
• Umsebenzi PROI-VIA (PROPER) ibhala ngosonhlamvukazi uhlamvu lokuqala lwegama ngalinye bese ibhala ngofeleba abancane bonke.

Yomithathu le misebenzi isebenza ngendlela efanayo, ngakho-ke ngizokukhombisa ukuthi omunye wayo usebenza kanjani. Ake sithathe umsebenzi njengesibonelo Phezulu (UBHALISIWE):

Ukufaka ifomula ku-Excel

0. Faka ikholomu entsha (yomsizi) eduze kwaleyo equkethe umbhalo ofuna ukuwuguqula.

Qaphela: Lesi sinyathelo singokuzithandela. Uma ithebula lingelikhulu, ungasebenzisa noma iyiphi ikholomu engenalutho eseduze.

0. 
1. Faka uphawu olulinganayo (=) kanye negama lomsebenzi Phezulu (PHEZULU) kuseli eliseduze lekholomu entsha (B3).
2. Kubakaki ngemva kwegama lomsebenzi, faka ireferensi yeseli efanelekile (C3). Ifomula yakho kufanele ibukeke kanje:

   =UPPER(C3)

   =ПРОПИСН(C3)

   lapho C3 iyiseli elinombhalo okufanele liguqulwe.

   

3. Cindezela Faka.Umfanekiso ongenhla ukhombisa lokho esitokisini B3 iqukethe umbhalo ofanayo no-in C3, ngosonhlamvukazi kuphela.

Kopisha ifomula phansi kwekholomu

Manje udinga ukukopisha ifomula kuwo wonke amaseli ekholomu asizayo:

4. Khetha iseli elinefomula.
5. Hambisa isikhombi sakho segundane phezu kwesikwele esincane (umaka wokugcwalisa ngokuzenzakalelayo) ekhoneni elingezansi kwesokudla seseli ekhethiwe ukuze isikhombi siphenduke sibe isiphambano esincane esimnyama.
6. Chofoza bese ucindezela inkinobho yegundane kwesokunxele bese uhudulela ifomula uye phansi kuwo wonke amaseli lapho ofuna ukuyikopisha khona.
7. Khipha inkinobho yegundane.

Qaphela: Uma udinga ukugcwalisa ngokuphelele ikholomu entsha (ufike kubude obugcwele betafula), khona-ke ungakwazi ukweqa izinyathelo 5-7 bese uvele uchofoze kabili kumaka wokugcwalisa okuzenzakalelayo.

Isusa ikholomu eyisiza

Ngakho, unamakholomu amabili anedatha yombhalo efanayo, ahluka kuphela uma kwenzeka. Ngicabanga ukuthi ufuna ukushiya ikholomu nenketho oyifunayo kuphela. Ake sikopishe amanani kusuka kukholomu yomsizi futhi siyisuse.

8. Khetha amaseli aqukethe ifomula bese uchofoza Ctrl + Cukuze uzikopishe.
9. Chofoza kwesokudla kuseli lokuqala kukholamu yokuqala.
10. Kumenyu yokuqukethwe ngaphansi Namathisela Izinketho (Namathisela Izinketho) khetha Izindinganiso (Amanani).Njengoba sidinga amanani ombhalo kuphela, sizokhetha le nketho ukuze sigweme amaphutha kumafomula esikhathini esizayo.
11. Chofoza kwesokudla kunoma iyiphi iseli yekholomu eyisiza bese ukhetha umyalo kumenyu yokuqukethwe Susa (Susa).
12. Ebhokisini lengxoxo Susa (Susa Amaseli) khetha inketho Ikholomu yonke (Ikholomu) bese uchofoza OK.

Kwenziwe!

Ngokombono, lokhu kungase kubonakale kuyinkimbinkimbi kakhulu. Nethezeka futhi uzame zonke lezi zinyathelo ngokwakho. Uzobona ukuthi ukushintsha icala ngemisebenzi ye-Excel akunzima neze.

Shintsha isimo sombhalo ku-Excel usebenzisa i-Microsoft Word

Uma ungafuni ukusebenzisana namafomula ku-Excel, ungashintsha isimo ku-Word. Nansi indlela le ndlela esebenza ngayo:

1. Khetha ububanzi ekhasini lokusebenza le-Excel ofuna ukushintsha kulo icala lombhalo.
2. Cindezela Ctrl + C noma chofoza kwesokudla bese ukhetha umyalo kumenyu yokuqukethwe Kopisha (Kopisha).
3. Dala idokhumenti entsha ye-Word.
4. Cindezela Ctrl + V noma chofoza kwesokudla ekhasini elingenalutho bese ukhetha umyalo kumenyu yokuqukethwe udla (Faka). Ithebula le-Excel lizokopishwa ku-Word.
5. Khetha umbhalo ofuna ukuwushintsha.
6. Kuthebhu ethuthukisiwe Ikhaya (Ekhaya) esigabeni Ifonti (Ifonti) chofoza isithonjana Shintsha Ikesi (Bhalisa).
7. Khetha eyodwa kwezingu-5 ongakhetha kuzo ohlwini lokudonsela phansi.

Qaphela: Ngaphezu kwalokho, ungacindezela inhlanganisela Shift + F3kuze kubekwe isitayela osifunayo. Ngalaba khiye, ungakhetha kuphela izinhlamvu eziphezulu nezincane, kanye necala kanye nasemisho.

Manje unetafula ku-Word elinekesi lombhalo elishintshiwe. Vele uyikopishe bese uyinamathisele endaweni yayo yokuqala ku-Excel.

Shintsha ikesi lombhalo nge-VBA macro

Ungasebenzisa futhi amamakhro e-VBA ku-Excel 2010 kanye no-2013. Ungakhathazeki uma ulwazi lwakho lwe-VBA lushiya okuningi okungafunwa. Bengingazi okuningi ngalokhu esikhathini eside esidlule, futhi manje sengingakwazi ukwabelana ngamamakhro amathathu alula ashintsha isimo sombhalo sibe ngosonhlamvukazi, abancane, noma ukubhala ngosonhlamvukazi igama ngalinye.

Ngeke ngiphambuke esihlokweni futhi ngikutshele indlela yokufaka nokusebenzisa ikhodi ye-VBA ku-Excel, njengoba lokhu kuchazwe ngokumangalisayo kwezinye izindatshana esizeni sethu. Ngizobonisa nje amamakhro ongawakopisha futhi uwanamathisele encwadini yakho.

• Uma ufuna ukuguqula umbhalo ube ngosonhlamvukazi, sebenzisa i-VBA macro elandelayo:

I-Sub Uppercase() Kuseli Ngalinye Elikhethiwe Uma Kungeyena Iseli.IneFormula Bese I-Cell.Value = UCase(Cell.Value) Iphela Uma Iseli Elilandelayo Liphetha Isihloko

• Ukuze usebenzise osonhlamvukazi abancane kudatha yakho, sebenzisa ikhodi eboniswe ngezansi:

Igama Elincane Elincane() Kuseli Ngalinye Elikhethiwe Uma Kungeyena Iseli.IneFormula Bese Bese Iseli.Value = LCase(Cell.Value) Iphela Uma Iseli Elilandelayo Liphetha Isihloko

• Nansi imakhro ezokwenza wonke amagama embhalweni aqale ngofeleba:

I-Sub Propercase() Kuseli Ngalinye Elikhethiwe Uma Kungeyena Iseli.IneFormula Bese Iseli.Value = _ Isicelo _ .Umsebenzi Weshidi Lokusebenzela _ .Efanele(Inani.Value) Iyaphela Uma Iseli Elilandelayo Liphetha Isihloko

Ngiyethemba ukuthi manje njengoba usuwazi amaqhinga ambalwa amahle okushintsha icala ku-Excel, lo msebenzi uzoba lula kuwe. Imisebenzi ye-Excel, i-Microsoft Word, ama-VBA macros ahlala esenkonzweni yakho. Kuncane kakhulu okusele okumele ukwenze - nquma ukuthi yimaphi kulawa mathuluzi owathanda kakhulu.