Ungahlukanisa kanjani umbhalo kumakholomu ku-Excel

Ukuhlukanisa umbhalo kusuka esitokisini esisodwa ngaphesheya kwamakholomu amaningi ngenkathi kugcinwa imininingwane yomthombo futhi ukuletha esimweni esijwayelekile kuyinkinga lapho umuntu angahlangana khona. Ukwephula umbhalo kumakholomu, kusetshenziswa izindlela ezahlukahlukene, ezinqunywe ngokususelwa kulwazi oluhlongozwayo, isidingo sokuthola umphumela wokugcina kanye nezinga lobuchwepheshe bomsebenzisi.

Kuyadingeka ukuhlukanisa igama ngokuya ngamakholomu ngamanye

Ukufeza isibonelo sokuqala, thatha itafula namagama abantu abahlukahlukene abhaliswe kulo. Lokhu kwenziwa kusetshenziswa umbhalo kwithuluzi lamakholamu. Ngemuva kokukhipha omunye wemibhalo, kutholwe iphutha Ukuthola umphumela wokufaneleka, kufanele wenze ukwahlukana kwegama ngokuya ngamakholomu ngamanye. Ungakwenza kanjani - cabanga ngokuqhubekayo. Incazelo Yezenzo:

1. Vula idokhumenti ngephutha langaphambilini.
2. Sigqamisa umbhalo ngokuvala i-LKM futhi selule ukukhethwa kwiseli eliphansi kakhulu.

okukodwa

1. Ku-Upper Ribbon Sithola "Idatha" - Go.

2.

1. Ngemuva kokuvula, ngithola "umsebenzi onemibhalo" yeqembu "kukholamu". Chofoza i-LKM bese uya ebhokisini lengxoxo elilandelayo.

3.

1. Ngokuzenzakalelayo, ifomethi yedatha yomthombo izosethelwa ku- "Ngabahlukanisi". Shiya bese uqhafaza inkinobho ethi "Next".
2. Ewindi elilandelayo, kuyadingeka ukuthola ukuthi yini uhlukanisi embhalweni wethu. Sinalesi "sikhala", okusho ukuthi sifaka umkhaza obhekene naleli nani futhi sivumelana nezenzo ezenziwa yizenzo ku- "Next".

okune

1. Ngemuva kwalokho udinga ukuthola ifomethi yedatha yekholomu. Ngokuzenzakalelayo, "okujwayelekile" kufakiwe. Ngolwazi lwethu, le fomethi ilungele kakhulu.
2. Etafuleni, khetha iseli lapho kuzobekwa khona umbhalo ohlelwe. Sizosuka kwikholamu yomthombo owodwa bese sibeka umnikelo ohambisanayo ekubhekaneni neseli. Ekugcineni, chofoza u- "Qeda".

isihlanu

6.

Umbhalo uhlukanise usebenzisa ifomula

Amafomula ayinkimbinkimbi angasetshenziselwa ukwahlukaniswa okuzimele kombhalo. Bayadingeka ukubala ngokunembile isikhundla samagama esitokisini, ukutholwa kwezikhala nokwehlukanisa igama ngalinye ukuze lihlukanise amakholomu. Isibonelo, sizosebenzisa netafula negama. Ukwehlukanisa, kuzodingeka wenze izigaba ezintathu zesenzo.

Isinyathelo 1. Dlulisa izibongo

Ukuhlukanisa igama lokuqala, kuzothatha isikhathi esincane, ngoba ukunquma isikhundla esifanele okudingeka ucindezele kuphela kusuka esikhaleni esisodwa. Okulandelayo, sizokwazi ukuhlaziya imiyalo yesinyathelo ngesinyathelo ukuze siqonde ukuthi yini ukubala iyadingeka ecaleni elithile.

1. Ithebula elinegama elibhaliwe selivele lenziwe. Ukuze kube lula ukwenza ukwahlukaniswa kwemininingwane, dala endaweni ehlukile yekholomu 3 bese ukhipha incazelo. Chitha ukulungiswa kwamaseli ngosayizi.

7.

1. Khetha iseli lapho imininingwane ngegama lomndeni izorekhodwa khona. Yenza kusebenze ngokucindezela i-LKM.

isishiyagalombili

1. Chofoza inkinobho ethi "Izimpikiswano Nemisebenzi", ukucupha kwayo okunomthelela ekuvulekeni kwewindows ukuhlela ifomula.
2. Lapha esigabeni esithi "isigaba" udinga ukupheqa phansi bese ukhetha "umbhalo".

isishiyagalolunye

1. Okulandelayo, sithola ukuqhubeka kwefomula yeLevsimv bese uchofoza kulolu limugqa. Sivumelana nezenzo ezenziwa ngokucindezela inkinobho ethi "Kulungile".
2. Kuvela iwindi elisha, lapho udinga khona ukucacisa ukubhekana neseli elidinga ukulungiswa. Ukuze wenze lokhu, chofoza okubalwa "umbhalo" bese wenza kusebenze iseli elidingekayo. Ukulungisa kufakwe ngokuzenzakalelayo.
3. Ukucacisa inani elidingekayo lezinhlamvu, ungazibala ngesandla bese ufaka idatha kwigrafu efanele noma ukusebenzisa enye ifomula: Sesha ().
4. Ngemuva kwalokho, ifomula izokhonjiswa embhalweni weseli. Chofoza kuyo ukuvula iwindi elilandelayo.

