Umbala weseli kuxhomekeke kwixabiso kwi-Excel

Xa usebenza neetafile, ixabiso eliphambili linamaxabiso aboniswe kuyo. Kodwa icandelo elibalulekileyo likwayilo lwayo. Abanye abasebenzisi bayijonga njengento yesibini kwaye abanikeli ingqalelo kuyo kuye. Kwaye ngelize lilize, kuba itafile entle ehlotywe yimeko ebalulekileyo yokuqonda okungcono kunye nokuqonda ngabasebenzisi. Ukuboniswa kwedatha kudlalwa ikakhulu koku. Umzekelo, ukusebenzisa izixhobo zokuHloboya, unokupeyinta iiseli zetafile ngokuxhomekeke kwimixholo yazo. Masifumanise ukuba kungenziwa njani kwinkqubo ye-Excel.

Inkqubo yokutshintsha umbala weeseli ezixhomekeke kumxholo

Ewe kunjalo, kusoloko kuhle ukuba netafile enziwe kakuhle, apho kuxhomekeka khona kwiiseli ezixhomekeke kwimixholo zipeyintiwe ngemibala eyahlukeneyo. Kodwa eli nqaku lifaneleke kakhulu kwiitafile ezinkulu ezinoluhlu lwedatha ebalulekileyo. Kule meko, ukuzalisa ngombala weeseli ezizezisi kuya kuqhuba kakhulu ukuqhelaniswa nabasebenzisi kulo mninzi wolwazi, njengoko kunokuthethwa ukuba sele ugqityiwe.

Izinto ezinamagqabi zinokuzama ukupeyinta ngesandla, kodwa kwakhona, ukuba itafile inkulu, iya kuthatha ixesha eliqinisekileyo. Ukongeza, kwi-dart enjalo yedatha, into yomntu inokudlala indima kwaye iimpazamo ziya kuvunyelwa. Ukungakhankanya itafile kunokuba yinto enamandla kunye nedatha kuyo amaxesha onke, kwaye ngokukhululekileyo. Kule meko, ukutshintsha ngesandla umbala ngokubanzi kuya kuba yinto engeyiyo.

Kodwa imveliso ikho. Kwiiseli eziqukethe iinqobo zokuziphatha (ukutshintsha) iinqobo zokusebenza ezisetyenzisiweyo, kunye nedatha yeenkcukacha-manani onokuzisebenzisa "Fumana kwaye ubeke endaweni ye" isixhobo.

Indlela yoku-1: Ukufomatha ngokwemiqathango

Sebenzisa ukufomatha imeko, unokuchaza imida ethile yamaxabiso apho iiseli ziya kupeyinta ngombala omnye. I-Stain iya kuqhutywa ngokuzenzekelayo. Ukuba kwimeko yeselfowuni, ngenxa yotshintsho, iya kuba ngaphandle komda, iya kuyiphendula ngokuzenzekelayo eli nqaku ligqabi.

Makhe sibone ukuba le ndlela isebenza njani kumzekelo othile. Sinetafile yengeniso yeshishini, apho le datha iyoyika. Kufuneka sibalaselise ngemibala eyahlukeneyo yezo zinto zingaphantsi kwe-rubles engaphantsi kwama-400,000, ukusuka kwi-400,000 yeeruble ezingama-500,000 kwaye idlula i-ruble ezingama-500,000.

1. Sibonisa ikholamu apho ulwazi kwingeniso yeshishini ifumaneka khona. Emva koko sifudukela kwithebhu "yekhaya". Cofa kwi "fomating ufomatha enemiqathango", ekho kwiteyiphu kwibhloko "yesiToyles". Kuluhlu oluvula, khetha umxholo wolawulo lweMithetho.



2. Imigaqo yokufomatha eqhelekileyo isunguliwe. Umthetho "woBoniso lokuFeza" "kwintsimi kufuneka usekwe kwixabiso" langoku ". Ngokungagqibekanga, kuyinto ngokuchanekileyo kufuneka idweliswe apho, kodwa kwimeko, jonga kwaye kwimeko yokungahambelani, ukutshintsha useto ngezi zindululo ezingezantsi. Emva koko, cofa kwi "Yenza umthetho ..." iqhosha.



