Ehlabathini le-spreadsheets, i-Excel ngokungathandabuzekiyo sisixhobo esikhokelayo sokwenza izibalo ezinzima kunye nohlalutyo lwedatha. Enye yezona zinto ziluncedo kakhulu ezinikezelwa yile nkqubo kukukwazi ukuqhobosha, okanye ukutshixa, iiseli ezithile okanye uluhlu lweeseli ukuthintela ukuguqulwa kwazo ngokungazi.
Kweli nqaku, siza kuphonononga ngokweenkcukacha indlela yokukhonkxa kwi-Excel, umsebenzi osisiseko wokugcina ukuthembeka kunye nokuchaneka kwedatha yethu. Ukusuka ekufundeni iindlela ezahlukeneyo zokupina ezikhoyo, ukuqonda iziphumo zeli nqaku kwiifomyula zethu kunye neemacros, siya kufumanisa indlela yokusebenzisa eli nqaku. ngokufanelekileyo kwaye iyasebenza.
Nokuba ungumsebenzisi we-Excel onamava okanye usaqala ukukhangela kwihlabathi le-spreadsheets, eli nqaku liza kukunika ulwazi oludingayo ukuze ukwazi ubugcisa bokupina kwi-Excel kwaye wandise imveliso yakho. emsebenzini ngedatha. Zilungiselele ukuvula amandla e-Excel kwaye uthathe izakhono zakho zespredishithi ukuya kwinqanaba elilandelayo!
1. Intshayelelo yokusebenzisa umsebenzi othi “Pin in Excel”
Umsebenzi we-"Pin" kwi-Excel sisixhobo esiluncedo sokukhenkceza imiqolo ethile okanye iikholamu kwi-spreadsheet. Oku kukuvumela ukuba ugcine ulwazi oluthile lubonakala ngelixa uskrola kulo lonke iphepha, ukwenza kube lula ukuzulazula kunye nokuhlalutya idatha ebanzi. Kweli nqaku, siza kufunda indlela yokusebenzisa umsebenzi "Pin". Inyathelo nenyathelo kunye nendlela yokwenza uninzi lweempawu zayo.
Ukusebenzisa umsebenzi we-"Pin" kwi-Excel, landela la manyathelo:
- Khetha iseli kwi-spreadsheet apho ufuna ukuseta iirowu okanye iikholamu.
- Yiya kwi "Jonga" isithuba ibar yesixhobo evela kwi-Excel.
- Cofa iqhosha elithi "Pin" kwiqela elithi "Pin Panels". Apha uya kufumana iinketho zokuqhobosha imiqolo, iikholamu, okanye zombini.
- Khetha ukhetho olufunekayo. Ukuba ufuna ukuqhobosha yomibini imiqolo kunye neekholamu, khetha "Iiphaneli zePin."
- Imiqolo ekhethiweyo okanye iikholamu ziya kulungiswa endaweni kwaye ziya kuhlala zibonakala njengoko uskrola kuyo yonke i-spreadsheet.
Kubalulekile ukuba uqaphele ukuba umsebenzi we-"Pin" kwi-Excel uluncedo ngakumbi xa usebenza ngeemali ezinkulu zedatha okanye xa ufuna ukuthelekisa ulwazi kwiindawo ezahlukeneyo zespredishithi. Ungayisebenzisa ukugcina izihloko zibonakala ngelixa uskrola kuluhlu olude, okanye ukuseta ikholamu yeetotali xa usenza izibalo kwamanye amacandelo ephepha. Khumbula ukuba ungasoloko ucima umsebenzi we-"Pin" ngokukhetha "Khubaza ukuphina indawo yolawulo" kwithebhu ethi "Jonga".
2. Uzisebenzisa njani iisimboli zokupinki kwi-Excel
Iimpawu zokulungisa kwi-Excel sisixhobo esiluncedo kakhulu sokwandisa iifomyula zethu kunye nokuphucula ukusebenza kakuhle komsebenzi wethu. Kweli nqaku siza kukubonisa indlela yokuzisebenzisa ngokuchanekileyo kwaye ufumane uninzi lwazo.
Okokuqala, kubalulekile ukuqonda ukuba zeziphi iimpawu zokulungisa. Kwi-Excel, xa sisenza ifomula ebhekisa kwiiseli, ezi mbekiselo zinokutshintsha ngokuzenzekelayo xa ukopa okanye urhuqa ifomula kwezinye iiseli. Nangona kunjalo, kwezinye iimeko sifuna ireferensi yeseli ukuze ihlale ingaguquki, nokuba ifomula ikotshwa okanye irhuqwa phi. Apha kulapho iisimboli zokupinki zingena khona.
Kukho iintlobo ezimbini zeempawu zokulungisa kwi-Excel: uphawu lwedola ($) kunye nokusetyenziswa kwezibiyeli zesikwere ([]). Ukusebenzisa uphawu lwedola, kufuneka sibeke nje phambi konobumba wekholamu kunye nenani lomqolo esifuna ukuseta. Umzekelo, ukuba sifuna ukuseta iseli A1 kwifomula yethu, singachwetheza i-$A$1. Ngakolunye uhlangothi, ukuba sifuna ukulungisa kuphela ikholomu okanye umqolo, kodwa kungekhona zombini, sinokusebenzisa uphawu lwedola kwinxalenye ehambelanayo. Umzekelo, ukuba sifuna ukuseta ikholamu A kodwa sivumele umqolo utshintshe, singachwetheza i-$A1.
3. Lungisa iiseli ngokupheleleyo kwi-Excel ukuze wenze izibalo ezichanekileyo
Kwi-Excel, ukuphina iiseli ngokupheleleyo bubuchule obubalulekileyo bokwenza izibalo ezichanekileyo kunye nokuphepha iimpazamo. Xa sisebenza ngeefomula okanye imisebenzi ebhekisa kwiiseli ezithile, kubalulekile ukulungisa ezo seli ukuze zingatshintshi indawo xa zikopa okanye zihambisa ifomula. Ngale ndlela, siqinisekisa ukuba izibalo zenziwa ngokuchanekileyo nangokungaguquguqukiyo.
Ukuseta iseli ngokupheleleyo kwi-Excel, usebenzisa uphawu lophawu lwedola ($) phambi konobumba wekholamu kunye nenombolo yomqolo. Umzekelo, ukuba sifuna ukulungisa iseli B2, sisebenzisa ireferensi $B $2. Uphawu lwedola phambi kokuba unobumba wekholomu usete indawo yekholomu, ngelixa uphawu lwedola ngaphambi kokuba inombolo yomqolo ibeke indawo yomqolo.
Kukho iindlela ezahlukeneyo zokulungisa iiseli kwi-Excel. Ukuba sifuna kuphela ukulungisa ikholamu, sinokusebenzisa ireferensi ye-$ B2. Kule meko, ikholamu iya kuhlala ilungisiwe, kodwa umqolo uya kuhlaziywa xa ukopisha okanye uhambisa ifomula. Ngokufanayo, ukuba sifuna ukucofa umqolo kwaye sivumele ikholamu ukuba ihlaziywe, sisebenzisa ireferensi ye-B $ 2. Oku kuguquguquka kusivumela ukuba silungelelanise iifomyula kwiimeko ezahlukeneyo kunye neemfuno ezithile.
4. Uyilungisa njani imiqolo kunye neekholamu kwi-Excel spreadsheet
Xa usebenza kwi-spreadsheet ye-Excel, kunokuba luncedo ukuqhobosha iirowu kunye neekholamu xa ufuna idatha ethile ihlale ibonakala ngelixa uskrola lonke iphepha. Oku kuluncedo ngakumbi xa unomthamo omkhulu wedatha kwiphepha elidlulela ngaphaya kwezinto ezibonakalayo kwisikrini. Apha ndiza kukubonisa indlela yokulungisa imiqolo kunye neekholamu kwi-Excel inyathelo ngenyathelo:
1. Seta imiqolo: Ukuqhobosha umqolo kwi-Excel, khetha kuqala umqolo ofuna ukucofa phantsi kwawo iirowu. Emva koko, yiya kwi-"Jonga" ithebhu kwibar yokukhangela kwaye ucofe u-"Pin Rows." Okulandelayo, khetha i "Pin Rows Phezulu" ukhetho ukuqhobosha imiqolo ngaphezu komqolo okhethiweyo.
2. Seta imiqolo: Ukuba ufuna ukuseta ikholamu kwi-Excel, khetha ikholamu ekunene kuluhlu ofuna ukuliqhobosha. Yiya kwi "Jonga" ithebhu kwaye ucofe "Seta imiqolo." Emva koko, khetha "Ikholamu eKhohlo eKhohlo" ukuqhobosha iikholamu ekhohlo kwikholamu ekhethiweyo.
Ukusebenzisa olu khetho, unokuseta yomibini imiqolo kunye neekholamu kwi-Excel ngokufanelekileyo. Ngale migca emiselweyo kunye neekholamu, unokuskrola ngokulula kwiphepha ngaphandle kokulahlekelwa ngumbono wedatha ebalulekileyo. Khumbula ukuba unokukhubaza kwakhona imiqolo ekhonkxiweyo kunye neempawu zekholamu nangaliphi na ixesha ngokulandela inkqubo efanayo ekhankanywe ngasentla.
5. Ukusebenzisa iifomula ezineembekiselo ezipheleleyo kwi-Excel
Kwi-Excel, iifomula ezineembekiselo ezipheleleyo ziluncedo kakhulu ekuqinisekiseni ukuchaneka kunye nokungaguquguquki ekubaleni kwe-spreadsheet. Ngokungafaniyo neembekiselo ezizalanayo, iimbekiselo ezipheleleyo azitshintshi xa ukopa okanye uhambisa ifomula kwezinye iiseli. Oku kuluncedo ngakumbi xa usebenza ngedatha efuna ukugcinwa ingatshintshi. Kukho iindlela ezininzi zokusebenzisa iifomula ezineembekiselo ezipheleleyo kwi-Excel, kwaye apha siza kukubonisa indlela yokwenza inyathelo ngenyathelo.
Ukusebenzisa ireferensi epheleleyo kwifomula ye-Excel, wongeza ngokulula isimboli "$" phambi kwazo zombini unobumba wekholamu kunye nenombolo yomqolo. Umzekelo, ukuba ufuna ukusebenzisa iseli A1 njengesalathiso esipheleleyo, ungachwetheza "$A$1" endaweni nje "A1." Ngale ndlela, xa ukopa okanye uhambisa ifomula kwezinye iiseli, ireferensi iya kuhlala ingatshintshi.
Enye indlela yokusebenzisa iifomula ezineembekiselo ezipheleleyo kukudibanisa iimbekiselo ezipheleleyo kunye neereferensi ezizalanayo kwifomula enye. Umzekelo, ukuba ufuna ukongeza amaxabiso kwikholamu A kumqolo ngamnye, kodwa gcina ireferensi kwiseli C1 rhoqo, ungasebenzisa ifomula "=A1+$C$1". Ngale ndlela, ireferensi yeseli C1 ihlala ingatshintshi, kodwa ireferensi yeseli A1 iya kulungelelaniswa ngokuzenzekelayo xa ukopa okanye uhambisa ifomula kwezinye iiseli.
6. Indlela yokuseta uluhlu lweeseli kwi-Excel ukuququzelela uhlalutyo lwedatha
Xa kusenziwa uhlalutyo lwe idatha kwi-excel, kuqhelekile ukuba kufuneka sisebenze ngoluhlu oluthile lweeseli. Ukuseta olo luhlu kunokwenza imisebenzi yethu ibe lula kwaye ikhawulezise inkqubo. Ngethamsanqa, i-Excel isinika iindlela ezininzi zokuseta uluhlu lweeseli ngokweemfuno zethu.
Olunye ukhetho kukusebenzisa imouse ukukhetha uluhlu olufunekayo. Ngokubamba iqhosha le-Ctrl, sinokukhetha iiseli ezizimeleyo ezingekho kufutshane. Ukongeza, sinokusebenzisa iqhosha le-Shift ukukhetha uluhlu kwicala elinye. Emva kokuba sikhethe uluhlu, sinokusebenzisa ukufomatha idatha ethile okanye ukhetho lokuhlalutya.
Enye indlela yokuseta uluhlu lweeseli kukusebenzisa iindlela ezimfutshane ze-keyboard. Ukuba sifuna ukukhetha uluhlu oludityanisiweyo lweeseli, sinokusebenzisa iShift + Utolo amaqhosha ukuhamba ngokukhawuleza kwicala elithile. Ukuba sifuna ukukhetha iiseli ezingadibaniyo, sinokubamba iqhosha le-Ctrl ngelixa sikhetha iseli nganye esiyifunayo. Emva kokuseta i uluhlu lweeseli, sinokusebenzisa iifomati okanye senze uhlalutyo sisebenzisa iinketho ezikhoyo kwi-Excel.
7. Iindlela eziphambili zokulungisa iiseli kwi-Excel kunye nokwandisa umsebenzi wakho
Omnye weyona mingeni ixhaphakileyo xa usebenza ne-Excel kukugcina iiseli ezithile zimile ngelixa ushukuma okanye ukopa. Ngethamsanqa, i-Excel ibonelela ngeendlela eziphambili zokusombulula le ngxaki kunye nokwandisa umsebenzi wakho. Nazi ezinye iindlela eziluncedo kunye neengcebiso zokucofa iiseli kwi-Excel.
1. Seta iiseli ezineembekiselo ezipheleleyo: Enye indlela yokuqinisekisa ukuba iiseli ezithile zihlala zingatshintshi kukusebenzisa iimbekiselo ezipheleleyo. Ukwenza oku, ulungiselela ngokulula uphawu lwedola ($) phambi konobumba kunye nenombolo yeseli ofuna ukuseta. Umzekelo, ukuba ufuna ukuseta iseli A1, ungachwetheza $A$1. Ngokusebenzisa le referensi ngokupheleleyo, ixabiso laloo seli aliyi kutshintsha xa ikotshwa okanye ihanjiswa.
2. Seta iiseli kwiifomula: Ukuba ufuna ukugcina iseli ilungisiwe kwifomula, unokudibanisa iireferensi ezipheleleyo kunye neereferensi ezizalanayo. Umzekelo, ukuba unefomula eyongeza amaxabiso kwiiseli A1, A2, kunye ne-A3, kwaye ufuna ukuseta iseli A1, ungachwetheza $A$1+A2+A3. Ngale ndlela, iseli A1 iya kuhlala ilungisiwe ngelixa iiseli A2 kunye ne-A3 ziya kuhlaziya ngokuchanekileyo.
3. Iinketho zokuphina iiseli ezikwinqanaba eliphezulu: Ukongeza kwiimbekiselo ezipheleleyo, i-Excel ibonelela ngolunye ukhetho oluphambili lweeseli zokupina. Ungasebenzisa "iMiqolo ePin" okanye "iKholamu yePin" ukuze uqinisekise ukuba umqolo othile okanye ikholamu ihlala ibonakala njengoko uskrola kwiphepha. Ungasebenzisa kwakhona ukhetho lwe "Pin Panels" ukwahlula iphepha libe ngamacandelo kwaye ucofe iindawo ezahlukeneyo ngaxeshanye. Olu khetho lufumaneka kwi-"Jonga" ithebhu yeribhoni kwaye iya kukuvumela ukuba wenze umsebenzi wakho nge-Excel.
8. Ungaziphepha njani iimpazamo xa ulungisa iiseli kwi-Excel
Xa usebenza ngeefomula kwi-Excel, kulula ukwenza iimpazamo xa ubhekisa kwiiseli. Ngethamsanqa, kukho ezinye iindlela onokuzisebenzisa ukunqanda ezi mpazamo kwaye uqinisekise ukuchaneka kwedatha yakho. Nanga amanye amacebiso aluncedo:
- Sebenzisa izingqinisiso ezipheleleyo: Endaweni yokusebenzisa iimbekiselo ezihambelanayo, ezitshintshayo xa ukhuphela ifomula kwezinye iiseli, sebenzisa iimbekiselo ezipheleleyo. Unokufezekisa oku ngokubeka uphawu lwedola ($) phambi kweeleta kunye namanani kwiseli (umzekelo, i-$ A $ 1). Ngale ndlela ifomula iyakuhlala ibhekisa kwiseli enye, nokuba ikotshwe phi.
- Sebenzisa iireferensi ezixubeneyo: Kwezinye iimeko, ungafuna ukuseta kuphela inxalenye yereferensi yeseli. Umzekelo, ukuba unefomula eshwankathela ikholamu ethile kwimiqolo emininzi, ungasebenzisa ireferensi exutyiweyo ukuseta ikholamu kodwa uvumele umqolo wahlukane. Oku kufezwa ngokubeka uphawu lwedola ($) phambi kweleta yekholomu (umzekelo, i-$ A2). Ngale ndlela ifomyula iya kulungelelanisa ngokuzenzekelayo njengoko ikotshelwa kweminye imiqolo.
- Sebenzisa iifomula ezicwangcisiweyo: Iifomyula ezicwangcisiweyo ziyindlela efanelekileyo yokuqinisekisa ukuchaneka xa usebenza kunye neeseti ezinkulu zedatha kwi-Excel. Ezi fomula zisebenzisa iimbekiselo zetheyibhile endaweni yeembekiselo zeseli nganye, nto leyo eyenza kube lula ukuyifunda nokuyigcina. Ukongeza, iifomula ezicwangcisiweyo zihlaziya ngokuzenzekelayo xa idatha yongezwa okanye isusiwe kwitafile.
Ngokusebenzisa obu buchule, unokunqanda iimpazamo eziqhelekileyo xa ucofa iiseli kwi-Excel kwaye uqinisekise ukuba iifomula zakho zisebenza ngokuchanekileyo. Ngalo lonke ixesha khumbula ukuphonononga kwaye uvavanye iifomula zakho ngaphambi kokuba uzisebenzise kwiiseti zedatha enkulu okanye ebalulekileyo. Kuhlala kucetyiswa ukwenza iikopi zedatha yedatha yakho phambi kokuba wenze utshintsho olubalulekileyo.
9. Uyisebenzisa njani i "Set Split Panel" kwi-Excel
Xa usebenzisa i-Excel, enye yezona ndlela ziluncedo ibonelela ngazo “Seta iPaneli yoKwahlula.” Esi sixhobo sikuvumela ukuba uqhoboshele inxalenye ethile yespredishithi, umqolo okanye ikholamu, ngelixa uskrola kuwo wonke umxholo. Oku kunokuba luncedo ngakumbi xa usebenza ngamaphepha amade, njengoko kwenza kube lula ukujonga kunye nokuhlalutya idatha. Ngezantsi ngamanyathelo okusebenzisa olu khetho ngempumelelo.
1. Ukuqalisa, vula ifayile ye-Excel apho ufuna ukusebenzisa khona “Seta iPhaneli yoKwahlula” ukhetho.
2. Okulandelayo, khetha umqolo okanye ikholamu ofuna ukuyiqhobosha. Ukwenza oku, nqakraza kwinombolo yomqolo okanye unobumba ohambelana nekholamu ukuyikhetha.
3. Nje ukuba umqolo okanye ikholamu ikhethiwe, yiya kwindawo ethi “Jonga” kwi-toolbar ye-Excel.
4. Kwicandelo elithi "Iphaneli yoHlolo", khetha ukhetho "Setha iPhaneli yoKwahlula".
Ukulandela la manyathelo kuya kuqhobosha umqolo okhethiweyo okanye ikholamu kwaye ihlale ibonakala njengoko uskrola kuyo yonke i-spreadsheet. Oku kuluncedo ngakumbi xa usebenza ngeetafile ezinkulu, njengoko kukuvumela ukuba uhlale unezihloko zekholamu okanye iiheader zerowu kwimboniselo, okwenza kube lula ukuzulazula nokuhlalutya idatha. Ngoku ukulungele ukusebenzisa "Lungisa iPaneli yoKwahlula" kwi-Excel ngempumelelo.
10. I-Pin kwi-Excel: Isixhobo esibalulekileyo sohlalutyo olukhulu lwedatha
I-Excel sisixhobo esibalulekileyo sohlalutyo olukhulu lwedatha ngenxa yokuguquguquka kwayo kunye nokusebenziseka ngokulula. Ngoluhlu olubanzi lwemisebenzi ephambili kunye neefomula, i-Excel ikuvumela ukuba wenze uhlalutyo olunzima kwaye usebenze inani elikhulu ledatha. indlela esebenzayo. Kweli nqaku, siza kukubonisa indlela yokulungisa kwi-Excel, inkqubo esisiseko yokucwangcisa kunye nokukhohlisa idatha.
Inyathelo lokuqala kukukhetha idatha ofuna ukuyilungisa. Ukwenza oku, kufuneka nje uqaqambise uluhlu lweeseli eziqulethe idatha efanelekileyo. Nje ukuba uluhlu lukhethiwe, yiya kwindawo ethi "Jonga" kwibar yemenyu kwaye ucofe "Iipaneli zePin." Okulandelayo, khetha inketho ethi "Pin Top Panels" ukuba ufuna ukuqhobosha kwimiqolo ephezulu, okanye ukhethe "Pina iiPaneli zasekhohlo" ukuba ufuna ukuqhobosha iikholamu zasekhohlo.
Nje ukuba uqhoboshele iiphaneli, uya kukwazi ukujikeleza i-spreadsheet ngaphandle kokulahlekelwa ngumbono wedatha esisigxina. Oku kuluncedo ngakumbi xa usebenza ngeeseti ezinkulu zedatha kwaye kufuneka ube nereferensi rhoqo njengoko ujonga kwiphepha. Ukongeza, unokutshintsha indawo yephaneli emiselweyo usebenzisa umsebenzi othi "Split" kwithebhu ethi "Jonga", ikuvumela ukuba uhlengahlengise umbono ngokweemfuno zakho ezithile.
11. Uzilungisa njani iiseli kwi-Excel xa usebenza ngeetafile zepivot
Xa sisebenza ngeetafile zepivot kwi-Excel, sihlala sidinga ukuqhobosha okanye ukutshixa iiseli ukuzithintela ukuba zingahambi xa uhlaziya idatha okanye usebenzisa izihluzi. Oku kuluncedo ngakumbi xa sifuna ukugcina amaxabiso athile okanye iifomula ezithile kwindawo engaguqukiyo kwitafile yethu. Ngethamsanqa, i-Excel isinika iindlela ezininzi zokulungisa iiseli kwiitafile zepivot.
Enye indlela yokuqhobosha iiseli kwi-Excel xa usebenza ngeetafile zepivot kukusebenzisa inketho ethi "Pin Cells" kwimenyu yeeseli. Ukwenza oku, sikhetha kuqala iseli okanye uluhlu lweeseli esifuna ukuyilungisa. Emva koko, sinqakraza-ekunene kwaye ukhethe inketho ethi "Pin Cells" kwimenyu eyehlayo. Oku kuya kutshixa iiseli ezikhethiweyo, oku kuthetha ukuba azinakususwa xa uhlaziya itafile.
Enye inketho kukusebenzisa umsebenzi othi "Tshixa iiPaneli" kwi "Jonga" ithebhu ye-Excel. Lo msebenzi uvumela ukuba sahlule iwindow ye-Excel kumacandelo kwaye sivale imiqolo ethile okanye iikholomu ukuze zihlale zibonakala. Ukuqhobosha iiseli usebenzisa olu khetho, siqala sikhethe iseli esezantsi nje okanye ekunene kwendawo apho sifuna ukuqhobosha. Emva koko, siya kwithebhu ethi "Jonga" kwaye nqakraza kwiqhosha elithi "Tshixa iiPaneli" kwiqela elithi "Windows". Oku kuya kutshixa umqolo ongasentla kunye nekholamu ekhohlo endaweni, kusivumela ukuba sikrole kuyo yonke itafile ngaphandle kokulahlekelwa ngumbono wezihloko ezibalulekileyo zomqolo kunye nekholamu okanye iilebhile.
12. Ukusebenzisa izalathisi ezizalanayo kunye nezipheleleyo kunye kwi-Excel
Ukusebenzisa isalamane kunye neembekiselo ezipheleleyo kunye kwi-Excel kunokuba luncedo kakhulu xa usebenza ngeefomula kwaye ufuna ukugcina amaxabiso athile ngokuthe rhoqo ngelixa usenza umsebenzi kuluhlu olubanzi lweeseli. Xa usebenzisa iireferensi ezizalanayo, iifomula ziya kusonga ngokuzenzekelayo kwiiseli ezikhankanyiweyo xa uzikhuphela kwezinye iindawo zespreadsheet. Nangona kunjalo, kwezinye iimeko, kuyimfuneko ukugcina iiseli ezithile zingaguquki kwaye zithintele ukuba zingasonge xa iifomula zikotshwa. Apha kulapho iimbekiselo ezipheleleyo zingena khona.
Ukusebenzisa izikhombisi ezihambelanayo kunye nezipheleleyo kunye kunye kwi-Excel, unokusebenzisa ukusetyenziswa kophawu lwedola ($) phambi komqolo kunye / okanye ikholomu kwireferensi yeseli. Umzekelo, ukuba ufuna ukugcina ikholamu A ingatshintshi xa ukhuphela ifomula phantsi, ungasebenzisa ireferensi epheleleyo $A. Ngokufanayo, ukuba ufuna ukugcina umqolo woku-1 ungatshintshi, ungasebenzisa ireferensi epheleleyo eyi-A$1. Ukongeza, unokudibanisa ngokupheleleyo iireferensi kuzo zombini imilinganiselo, ngale ndlela ireferensi yeseli ayizukutshintsha xa ukopa ifomula kulo naliphi na icala.
Umzekelo osebenzayo wendlela yokusebenzisa izikhombisi ezizalanayo kunye nezipheleleyo kunye kwi-Excel kubala ukuthengiswa okupheleleyo ngemveliso kwispredishithi esiqulethe uluhlu lweemveliso kunye namaxabiso ahambelanayo kunye nezixa ezithengisiweyo. Ukuba ufuna ukubala intengiso iyonke kwimveliso nganye ngokuphinda-phinda ixabiso ngokobungakanani obuthengisiweyo, ungasebenzisa ireferensi epheleleyo kuluhlu lwamaxabiso, ukuze lungalungiswa xa kukhutshelwa ifomula, kunye nesalathiso esizalanayo soluhlu lobungakanani obuthengisiweyo. , ukuze ilungelelanise ngokuzenzekelayo xa ifomula ikotshelwa kwezinye iiseli.
13. Indlela yokuseta iiseli zangaphandle kwifomula ye-Excel
Xa usebenza ngeefomyula kwi-Excel, kudla ngokuyimfuneko ukubhekisela kwiiseli ezingaphandle kwefomula yangoku. Oku kwaziwa njengokupina iiseli zangaphandle. Ukuqhobosha iseli yangaphandle kuvumela ireferensi yayo ukuba ingahlaziywa ngokuzenzekelayo xa ifomula ikotshwa okanye ihanjiswa. Ngezantsi ngamanyathelo okuseta iiseli zangaphandle kwifomula ye-Excel.
Ukuseta iseli yangaphandle kwifomula, songeza ngokulula uphawu lwedola ($) phambi kweleta yekholomu kunye nenombolo yomqolo yeseli. Umzekelo, ukuba iseli esifuna ukuseta yi-B2, kufuneka sibhale i-$B$2 endaweni ye-B2 nje. Oku kuya kuthintela ireferensi yeseli ekubeni ilungiswe xa ifomula ikotshwa okanye ihanjiswa.
Indlela esebenzayo yokuseta iiseli zangaphandle kwifomula kukusebenzisa iqhosha leF4. Emva kokukhetha iseli okanye uluhlu lweeseli ofuna ukufaka kuzo iphini, cofa iqhosha le F4 kwikhibhodi. Oku kuzakongeza ngokuzenzekelayo imiqondiso yedola ($) phambi kweleta yomhlathi kunye nenombolo yomqolo yeseli ekhethiweyo. Obu buchule bunokugcina ixesha kwaye buphephe iimpazamo xa usenza izibalo kwi-Excel.
14. Ukusombulula iingxaki eziqhelekileyo xa ucofa iiseli kwi-Excel
Ukuba usebenza ne-Excel, ngamanye amaxesha ukhe ube neengxaki xa uzama ukuqhobosha iiseli. Le miba inokususela kwiiseli ezingatshixwanga kakuhle ukuya kubunzima bokukopa okanye ukuncamathisela ulwazi kwi-spreadsheets ezikhuselweyo. Ngethamsanqa, kukho izisombululo kwezi ngxaki eziqhelekileyo eziya kukuvumela ukuba usebenze ngokufanelekileyo nangokutyibilikayo.
Esinye sezona zisombululo zisebenzayo zokusombulula iingxaki ngokuphina iiseli kwi-Excel kukusebenzisa iindlela zokukhusela amaphepha. Olu khetho lukuvumela ukuba utshixe iiseli ezithile okanye uluhlu lweeseli, ukuthintela ukuba zingalungiswa ngempazamo. Ukusebenzisa eli nqaku, khetha iiseli ofuna ukuzikhusela, cofa ekunene uze ukhethe “Fomatha iiseli.” Kwifestile ye-pop-up, yiya kwithebhu ethi "Ukhuseleko" kwaye ukhangele ibhokisi ethi "Ivaliwe". Okulandelayo, khusela ispredishithi ngokucofa u-“Hlaziya” kwaye ukhethe “Khusela iPhepha.” Ngoku, iiseli ezikhethiweyo ziya kutshixwa kwaye azinakuhlelwa ngaphandle kokungakhuseli iphepha.
Enye ingxaki eqhelekileyo ngokuphina iiseli kwi-Excel bubunzima bokukopa okanye ukuncamathisela ulwazi kwi-spreadsheets ezikhuselweyo. Ukulungisa oku, kufuneka ungakhuseli okwexeshana ispredishithi ofuna ukwenza kuso ukhuphelo okanye uncamathisele isenzo. Ukwenza oku, cofa u-"Hlola" kwaye ukhethe "Iphepha elingakhuselekanga." Emva koko, yenza ikopi okanye uncamathisele isenzo kwiiseli ezifunekayo. Wakuba ugqibile, khusela i-spreadsheet kwakhona ngokulandela la manyathelo akhankanywe ngasentla.
Ukuqukumbela, umsebenzi othi "Indlela Yokulungisa kwi-Excel" uboniswa njengesixhobo esibalulekileyo kwabo bafuna ukwandisa ukusebenza kakuhle kunye nokuchaneka kwabo xa besebenza ngeespredishithi. Ngokuqonda ngokufanelekileyo iindlela ezahlukeneyo zokuseta iiseli okanye uluhlu, abasebenzisi banokukhohlisa kwaye hlalutya idatha ngempumelelo ngakumbi, ukuphepha iimpazamo kunye nokonga ixesha. Nokuba usebenzisa iimbekiselo ezipheleleyo ezinophawu lwedola, iireferensi ezizalanayo, okanye imixube yazo zombini, i-Excel ibonelela ngeendlela ezininzi ezahlukeneyo zokulungisa iiseli ngokuxhomekeke kwiimfuno zomsebenzisi. Ukongeza, ukukwazi ukukhenkceza iipaneli zesikrini zibonelela ngokulula ngakumbi xa usebenza neeseti ezinkulu zedatha. Ngaphandle kwamathandabuzo, ukuqonda ezi ndlela zokulungisa kwi-Excel kunokuthatha ulawulo lwakho lwespredishithi ukuya kwinqanaba eliphezulu, ukubonelela ngeziphumo ezichanekileyo kunye nezobugcisa. Ngamafutshane, ukufunda ukukhonkotha kwi-Excel ayisobuchule obuyimfuneko kuphela kwindawo yokusebenza yanamhlanje, kodwa kunye nendlela yokuphucula ukuhamba komsebenzi kunye nokuphucula umgangatho wohlalutyo kunye neengxelo ezenziweyo.
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.