Okuthenyalwayo

1. Sithola insimu "Umbhalo wesikole" bese uqhafaza ku-Uhlukanisi elicacisiwe embhalweni. Kuthu, lesi yisikhala.
2. In the "Umbhalo we-Search" field, udinga ukwenza kusebenze iseli elihlelekile eliphumela ekudluliseleni ngokuzenzakalelayo kukheli.
3. Yenza kusebenze umsebenzi wokuqala ukuze ubuyele ukuhlela. Lesi senzo sizokhombisa ngokuzenzakalelayo inani lezinhlamvu esikhaleni.

ishumi nanye

1. Siyavuma bese sichofoza inkinobho ethi "Kulungile".

Ngenxa yalokhu, kungabonakala ukuthi iseli liyalungiswa futhi isibongo senziwa kahle. Ukuze izinguquko zisebenze kuyo yonke imigqa, donsela umaki wokukhetha phansi.

Isinyathelo 2. Dlulisa amagama

Ukuze uhlukanise igama lesibili, kuzothatha amabutho amaningi nesikhathi, njengoba ukwahlukana kwamagama kwenzeka ngezikhala ezimbili.

1. Njengefomula eyinhloko, sibeka okufanayo ngendlela efanayo = i-PSTR (.

Okuqophele imali

1. Khetha iseli bese ucacisa isikhundla lapho umbhalo oyinhloko ubhaliswe khona.
2. Iya kukholamu "yokubeka isikhundla" bese ufaka ifomula yokusesha ().
3. Iya kukho usebenzisa imiyalo edlule.

13

1. Emugqeni "Iskim Text" Line chaza isikhala.
2. Ngokuchofoza "umbhalo ukuze useshe", yenza kusebenze iseli.

ishumi nane

1. Sibuyela kwifomula = PST phezulu kwesikrini.
2. Ku-string "nach.position" sithi sibonisa ifomula +1. Kuzoba nomthelela ekuqaleni kwe-akhawunti kusuka ocingweni olandelayo kusuka esikhaleni.

ishumi nanhlanu

1. Iya encazelweni yenombolo yezinhlamvu - Faka usesho lwefomula ().
2. Iya kule formula phezulu bese ugcwalisa yonke imininingwane esele iqondakale kuwe.
3. Manje umugqa we- "NACH.Poposition" unganqunywa yifomula yokusesha. Yenza kusebenze enye inguquko ngefomula bese ugcwalisa yonke imigqa ngendlela eyaziwayo, ngaphandle kokukhomba noma yini ku- "NACH.Poposition".
4. Iya ekusesheni kwefomula edlule naku- "NACH.Poposition" Faka +1.
5. Sibuyela kwifomula = PST nase "nambili yezimpawu" I-String engeza isisho sesesho (""; A2) -1.

16 Isigaba 3. Gcina i-patronymuc

1. Ngokwenza kusebenze iseli bese uphendukela ezimpikiswaneni zomsebenzi, khetha ifomula ye-Pracemir. Chofoza u- "Kulungile".

17.

1. In the "Umbhalo", faka ikheli leseli elihlelekayo.
2. Lapho ufuna ukucacisa inani lezimpawu, bhala i-DLSTR (A2).

ishumi nesishayagalombili

1. Ukunquma ngokunembile inani lezimpawu ekugcineni, kufanele ubhala: -Poisk ().
2. Iya ukuhlela ifomula. Embhalweni we- "Iskim" chaza isikhala. Ku- "Umbhalo Wokusesha" - Ukulungisa iseli. Ku- "NACH.Poposition" Faka ifomula yokusesha (). Hlela ifomula ngokubeka izincazelo ezifanayo.
3. Iya ekusesheni okwedlule kanye ne-string "nach.oposition" engeza +1.

ishumi nesishiyagalolunye

1. Iya kwifomethi ye-PratseMV futhi uqiniseke ukuthi zonke izenzo zenziwa kahle.

amashumi amabili

Ukugcina

Le ndatshana idlulise ukujwayela izindlela ezimbili ezivamile zokuhlukanisa imininingwane kumaseli amakholomu. Ukulandela imiyalo engafinyeleleki, ungakwazi kalula ukutholakala kwalezi zindlela futhi uzisebenzise ekusebenzeni. Ubulukhuni bokuhlukaniswa kwamakholomu besebenzisa amafomula bangasunduza kusukela okokuqala kwabasebenzisi abangenalwazi lwe-Excel, kepha ukusetshenziswa kwendlela okusebenzayo kuzosiza ukujwayela ukujwayela futhi ukukusebenzisa ngokuzayo ngaphandle kwezinkinga.

Umlayezo wokuthi ungahlukanisa kanjani umbhalo kumakholomu e-Excel ubonakale kuqala kubuchwepheshe bolwazi.