3. Ukufomatha umthetho we-imeyile kuvulwa. Kuluhlu lweentlobo zeMigaqo, khetha indawo "yefomathi kuphela equkethe". Kwibhloko yenkcazo, imigaqo kwintsimi yokuqala, iswitch kufuneka ime kwindawo ethi "Ixabiso". Kwintsimi yesibini, sibeka i-switch kwisikhundla "esingaphantsi". Kwintsimi yesithathu, chaza ixabiso, izinto zephepha elinenani eliza kupelwa ngombala othile. Kwimeko yethu, eli xabiso liya kuba ngama-400,000. Emva koko, cofa kwi "fomathi ..." iqhosha.



4. Ifestile yefowuni yeseli ivula. Yiya kwi-"Gcwalisa" ithebhu. Khetha umbala wokugcwalisa ukuba sinqwenela, ukuma iiseli ezinamaxabiso angaphantsi kwama-400,000. Emva koko, cofa iqhosha "Kulungile" emazantsi efestile.



5. Sibuyela kwifestile yokudalwa komthetho wokufomatha kwaye, nayo, nqakraza kwiqhosha "Kulungile".



6. Emva kwesenzo, siya kuphinda siphinde sibhengezwe kuMphathi weMithetho yokuTomatha. Njengoko ubona, ulawulo olunye lutshisiwe, kodwa kufuneka songeze ezimbini ezininzi. Ke ngoko, sicinezela "Yenza umthetho ..." kwakhona.



7. Kwaye kwakhona singena kwifestile yokudalwa. Yiya kwicandelo "Ifomati kuphela iiseli eziqulathe". Kwicandelo lokuqala leli candelo, sishiya "iPaloku" Ixabiso leselfowuni ", nakwisibini iseti iswitshi" phakathi "kwesikhundla. Kwintsimi yesithathu, kuya kufuneka uchaze ixabiso lokuqala loluhlu apho izinto zephepha ziya kufatwa. Kwimeko yethu, eli linani lama-400000. Kwisine, chaza ixabiso lokugqibela lolu luhlu. Iya kuba yi-500,000. Emva koko, cofa kwi "fomato ..." iqhosha.



8. Kwifestile yokufomatha, sibuyela kwithebhu "Gcwalisa", kodwa ngeli xesha sele ukhetha omnye umbala, emva koko ucofe iqhosha u "Kulungile".



9. Emva kokubuyela kwifestile yendalo, ndicofa iqhosha "Kulungile".



10. Njengoko sibona, imithetho emibini sele yenziwe kuMphathi weMithetho. Ke, kuya kuhlala kusenza isahlulo sesithathu. Cofa kwiqhosha "Yenza umthetho".



11. Ekudalweni kwefestile yeMithetho, phinda uye kwicandelo "ifomathi kuphela iiseli eziqulathe". Kwintsimi yokuqala, sishiya inketho "Ixabiso leseli". Kwicandelo lesibini, faka i-switch kwi "Pive" amapolisa amaninzi. Kwintsimi yesithathu, qhuba inani 500000. Ke, njengakwimeko yangaphambili, cofa kwi "fomathi ..." iqhosha.



12. Kwifomathi yeseli ", kwakhona qhubela phambili kwithebhu" yalisa ". Ngeli xesha sikhetha umbala owahlukileyo kwiimeko ezimbini zangaphambili. Yenza iqhosha iqhosha "Kulungile".



13. Kwimigaqo 'yokudalwa kwefestile, phinda ucinezele iqhosha "Kulungile".



14. IMithetho ye-Dispatcher iyavula. Njengoko ubona, yonke imithetho emithathu yenziwe, ngoko sicinezela iqhosha u "Kulungile.



15. Ngoku izinto zetafile zipeyintwe ngokweemeko ezithile kunye nemida ethile kwizicwangciso zokufomatha ngendlela.



16. Ukuba sitshintsha iziqulatho kwenye yeeseli, ishiya imida yenye yemithetho echaziweyo, emva koko le nto yephepha iya kutshintsha ngokuzenzekelayo umbala.

Ukongeza, kunokwenzeka ukuba usebenzise ukufomatha okunemiqathango ngokwahlukileyo kumbala wezinto zephepha ngombala.

1. Oku, emva koMphathi weMithetho, siya kwifestile ekufomeki, sihlala "kwifomathi yazo zonke iiseli ezisekwe kwicandelo labo". Kwintsimi "yombala", unokukhetha umbala, izithunzi eziya kuthi zithulule izinto zephepha. Emva koko kuya kufuneka ucofe iqhosha "Kulungile".



