Indlela yokwenza iiseli ezilinganayo kwi-Excel

Rhoqo, xa usebenza neetafile ze-Excel, kuya kufuneka utshintshe ubungakanani beeseli. Kuyavela ukuba izinto zamaxabiso ahlukeneyo zikhona ephepheni. Ewe kunjalo, ayisoloko iqinisekisiwe ngeenjongo ezisebenzayo kwaye inobuhle kangako ukuba inganeliseli umsebenzisi. Ke ngoko, umbuzo uphakama njani ukwenza iiseli ngokufanayo ngokobukhulu. Masifumanise ukuba bangangqinelani njani kwi-Prese.

Ubungakanani bolungelelwaniso

Ukuze ulungelelanise ubungakanani beeseli ezikwiphepha, kufuneka uchithe iinkqubo ezimbini: Guqula ubungakanani beekholamu kunye nemiqolo.

Ububanzi bekholamu bunokwahluka ukusuka kwi-0 ukuya kwi-255 yeeyunithi (8.43 zisetwa ngokungagqibekanga), ukuphakama komtya ukusuka kwi-0 ukuya kwi-409 amanqaku (775). Inqaku elinye lokuphakama limalunga ne-0.035 yeesentimitha.

Ukuba ufuna ukulinganisa ukuphakama kunye neyunithi yobubanzi, unokutshintsha ezinye iindlela onokukhetha kuzo.

1. Ukuba kwi "Ifayile" yethebhu, cofa kwi "parameters".



2. Kwifestile ye-Excel Parameter evula, senza inguqu kwi "Advanced". Kwinxalenye esembindini yefestile sifumana ibhloko "yescreen". Sityhila uluhlu malunga "neeyunithi kumgca" womgca kwaye ukhethe enye yezinketho ezine ezinokwenzeka:
   • Iisentimitha;
   • I-intshi;
   • Iimilimitha;
   • Iiyunithi (zifakwe ngokungagqibekanga).

   Emva kokuba uzimisele ngexabiso, cofa kwiqhosha "Kulungile".

Ke, unokuseta umlinganiso apho umsebenzisi ejolise khona. Yiyunithi le nkqubo eya kulungiswa kamva xa ecacisa ukuphakama kwemiqolo kunye nobubanzi beekholamu zoxwebhu.

Indlela yoku-1: Ukulungelelaniswa kweeseli zoluhlu olunikezelweyo

Okokuqala, siya kuqonda indlela yokulungelelanisa iiseli zodidi oluthile, njenge tafile.

1. Sibonisa uluhlu kwiphepha esiceba ukwenza ubungakanani beeseli ezilinganayo.



2. Ukuba "kwikhaya", cofa kwi-ribbon kwi-icon "yefomathi", efakwe kwibhloko "yesixhobo seseli". Uluhlu lweesetingi luvula. Kwibhloko esesini, khetha eyona nto "ukuphakama komgca ...".



3. I-"ide "encinci" ivula. Singena kwicandelo elinye elikuyo, ubungakanani kwiiyunithi ezinqwenele ukufaka kuyo yonke imiqolo yoluhlu oluxhobileyo. Emva koko nqakraza kwiqhosha "Kulungile".



4. Njengoko sibona, ubungakanani beeseli zoluhlu olubelweyo ukuphakama kulingane. Ngoku kuya kufuneka siyicinge ububanzi. Ukwenza oku, ngaphandle kokususa ukhetho, phinda umnxeba imenyu ngeqhosha "format" kwiteyiphu. Ngeli xesha "kwibhloko yeseli" yobukhulu beseli, khetha igatya "ububanzi bekholamu ...".



5. Ifestile iqala ngokuchanekileyo njengoko yayikukuba ukuphakama komqolo kwabelwe. Sifaka ububanzi bekholamu kwiiyunithi kwicandelo, eziya kusetyenziswa kuluhlu olunikezelweyo. Cofa kwiqhosha "Kulungile".

Njengoko sibona, emva kokuba sigcwele, iiseli zommandla okhethiweyo zalingana ngokupheleleyo ngokobukhulu.

Kukho enye indlela yendlela. Unokukhetha kwiphaneli ethe tyaba ezo bezikhotho, ububanzi baso kufuneka senze okufanayo. Emva koko nqakraza kule paneli ngeqhosha lasekunene lemouse. Kwimenyu evula, khetha igatya "ububanzi bekholamu ...". Emva koko, iwindow ivula ukwazisa ububanzi bekholamu yoluhlu olunikezelweyo, ebesithetha kancinci ngaphezulu.

Ngokufanayo, sibalaselisa ulungelelwaniso kwiphaneli ethe nkqo yomqolo woluhlu esifuna ukuhambisa ulungelelwaniso. Ngeqhosha lasekunene lemouse kwiphaneli, kwimenyu evula, khetha indawo "ukuphakama komgca ...". Emva koko, iwindow ivuliwe apho kufuneka yenziwe khona.

Indlela 2: Ukulungelelaniswa kweeseli zephepha lonke

