Ungalishintsha kanjani icala ku-Excel 2016, 2013 noma 2010

Abasebenzisi abaningi be-Excel bahlangabezana nobunzima ngenxa yokungakwazi ukushintsha ngokushesha isimo sombhalo kumakhasi okusebenza. Ngesizathu esithile, iMicrosoft yengeze lesi sici kuphela ku-Word futhi yashiya i-Excel ngaphandle kwayo. Kodwa lokhu akusho ukuthi udinga ukushintsha ngesandla umbhalo kuseli ngayinye - kunezindlela ezimbalwa ezimfushane. Ezintathu zazo zizochazwa ngezansi.

Imisebenzi ekhethekile ye-Excel

Ku-Excel, kunemisebenzi ebonisa umbhalo esimweni esihlukile - UKULAWULA(), PHANSI() и iprop(). Eyokuqala ihumusha wonke umbhalo ngosonhlamvukazi, eyesibili - iba ngofeleba abancane, eyesithathu iguqulela kuphela izinhlamvu zokuqala zamagama zibe ngosonhlamvukazi, enye ishiye ngofeleba abancane. Bonke basebenza ngesimiso esifanayo, ngakho-ke, basebenzisa eyodwa njengesibonelo - makube njalo UKULAWULA() - ungabona ukuthi uzisebenzisa kanjani zontathu.

Faka ifomula

1. Dala ikholomu entsha eduze kwaleyo ofuna ukuyishintsha, noma uma kufaneleka, vele usebenzise ikholomu engenalutho eduze kwetafula.

2. Faka uphawu olulinganayo (=) olulandelwa igama lomsebenzi (OKULAWULAYO) kuseli yekholomu eduze kwaphezulu kakhulu kwamaseli ombhalo ahlelekayo.

Kubakaki ngemva kwegama lomsebenzi, bhala igama leseli eliseduze ngombhalo (kusithombe-skrini esingezansi, leli yiseli C3). Ifomula izobukeka kanje =PROPISN(C3).

4. Hit Enter.

Iseli B3 manje seliqukethe umbhalo weseli C3 ngosonhlamvukazi.

Kopisha ifomula kumaseli angaphansi wekholomu

Manje ifomula efanayo ingasetshenziswa kwamanye amaseli kukholamu.

5. Khetha iseli eliqukethe ifomula.
6. Hambisa ikhesa esikweleni esincane (umaka wokugcwalisa), otholakala ngezansi kwesokudla seseli - umcibisholo wesikhombisi kufanele uphenduke ube yisiphambano.

7. Ukugcina inkinobho yegundane icindezelwe, hudula ikhesa phansi ukuze ugcwalise wonke amaseli adingekayo - ifomula izokopishelwa kuwo.
8. Khipha inkinobho yegundane.

Uma udinga ukugcwalisa wonke amaseli ekholomu emaphethelweni aphansi etafula, vele uhambise phezu komaka wokugcwalisa bese uchofoza kabili.

Susa ikholomu yomsizi

Manje kunamakholomu amabili anombhalo ofanayo kumaseli, kodwa esimweni esihlukile. Ukuze ugcine eyodwa kuphela, kopisha idatha kukholomu yomsizi, uyinamathisele kukholomu oyifunayo, bese ususa umsizi.

1. Khetha amaseli aqukethe ifomula bese uchofoza Ctrl + C.

2. Chofoza kwesokudla kweseli lokuqala elinombhalo owufunayo kukholamu ehlelekayo.
3. Ngaphansi kokuthi "izinketho zokunamathisela" khetha isithonjana Amanani kumenyu yokuqukethwe.

4. Chofoza kwesokudla kukholamu yomsizi bese ukhetha Susa.
5. Ebhokisini lengxoxo elivelayo, khetha Ikholomu Yonke. 

Manje konke sekwenziwe.

Incazelo ingase ibonakale iyinkimbinkimbi. Kodwa vele ulandele izinyathelo ezinikeziwe futhi uzobona ukuthi akukho lutho olunzima kuwo.

Ukuhlela umbhalo usebenzisa i-Microsoft Word

Uma ungafuni ukusebenzisana namafomula ku-Excel, ungasebenzisa umyalo ukushintsha icala ku-Word. Ake sibone ukuthi kusebenza kanjani.

1. Khetha amaseli ofuna ukwenza izinguquko kuwo.
2. Izicelo Ctrl + C noma chofoza kwesokudla endaweni ekhethiwe bese ukhetha Kopisha kumenyu yokuqukethwe.

3. Vula idokhumenti entsha ku-Word.
4. Cindezela Ctrl + V noma chofoza kwesokudla ishidi bese ukhetha Faka.

Manje ikhophi yethebula lakho ikudokhumenti ye-Word.

5. Khetha lawo maseli ethebula lapho ufuna ukushintsha isimo sombhalo.
6. Chofoza isithonjana Bhalisa, etholakala eqenjini Ifonti kuthebhu Ikhaya.
7. Khetha eyodwa kweziyisihlanu ongakhetha kuzo ohlwini lokudonsela phansi.

Ungaphinda ukhethe umbhalo futhi usebenzise Shift + F3 kuze kube umbhalo ulungile. Ngale ndlela, ungakhetha kuphela amacala amathathu okukhethwa kukho - icala eliphezulu, eliphansi kanye Nomusho (lapho umusho ngamunye uqala ngonobumba abakhulu, zonke ezinye izinhlamvu zingosonhlamvukazi abancane).

Manje njengoba umbhalo osethebulani ususesimweni osifunayo, ungakwazi ukumane uwukopishele ku-Excel.

Isebenzisa ama-VBA macros

Ku-Excel 2010 no-2013, kunenye indlela yokushintsha izinketho zombhalo - ama-VBA macros. Indlela yokufaka ikhodi ye-VBA ku-Excel futhi uyenze isebenze kuyisihloko sesinye isihloko. Lapha, kuzoboniswa kuphela amamakhro enziwe ngomumo angafakwa.

Ungasebenzisa i-macro elandelayo ukuguqula umbhalo ube ngosonhlamvukazi:

Ofeleba Abancane()

    Ngeseli Ngalinye Elikhethiwe

        Uma Kungeyona Iseli.HasFormula Bese

            Iseli.Value = UCase(Cell.Value)

        Qeda Uma

    Iseli Elilandelayo

Qeda i-Sub

Ezinhlamvu ezincane, le khodi izokwenza:

Izinhlamvu ezincane ezincane()

    Ngeseli Ngalinye Elikhethiwe

        Uma Kungeyona Iseli.HasFormula Bese

            Iseli.Value = LCase(Cell.Value)

        Qeda Uma

    Iseli Elilandelayo

Qeda i-Sub

Imakhro yokwenza igama ngalinye liqale ngohlamvu olukhulu:

Indawo Encane()

    Ngeseli Ngalinye Elikhethiwe

        Uma Kungeyona Iseli.HasFormula Bese

            Iseli.Value = _

            Isicelo _

            .Umsebenzi Weshidi Lokusebenzela _

            .Okufanele(Inani.Inani)

        Qeda Uma

    Iseli Elilandelayo

Qeda i-Sub

Manje uyazi ukuthi ungalishintsha kanjani icala lombhalo ku-Excel. Njengoba ubona, lokhu akunzima kangako, futhi akukho ngisho neyodwa indlela yokwenza - yiziphi izindlela ezingenhla ezingcono kuwe.