2. Kumphathi weMithetho, naye, cinezela iqhosha u "Kulungile".



3. Njengoko ubona, emva kokuba le seli kwikholamu ipeyintwe ngemibala eyahlukeneyo yombala ofanayo. Ixabiso eliqukeka liqhinga leSheet likhulu, ezantsi lilula kunezantsi - ubumnyama.

Isifundo: Ukufomatha ngokwemiqathango kwi-Excele

Indlela 2: Sebenzisa i "Fumana kwaye wabela" isixhobo "

Ukuba kukho idatha engabeki kwitafile, engacwangciswanga ukuba itshintshwe ngokuhamba kwexesha, ungasebenzisa isixhobo sokutshintsha umbala weeseli ngomxholo wazo obizwa ngokuba "fumana". Isixhobo esichaziweyo siya kukuvumela ukuba ufumane amaxabiso achaziweyo kwaye utshintshe umbala kwezi seli kumsebenzisi oyifunayo. Kodwa kufuneka kuqatshelwe ukuba xa betshintsha imixholo kwiziko lephepha, umbala awuyi kutshintsha ngokuzenzekelayo, kodwa uhlala kunjalo. Ukwenzela ukutshintsha umbala kwinto efanelekileyo, kuya kufuneka uphinde uphinde inkqubo kwakhona. Ke ngoko, le ndlela ayilunganga kwiitafile ezinomxholo onamandla.

Makhe sibone ukuba isebenza njani kumzekelo othile, apho sithatha itafile efanayo nengeniso yeshishini.

1. Sibonisa ikholamu ngedatha ekufuneka ifomathiwe ngombala. Emva koko yiya kwithebhu "yasekhaya" kwaye ucofe kwi "Fumana kwaye ukhethe" iqhosha, elikwe kwikhasethi kwi-Tepebar yokuhlela. Kuluhlu oluvula, cofa kwi "Fumana".



2. I "Fumana kwaye ithathe indawo ye" Window iqala kwithebhu "Fumana" ithebhu. Okokuqala, siya kufumana amaxabiso afikelele kwi-rubles engama-400,000. Kuba asinasisele, apho bekuya kuba ngaphantsi kwe-ruble engaphantsi kwama-300,000, enyanisweni, kufuneka sibalaselisa ngazo zonke izinto kumanani ukusuka kwi-300,000 ukuya kwi-400,000. Ngelishwa, kwityala Ukusetyenziswa kwefomathi yemeko, kule ndlela ayinakwenzeka.

   Kodwa kukho into enokwenzeka ngokwahlukileyo ukuba siza kunika isiphumo esifanayo. Unokuseta le template ilandelayo "3 ??? kwibar yokukhangela. Uphawu lombuzo uthetha nawuphi na umlinganiswa. Ke, le nkqubo iza kujonga onke amanani amathandathu aqala ngamanani "3". Oko kukuthi, ukukhangela ukukhangela kuya kuwa kuluhlu lwama-300,000 - 400,000, esiya kufuneka. Ukuba itafile ibingaphantsi kwe-300,000 okanye ingaphantsi kwe-200,000, emva koko ikhulu ngalinye kwikhulu lamawaka, ukukhangela kuya kufuneka kwenziwe ngokwahlukeneyo.

   Sazisa ibinzana elithi "3 ????? Kwi "Fumana" kwaye nqakraza kwiqhosha "Fumana yonke".



3. Emva koko, kwigumbi elingaphantsi lefestile, iziphumo zeziphumo zokukhangela zivulekile. Cofa kwiqhosha leqhosha lasekhohlo kuyo nayiphi na. Emva koko chwetheza i-CTRL + umdibaniso ophambili. Emva koko, zonke iziphumo zokukhutshwa kokukhutshwa zabelwe kwaye izinto ezikwikholamu zihluleke ngaxeshanye, ezibhekiswa kuzo ezi ziphumo.



4. Emva kokuba izinto kwikholamu zibalaselisiwe, musa ukungxama ukuvala "Fumana kwaye ubeke endaweni ye" Window. Ukuba sekhaya "ikhaya" esiye saqhubela phambili kuzo ngaphambili, yiya kwiteyipi kwibhloko yefonti. Cofa kwi-triangle ngasekunene kweqhosha "Landisa umbala". Kukho ukhetho lwemibala eyahlukeneyo yokugcwalisa. Khetha umbala esifuna ukufaka isicelo kwizinto zephepha elinexabiso elingaphantsi kwe-400,000 ruble.