Kodwa kukho iimeko apho kufuneka ukuba kwinqanaba leeseli kungekuphela nje kuluhlu olufunwayo, kodwa lonke lonke iphela. Ibalwe ngesandla ukuba yabele - isifundo eside kakhulu, kodwa kusenokwenzeka ukuba inokwenzeka ukuba yabelwe nge-conks enye.

1. Cofa kwi-tricangle phakathi kweepaneli ezithe tye kunye nkqo. Njengoko ubona, emva koko, lonke iphepha elikhoyo labelwe ngokupheleleyo. Kukho enye indlela yokuqaqambisa iphepha lonke. Ukwenza oku, amanqaku e-CTRL + ikhibhodi kwikhibhodi.



2. Emva kokuba indawo yonke yeshiti yabalaseliswa, sitshintsha ububanzi beekholamu kunye nokuphakama kwemitya yobukhulu obunye kwi-algorithm enye eyachazwayo xa ufunda indlela yokuqala.

Indlela 3: Zoba imida

Ukongeza, ukulungelelanisa ubungakanani beeseli kunokutsala ngesandla imida.

1. Sibalaselisa iphepha lonke okanye uluhlu lweeseli kwiphaneli enamalungiselelo athe tyaba ngeendlela ezixutyushwe apha ngasentla. Faka isikhombisi kumda weekholamu kwiphaneli yokulungelelanisa ethe tyaba. Kwangelo xesha, endaweni yesikhombisi, umnqamlezo uya kuvela apho kukho iintolo ezimbini ezijolise kwiindlela ezahlukeneyo. Sula iqhosha le mouse lasekhohlo kwaye utsala imida ngasekunene okanye ngasekhohlo kuxhomekeke ekubeni kufuneka sandise okanye sinciphile. Kule meko, ububanzi abutshintshileyo kungekuphela nje kwiseli, kunye nemida oyisebenzisayo, kodwa zonke ezinye iiseli zoluhlu oluxhobileyo.

   

   Emva kokuba ugcwale kwaye uphose kwaye ukhuphe iqhosha le mouse, iiseli ezikhethiweyo ububanzi ziya kuba nemilinganiselo efanayo ehambelana ngokupheleleyo noko kwenziwa ngqokelela.



2. Ukuba awuyikhethi itikiti lonke, emva koko wabela izale iiseli kwiphaneli yokulungelelanisa ethe nkqo. Ukufana nomhlathi odlulileyo, tsala imida yenye yemiqolo eneqhosha lemouse enamabala kude kufike iiseli kumgca wokuphakama. Emva koko khupha iqhosha lemouse.

   

   Emva kwezi zenzo, zonke izinto zoluhlu olukhethiweyo ziya kuba nazo ukuphakama okufanayo njengesisele esingentla oye waphumelela.

Indlela 4: Faka itafile

Ukuba ufaka itafile ekhutshiweyo kwiphepha ngendlela eqhelekileyo, ke ihlala ikwiikholamu kwindawo efakiweyo iya kuba nobungakanani obahlukileyo. Kodwa kukho imvume eyamkelayo.

1. Khetha itafile ofuna ukukopa. Cofa kwi-Icon "Khuphela" i-icon, ekhoyo kwitheyiphu kwithebhu yasekhaya kwi-Buffer "ibhlokhi" ibhloko. Unganakho nakwela manyathelo emva kokhetho ukucofa indibaniselwano ye-CTRL + C Indiba ephambili kwikhibhodi.



2. Sibonisa iseli kwiphepha elinye, kwelinye iphepha okanye kwenye incwadi. Esi siseli kuya kufuneka ibe yinto ephezulu yetafile efakiweyo. Cofa ekunene kwinto enikezelweyo. Imenyu yemeko iyavela. Kuyo, yiya kwi "Insert ekhethekileyo ..." Into. Kwimenyu eyongezelelweyo, eya kuvela emva kwale, cofa, kwakhona, kwinto enegama elifanayo.



3. Ifestile ekhethekileyo ivuliwe. Kwi "Faka" useto lwe-plast, sihlengahlengisa ukutshintshela kwi "Ikholamu" yobubanzi bekholamu. Cofa kwiqhosha "Kulungile".



4. Emva koko, kwiPlanethi yephepha kuya kubakho iseli ngobukhulu obufanayo nabo babekwitafile yomthombo.

Njengoko ubona, e-Excel kukho iindlela ezininzi zokuseka ubungakanani beseli, zombini uluhlu okanye itafile kunye nephepha liphela. Eyona nto ibaluleke kakhulu xa usenza le nkqubo yabela uluhlu, imilinganiselo ofuna ukuyitshintsha kwaye ikhokelele kwixabiso elinye. Igalelo leeparamitha zokuphakama kunye nobubanzi beeseli zinokwahlulwa zibe ziindidi ezimbini: ukuseta ixabiso elithile kwiiyunithi ezivezwe ngamanani kunye nokumba ngesandla kwimida. Umsebenzisi ngokwakhe ukhetha indlela efanelekileyo yokusebenza, kwi-algorithm yeyona nto ibalaseleyo.