5. Njengoko ubona, zonke iiseli zekholamu apho kukho i-ruble engaphantsi kwe-400,000 eqaqanjisiweyo, ibalaselisiwe kumbala okhethiweyo.



6. Ngoku kufuneka siyipeyinta izinto apho inani libekwe kuluhlu ukusuka kwi-400,000 ukuya kwi-500,000 000 ruble. Olu luhlu lubandakanya amanani ahambelana ne "4 ???" ithe template. Siyiqhuba kwicandelo lokukhangela kwaye ucofe kwi "Fumana zonke", emva kokukhetha ikholamu oyifunayo.



7. Ngokufanayo, ngexesha elidlulileyo ekufuneni okukhutshwayo, sibanika iziphumo zonke ezifunyenwe ngokucinezela i-CTRL + i-CTRLY i-componion. Emva koko, sifudukela kwi icon yokukhetha umbala. Cofa kuyo kwaye ucofe kwi icon yomthunzi oyifunayo, oya kupeyinta izinto zephepha, apho amaxabiso akwinqanaba ukusuka kwi-400,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 ukuya kwi-500,000 ukuya kwi-500,000 ukuya kwi-500,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 yama-500,000 ukuya kwi-500,000 ukuya kwi-500,000 ukuya kwi-500 000.



8. Njengoko ubona, emva kweli nyathelo, zonke izinto zetafile ngedatha kuluhlu ukusuka kwi-400,000 ukuya kwi-500,000 ibalaselisiwe kumbala okhethiweyo.



9. Ngoku kufuneka sibalaselise amaxabiso okugqibela angenzi-ngaphezulu kwe-500,000. Apha sinethamsanqa, kuba onke amanani angaphezu kwe-500,000 ukuya kwi-600,000. ???? Kwaye nqakraza iqhosha "Fumana yonke iqhosha". Ukuba kukho amaxabiso anqabileyo kwi-600,000, kuya kufuneka sifune ukufuna intetho "6 ????? njl.



10. Kwakhona, yabele iziphumo zokukhangela usebenzisa i-Ctrl + indibaniselwano. Emva koko, ukusebenzisa iqhosha le-teipe, khetha umbala omtsha ukugcwalisa i-thuba elingaphezulu kwe-500000 kumkhombandlela ofanayo njengoko siyenzile ngaphambili.



11. Njengoko ubona, emva kweli nyathelo, zonke izinto zekholam ziya kupeyinta, ngokwexabiso lamanani, elibekwe kuzo. Ngoku ungavala ibhokisi yokukhangela ngokucinezela iqhosha lokuvala elisezantsi kwikona ephezulu yefestile, kuba umsebenzi wethu unokujongwa ukuba usonjululwe.



12. Kodwa ukuba sithatha indawo kwenye, nto leyo edlula ngaphaya kwemida efakiweyo yombala othile, umbala awuyi kutshintsha, njengoko kwakunjalo ngendlela edlulileyo. Oku kucebisa ukuba olu khetho luza kusebenza ngokuthembekileyo kuphela kwezi thebhile apho idatha ingaguqukiyo.

Isifundo: Ungawenza njani ukukhangela kwimvi

Njengoko ubona, zimbini iindlela zokupeyinta iiseli ngokuhambelana neendlela zamanani ezikulo: Ngoncedo lokufomatha ngokwemiqathango kunye nokusebenzisa isixhobo "sokufumana kwaye sithathe indawo" isixhobo. Indlela yokuqala iqhubela phambili, njengoko ivumela ukuba uchaze ngokucacileyo iimeko apho izinto zephepha ziya kukhutshwa khona. Ukongeza, xa ukufomatha ngokuhambelana, umbala wezinto ukutshintsha, kwimeko yokutshintsha imixholo kuyo, engenakwenziwa. Nangona kunjalo, ukuzalisa iiseli, kuxhomekeka kwixabiso ngokusebenzisa i "Fumana kwaye kubeke endaweni ye" isixhobo, sikwasetyenziswa, kodwa kukwiitafile eziqingqiweyo kuphela.