I-Dos ne-Dont ye-Ukungenisa idatha kwi-Excel

01 ngo 08

Excel Data Entry Overview

Le tutorial ihlanganisa ezinye ze-DOs kunye ne-DON'Ts zokufaka idatha kwiiprogram ze-spreadsheet ezifana ne-Excel, i-Google Spreadsheets, kunye ne-Open Office Calc.

Ukufaka idatha ngokuchanekileyo ngethuba lokuqala kunokukhusela iingxaki kamva kwaye kwenze kube lula ukusebenzisa izixhobo ze-Excel kunye neempawu ezifana nefomula kunye neetshathi.

I-DOs kunye ne-DON'Ts zi:

1. Cwangcisa i-spreadsheet yakho
2. Musa ukushiya iMigca engacacileyo okanye iiColumns Xa ufaka Iinkcukacha ezihambelanayo
3. Gcina rhoqo kwaye ugcine kwiindawo ezimbini
4. Ungasebenzisi iiNombolo njengeziKhokelo zeKholamli kwaye Ungabandakanyi iiYunithi kunye neDatha
5. Sebenzisa iiReferensi zeeNdawo kunye neeRangesi ezibizwa ngeefomula
6. Musa ukushiya iiseli eziqulethe iifomu ezingenayo
7. Yenza Uhlobo Lwedatha

Cwangcisa i-Spreadsheet yakho

Xa kuziwa ekungeneni idatha kwi-Excel, kuluvo olungileyo ukwenza isicwangciso esithile ngaphambi kokuba uqale ukuthayipha.

Ukwazi ukuba yeyiphi iphepha lokusebenzela eliza kusetyenziselwa lona, ​​idatha iya kuqulethelwa, kwaye kuya kwenziwa ntoni na loo datha kunokuchaphazela kakhulu ukulungiswa kokugqibela kwiphepha lokusebenzela.

Ukucwangcisa ngaphambi kokuthayipha kungasindisa ixesha kamva ukuba i-spreadsheet idinga ukulungiswa kwakhona ukwenzela ukuba yenzeke ngakumbi kwaye ilula ukusebenza.

Iingqwalasela

• Iyintoni injongo yespredishithi?
• Ingakanani idilesi yespredishithi eyobamba?
• Ngaba amashadi afunekayo?
• Ngaba ispredishithi iya kuprintwa?

Iyini Injongo YeSpredishithi?

• Injongo yespredishithi iya kunceda ukucacisa indawo yedatha, njengoko ulwazi olubaluleke kakhulu lufuneka lubonakale kwaye lufikeleleke lula.
• Ziziphi izibalo ezifunekayo? Izibalo zichaphazela ukuba zeziphi iimfomula nemisebenzi ezifunekayo kwaye apho ziya kuba khona.

Ziza kuba ziphi iinkcukacha eziza kubanjwa ngeSpreadsheet?

Imali yedatha ispredishithi iya kubamba kwaye oko kuza kudibaniswa kamva kuya kuthintela inani lamaphepha asetyenziswayo.

• Musa ukusasaza idatha yakho kakhulu kunokuba inokwenza ulwazi olunzima lufumane nzima ukufumana kunye nokubala okushicilela amaxwebhu amaninzi okanye iincwadi zokusebenzela zingaqala ukuchaphazela ukusebenza kwe-Excel.
• Kwimihla yamaphepha amakhulu, ngamanye amaxesha luncedo ukubonisa izitotho ezibalulekileyo zekholomu ngaphaya kwezihloko zekholomu, kunokunyanzelisa abasebenzisi ukuba baqhubekele ngaphantsi kwiphepha lokusebenzela ukuze babone ulwazi.

Ngaba Kufuneka Amashadi?

Ukuba yonke into okanye inxalenye yedata iya kuboniswa kwitshathi okanye iitshathi, kunokuchaphazela ukubeka ulwazi,

• Ngokuxhomekeke kwindlela yetshathi, idatha ingadinga ukuba iqokelelwe ngokuhlukileyo-njengokusebenzisa indawo yesishwankathelo seesitifiketi zeepeyi.
• Kwiipredishithi ezinkulu, amashadi angatshintshela ukuba ahlukane namaphepha ukuze kucwecwe ukuqhuma

Ngaba i-Spreadsheet iya kuprintwa?

Indlela idibeneyo ehlelwe ngayo inokuchaphazeleka ukuba yonke into okanye enye yedatha iya kuprintwa, kuxhomekeke ekubeni ingaba i-portrait okanye i-landscape layout ikhethiwe kwaye inani lamaphepha afunekayo.

• Ukuba umboniso wesimboli kwiphepha eliqhelekileyo lephepha leencwadi (8 1/2 X 11) kufuneka lisetyenziswe, qwalasela ukubeka ininzi yedatha kwimigqa phantsi kweikholamu ezimbalwa, ukuze zonke izihloko zibonakala kwiphepha elilodwa.
• Ukuba kufuneka iimakhishithi ezininzi, cinga ukushicilela izihloko zekholomu phezulu kwiphepha ngalinye ukwenza ukufunda lula idatha lula.
• Ukuba kukho iikholomu zedata kufuneka ziprintwe, ukuhlelwa kweendawo kungagcina zonke izihloko kwiphepha elilodwa. Kwakhona, ukuba kufuneka iimakhishithi ezininzi, phrinta izihloko zekholomu phezulu kwiphepha ngalinye.
• Ukuba iikopi kufuneka ziprintwe, ukuzithumela kwelinye iphepha lingenza lula umsebenzi.

02 ngo 08

Musa ukushiya iRows okanye iColumns kwiDatha ehambelanayo

Ukushiya imiqolo engagqibekanga okanye iikholomu kumatafula eedata okanye kwiindawo ezidibeneyo zedatha kunokukwenza kube nzima kakhulu ukusebenzisa impawu ezininzi ze-Excel ezifana neetshathi, iithayibhile, kunye nemisebenzi ethile.

Kwananto ingenanto ilula kumgca okanye ikholomu equkethe idatha ingabangela iingxaki njengoko kuboniswa kumfanekiso ongentla.

Ukungabikho kwezikhala ezingenanto kuya kwenza kube lula kwi-Excel ukufumana nokukhetha yonke idatha edibeneyo kwimiba ukuba izinto ezifana nokuhlunga , ukuhlunga okanye i- AutoSum zisetyenzisiweyo.

Esikhundleni sokushiya imigqa okanye iikholomu ezingenanto, sebenzisa imida okanye ifomathi iibhloko kunye neelayibhile usebenzisa isibindi okanye ugxininisekile ukuze udibanise idatha kwaye wenze kube lula ukufunda.

Faka i-colum yakho yesilumko-silumko xa kunokwenzeka.

• Xa ubeka i-spreadsheet yakho, faka isihloko esichazayo phezulu kwikholam yokuqala yetafile kunye nedatha engezantsi.
• Ukuba kukho uchungechunge oludlulileyo lwedatha, uluhlu olunye emva kolunye kwiikholamu (ukushiya ukuya kwesokudla) kunye nesihloko kwinqaku nganye yedatha phezulu.

Gcina idatha engahambelaniyo eyahlukileyo

Nangona ukugcinwa kwedatha edibeneyo kubalulekile, ngexesha elifanayo, kunokuba luncedo ukugcina iindawo ezingafaniyo zedatha ezahlukileyo.

Ukushiya iikholomu ezingenanto okanye imigca phakathi kohlu lweedatha ezahlukeneyo okanye enye idatha kwiphepha lokusebenzela liya kuphinda lenze kube lula kwi-Excel ukujonga kakuhle kwaye ukhethe amacandelo anxulumene neetafile zedatha.

03 we-08

Gcina rhoqo

Ukubaluleka kokulondoloza umsebenzi wakho kaninzi akunakugqithiswa - okanye kuchazwe kaninzi.

Ewe, ukuba usebenzisa ispredishithi esekelwe kwiwebhu-njenge-Google Spreadsheets okanye i-Excel Online -ukugcina ukulondoloza akusiyo imbambano, kuba akukho nqubo inokhetho lokugcina kodwa, endaweni yoko, sebenze ngento yokugcina imoto.

Ngaphandle kweenkqubo zeekhompyutheni, emva kokutshintsha ezimbini okanye ezintathu-nokuba ingaba yongeza idatha, yenza iinguqu zokufometha, okanye ungene kwifomula - londoloza iphepha lokusebenzela.

Ukuba oko kubonakala kuninzi, gcina ubuncinane yonke imizuzu emibini okanye emithathu.

Nangona ukuzinza kweekhompyutheni kunye nekhompyutheni yekhompyutheni kuye kwaphucula kakhulu kwiminyaka embalwa edluleyo, isofthiwe isaphazamisa, ukuphelelwa amandla kwamandla okwenzekayo, kunye nabanye abantu ngezinye iinkqubo bahamba ngaphaya kwetambo lombane kwaye bakhuphe ngaphandle kwidonga lodonga.

Yaye xa kwenzeka, ukulahlekelwa yiphina idatha - enkulu okanye encinci - yandisa umthwalo wakho womsebenzi njengoko uzama ukuphinda uvuselele oko usenzile.

I-Excel ine- auto save feature, edla ngokusebenza kakuhle, kodwa akufanele ixhomekeke kuyo. Yiba nomkhwa wokugcina idatha yakho kunye neentsindiso rhoqo.

Umnqamlezo wokugcina

Ukulondoloza akufuneki kube ngumsebenzi onzima wokuhambisa imouse kwi-ribbon kwaye ucofa kwiimpawu, ungene kumkhwa wokugcina usebenzisa inhlanganisela yokuncinci yebhodi yebhodi ye:

Ctrl + S

Gcina kwiindawo ezimbini

Enye inkalo yokugcina engakwazi ukugqithiswa kukubaluleka kokugcina idatha yakho kwiindawo ezimbini ezahlukeneyo.

Indawo yesibini, ngokuqinisekileyo, i-backup, kwaye kuye kwathethwa kaninzi, "Izicwangciso zifana ne-inshorensi: ibe kunye kwaye mhlawumbi awuyi kuyidinga, ungenayo kwaye mhlawumbi uya kuba".

Ukugcinwa kwezona zinto zihamba phambili kwindawo ebonakalayo eyahlukileyo. Emva koko, yintoni inqaku lokuba neikopi ezimbini zefayili ukuba

• zikhona kwi-drive efanayo efanayo ehlulekayo?
• kwikhompyutheni enye, ebiwe?
• kwisakhiwo esifanayo esitshisa emhlabeni?

Backups Based Based

Kwakhona, ukwenza i-backup akufuneki ukuba ngumsebenzi onomdla okanye ochitha ixesha.

Ukuba ukhuseleko aluyiyo imbambano - iphepha lokusebenzela liluhlu lweeDVD yakho - thumela i-imeyile ikopi usebenzisa i-imeyile yewebhu ukuze ikopi ihlale kwiseva mhlawumbi iyalanele.

Ukuba ukhuseleko lukhupha, ukugcinwa kwewebhu kusekho ukhetho - nangona inkampani ekhethekileyo kwinto enjalo kwaye ihlawule intlawulo yokwenza njalo.

Kwimeko yeespredishithi ze-intanethi, mhlawumbi, abanini beprogram balondoloza iinkonzo zabo-kwaye oku kuquka yonke idatha yomsebenzisi. Kodwa ukuba ukhusele, khuphela ikopi yefayile kwikhompyutheni yakho.

04 we-08

Ungasebenzisi iiNombolo njengeziKhokelo zeKholamli kwaye Ungabandakanyi iiYunithi kunye neDatha

Sebenzisa izihloko eziphezulu kwiikholam kunye nasekuqaleni kwemigca ukuchonga idatha yakho, njengoko benza imisebenzi efana nokwenza lula kakhulu, kodwa ungasebenzisi amanani anjengo-2012, 2013, njalo-njalo-ukwenza njalo.

Njengoko kuboniswe kumfanekiso ongentla, iikhompyutheni kunye neengqungquthela zomgca ezinamanani nje zingabonakaliswa ngokungabonakali kwizibalo. Ukuba iifomula zakho ziqukethe imisebenzi efana nale:

• AutoSum ,
• AutoMax ,
• AutoAverage .

ngokuzenzekelayo ukhethe uluhlu lweenkcukacha zengxoxo yomsebenzi.

Ngokuqhelekileyo, loo misebenzi kuqala ibhekisele kwiikholamu zamanani apha ngasentla apho zikhona kwaye zize zikhohlo kumqolo wee nombolo, kwaye naziphi na izihloko ezihamba ngamanani ziya kufakwa kwibala elikhethiweyo.

Amanani asetyenziswe njengemixholo yomgca angaphoswa njengenye yechungechunge lwedatha xa ukhethwe njengenxalenye yoluhlu lweetati kunokubhaliweyo.

Fomata amanani kwiiseli ezihamba phambili njengetekisi okanye ukwenza iilebula zetekethi ngokuphambi kwendidi nganye kunye ne-apostrophe (') - efana no-2012 no-2013. I-apostrophe ayibonakali kwiseli, kodwa iyatshintsha inani ukuya kutshintshi idatha.

Gcina iiYunithi kwiiNtloko

Musa: faka imali, ubushushu, umgama okanye amanye amayunithi kwisisele ngasinye ngesamba seenkcukacha.

Ukuba wenza, kukho ithuba lokuba i-Excel okanye i-Google Spreadsheets izakujonga yonke idatha yakho njengombhalo.

Esikhundleni saloo ndawo, faka iiyunithi ezihlokweni phezulu kwikholam, leyo, njengoko kwenzekayo, iya kuqinisekisa ukuba ezo zihloko zincinci kwaye aziyi kudala ingxaki exoxwe ngasentla.

Umbhalo ukuya kwi-Left, Numeri ngakwesokudla

Indlela esheshayo yokuxelela ukuba unombhalo okanye inombolo yesazisi ukujonga ukulungelelaniswa kwedatha kwiseli. Ngokungagqibekanga, idatha yombhalo ihambelaniswe ngakwesobunxele kwi-Excel kunye ne-Google Spreadsheets kunye nedatha yeenombolo ihambelaniswe ngakwesokudla kwiseli.

Nangona ukulungelelaniswa okungagqibekanga kungatshintshwa ngokulula, ukufometha akusetyenziswanga ngokuqhelekileyo de emva kokuba yonke idatha kunye nefomula zifakiwe, ngoko ukulungelelaniswa okungagqibekanga kunokukunika inkqubela kwangaphambili ukuba kukho into ephazamisayo kwiphepha lokusebenzela.

Amaphesenti kunye neempawu zeMali

Isiqhelo esihle kakhulu sokungena yonke idatha kwiphepha lokusebenzela kufuneka ufake ifowuni ecacileyo uze ufomathile iseli ukuba ubonise inombolo ngokuchanekileyo-kwaye oku kubandakanya ipesenti kunye nemali yemali.

I-Excel kunye ne-Google Spreadsheets, nangona kunjalo, zamkela iimpawu zeepesenti ezifakwe kwiseli kunye nenani kwaye bobabini bayaqaphela izimpawu zemali eziqhelekileyo, ezifana nesimboli se dola (i-$) okanye uphawu lwesiliva saseBrithani (£) xa zifakwe iseli kunye nedatha yeenombolo, kodwa ezinye iimpawu zeemali, ezifana neRandi yaseMzantsi Afrika (R), ziya kuguqulelwa njengombhalo.

Ukuze ugweme iingxaki ezinokuthi, landela umgaqo okhankanywe ngasentla kwaye ungenise isixa uze usityelele iseli ngemali kunokuba uthayiphe uphawu lwemali.

05 ka 08

Sebenzisa iiReferensi zeeNdawo kunye neeRangesi ezibizwa ngeefomula

Izibini zeeferensi kunye neendawo ezikhethiweyo zingaba kwaye kufuneka zisetyenziswe kumafomula ukwenzela ukuba zikhawuleze kwaye zilula ukugcina iifomula kunye nokongezwa, iphepha elipheleleyo lomsebenzi, iiphoso ezikhululekile kwaye zifike ngoku.

• Iingqungquthela zeselula zidibene kunye nenombolo yomgca weseli - njenge-A1, B23, ne-W987-kwaye isetyenziselwa ukuchonga indawo yendawo kwiphepha lokusebenzela.
• Uluhlu olukhethiweyo okanye igama elichaziweyo lifana nereferensi yeseli kwindlela lisetyenziselwa ukuchonga iseli okanye uluhlu lweeseli kwiphepha lokusebenzela.

Ukuqwalasela idatha kwiifomula

Iifomula zisetyenziswe kwi-Excel ukwenza izibalo - ezifana nokudibanisa okanye ukususa.

Ukuba inani lamanani lifakwe kwiifomula - ezifana ne:

= 5 + 3

Njalo xa iinguqu zedatha-zithetha ku-7 no-6, ifomula idinga ukulungiswa kwaye amanani ayatshintshwa ukuze i-formula ifumaneke:

= 7 + 6

Ukuba, endaweni yoko, idatha efakwe kwiiseli kwiphepha lokusebenzela, iireferensi zeeseli - okanye amagama omqolo - zingasetyenziselwa kwifomula kuneenombolo.

Ukuba inani le-5 lingena kwiiselingi A 1 no-3 kwi-cell A2, ifom uba:

= A1 + A2

Ukuhlaziywa kwedata, utshintshe okuqukethwe kweeseli A1 kunye ne-A2, kodwa ifomu iyahlala efanayo - i-Excel ihlaziya ngokuzenzekelayo iziphumo zefomula.

Ukugcinwa kwexesha kunye nemizamo yonyuka ukuba iphepha lokusebenzela liqukethe iifomula eziyinkimbinkimbi kwaye ukuba iifomula ezininzi zibhekisela kwidatha efanayo kuba idatha idinga ukutshintshwa kwindawo enye kwaye zonke iifomula ezibhekiselele ziya kuhlaziywa.

Ukusebenzisa iireferensi zesetyenzisi okanye iindidi ezikhankanyiweyo kwenza ukuba iphepha lakho lokusebenzela likhuseleke, kuba kukuvumela ukukhusela amafomula ngokutshintshwa ngengozi xa ushiya iiseli zeedayitshintshi zifikeleleke.

Ukutyhila kwiDatha

Olunye uhlobo lwe-Excel kunye ne-Google Spreadsheets kukuba bakuvumela ukuba ufake iinkcukacha zeseli okanye amagama amanani kwiimfomula usebenzisa ukukhomba - oku kuquka ukuchofoza iseli ukungena kwinkokhelo kwifomu.

Ukuthabatha kunciphisa amathuba okuphambuka okubangelwa ukuthayipha kwiseferensi yesalathisi engafanelekanga okanye ukungaphumeleli igama legama.

Sebenzisa iiRanges ezibizwa ngokuba yiData

Ukunika indawo yeenkcukacha ezihambelanayo igama lingenza kube lula ukukhetha idatha xa uqhuba iintlobo okanye imisebenzi yokucoca.

Ukuba ubungakanani beendawo zedatha buguquka, uluhlu lwamagama luyakwazi ukulungiswa ngokulula usebenzisa uMlawuli wegama .

06 we-08

Musa ukushiya iiseli ezineenkomfa ezingakhuselekanga

Emva kokuchitha ixesha elininzi befumana iifomula zabo ezichanekileyo kunye nokusebenzisa iiferensi ezichanekileyo zeeseli, abaninzi abantu benza impazamo yokushiya loo mafomu athathwe ngokukhawuleza okanye ngokutshintshwa kwintliziyo.

Ngokufaka idatha kwiiseli kwiphepha lokusebenzela kwaye ke ukuchaza loo datha ngamafomula, kuvumela ukuba iiseli eziqulethe iifomula zivaliwe kwaye, ukuba kuyimfuneko, iphasiwedi ikhuselwe ukuyigcina ikhuselekile.

Ngethuba elifanayo, iiseli eziqulethe idatha zingashiywa zivulwe ukuze utshintsho lungeniswe lula ukuze kugcinwe i-spreadsheet.

Ukukhusela ishidi lokusebenzela okanye incwadi yokusebenzela yinkqubo ezimbini:

1. Qiniseka ukuba iiseli ezichanekileyo zivalelwe
2. Faka isicelo sephepha lokukhusela - kwaye ukuba ufuna, wongeza iphasiwedi

07 ka 08

Yenza Uhlobo Lwedatha

Yenza uhlobo lweedatha yakho emva kokuba uqedile ukungena.

Ukusebenza nemali encinci yedatha engafumanekanga kwi-Excel okanye i-Google Spreadsheets ayidla ngokuba yingxaki, kodwa njengokuba inani leedatha landa kwaye kunzima ukusebenzisana nayo ngokufanelekileyo.

Idatha ehlelwe kulula ukuyiqonda nokuhlalutya kwaye neminye imisebenzi kunye nezixhobo, ezifana neVLOOKUP kunye ne- SUBTOTAL zidinga idatha ehleliweyo ukuze ibuyise iziphumo ezichanekileyo.

Kwakhona, ukuhlenga idatha yakho ngeendlela ezahlukeneyo kunokukwenza kube lula ukubona izimo ezingaqhelekanga ekuqaleni.

Ukukhetha Idatha Okumele Yenziwe

Ngaphambi kokuba idatha ihlelwe, i-Excel kufuneka ikwazi ulwahlulo oluchanekileyo oluza kuhlonywa, kwaye ngokuqhelekileyo, i-Excel ilungile ekukhetheni iinkcukacha zedatha edibeneyo-ngokude nje xa ingenisiwe,

1. akukho miqolo okanye iikholomu ezingagqibekanga ezishiywe kwingingqi yeenkcukacha ezihambelanayo;
2. kunye nemigca kunye nekholam efihliweyo yashiywa phakathi kweendawo zedatha ehambelanayo.

I-Excel iya kuchonga, ngokuchanekileyo, ukuba indawo yedata inegama lomsebenzi kwaye ingabandakanyi lo mgca kwiirekhodi eziza kuhlanjululwa.

Nangona kunjalo, ukuvumela i-Excel ukukhetha uluhlu olulungiswayo luya kuba yingozi - ingakumbi ngexabiso elikhulu lenkcukacha ezinzima ukujonga.

Ukusebenzisa amagama ukukhetha idatha

Ukuqinisekisa ukuba idatha echanekileyo ikhethiweyo, qinisa uluhlu phambi kokuba uqale uhlobo.

Ukuba uluhlu olufanayo luza kuhlanjululwa ngokuphindaphindiweyo, indlela efanelekileyo kukunika iName.

Ukuba igama lichazwe kwibala lokuhlulwa, thayipha igama kwiBhokisi legama , okanye ukhethe kuloluhlu oludibeneyo kunye ne-Excel luza kugqitha ngokuzenzekelayo uluhlu oluchanekileyo lwedatha kwiphepha lokusebenzela.

Imizila efihliweyo kunye neeKholamu kunye nokuHlulwa

Imiqolo efihliweyo kunye neentsika zedatha azifudluli ngexesha lokuhlunga, ngoko kufuneka zidibaniswe ngaphambi kokuba uhlobo lube khona.

Umzekelo, ukuba umgca 7 ufihliweyo, kwaye inxalenye yoluhlu lweedatha oluhlanjululwayo, luya kuhlala lube ngumqolo 7 kunokuba luhanjiswe kwindawo echanekileyo ngenxa yolu hlobo.

Okufanayo kuya kwiikholam zedatha. Ukuhlelwa ngemigca kubandakanya ukulungelelanisa iikholomu zeenkcukacha, kodwa ukuba ikholomu B ifihliwe phambi kohlobo, iya kuhlala njengekholomu B kwaye ingabuyiselwa kunye namanye amakholomu eluhlu oluhlelwe.

08 ka 08

Zonke iiNombolo kufuneka zibe yiSitolo njengeNombolo

Ingxaki: Hlola ukuba onke amanani agcinwa njengamanani. Ukuba iziphumo akulona oko ukulindele, ikholomu ingaba neenombolo ezigcinwe njengombhalo kwaye kungekhona njengeenombolo. Ngokomzekelo, amanani angenayo angeniswe kwiinkqubo zengxelo ezithile okanye inombolo efakwe ngekhokela '(apostrophe) igcinwa njengombhalo.

Xa ukhawuleza uhlele idatha kunye ne-AZ okanye ZA iqhosha, izinto zihamba ngokungahambi kakuhle. Ukuba kukho umgca ongafihliyo okanye iikholomu ezingenanto ngaphakathi kwedatha, inxalenye yedatha ingahle ihlelwe, ngelixa enye idatha inganakwa. Khawucinge nje umonakalo oza kuba nawo, ukuba amagama kunye neenombolo zefowuni azihambelani, okanye ukuba i-oda iya kubathengi abangalunganga!

Indlela elula yokuqinisekisa ukuba uluhlu oluchanekileyo lwedatha lukhethwa ngaphambi kokukhetha ukunika igama.

Ukuthathwa kwesibini kuthintela ukuba yiyiphi i-Excel iintlobo. Ukuba uneselula esisodwa esikhethiweyo, i-Excel iphakamisa ukukhethwa ukuba ukhethe uluhlu (kufana nokucindezela i-Ctrl + Shift + 8) enxweme enye okanye ngaphezulu engamacatshulwa kunye nemigqa. Emva koko uhlola umgca wokuqala kwibanga elikhethiweyo ukuchonga ukuba iqulethe inkcazelo yekhanda okanye cha.

Yilapho ukuhlenga izixhobo zebar toolbar kungakhohlisa-i-header yakho (ekucingeni ukuba unayo) kufuneka ihlangabezane nezikhokelo ezimiselweyo ukwenzela ukuba i-Excel iyayiqonda njengesihloko. Ngokomzekelo, ukuba kukho nayiphi iiseli ezingenanto kumgca we-header, i-Excel ingacinga ukuba ayiyintloko. Ngokufanayo, ukuba umgca wekhanda ufomathiwe njengenye enye imigqa kwibala lolwazi, oko kungenako ukuyiqonda. Ngokunjalo, ukuba itheyibhile yakho iqukethe ngokupheleleyo umbhalo kunye nomgca wakho wekhanda ungenanto ngaphandle kombhalo, i-Excel iya kuba malunga nantoni na ixesha-ukuhluleka ukuqaphela umgca wenhloko. (Umqolo ubonakala nje ngomnye umgca wedatha kwi-Excel.)

Emva kokuba ukhethe uluhlu kwaye uqikelele ukuba kukho umgca we-header uya ku-Excel ukwenza okwenziweyo. Ukuvuyiswa kwakho kunye neziphumo kuxhomekeke ekubeni ingaba i-Excel inokukhethwa kokukhethwa kohlu kunye nomgca wokunquma kwinqanaba. Ngokomzekelo, ukuba i-Excel ayicingi ukuba unomgca wekhanda, kwaye ukwenza, ke intloko yakho ihlelwe emzimbeni wedatha; oku ngokuqhelekileyo into embi.

Ukuze uqiniseke ukuba uluhlu lwakho lweedatha luyabonwa ngokufanelekileyo, sebenzisa indlela ekufutshane yeCtrl + Shift + 8 ukubona ukuba yi-Excel ekhethayo; oku kuya kuhlulwa. Ukuba awuhambisani nokulindela kwakho, ngoko kufuneka uguqule umgca wolwazi kwitafile yakho, okanye kufuneka ukhethe uluhlu lweedatha ngaphambi kokusebenzisa ibhokisi yencoko yebhokisi.

Ukuze uqinisekise ukuba isihloko sakho sibonakala ngokuchanekileyo, sebenzisa indlela efutshane yeCtrl + Shift + 8 ukukhetha uluhlu lweenkcukacha, ngoko ukhangele kumqolo wokuqala. Ukuba intloko yakho ingenanto iphakathi kwalabo abakhethiweyo kumqolo wokuqala okanye ulayini wokuqala lufomathiwe nje ngomqolo wesibini, okanye unomqolo ongaphezu kweyodwa kwinqanaba elikhethiweyo, ngoko i-Excel ithatha ukuba awukho umgca wekhanda kuwo onke. Ukulungisa oku, yenza utshintsho kumqolo wakho wenqaku ukuze uqiniseke ukuba iyakuboniswa ngokufanelekileyo yi-Excel.

Ekugqibeleni, zonke iibhendi zingasuswa xa itheta yedatha yakho isebenzisa iinqununu eziphezulu zamqolo. I-Excel inexesha elinzima ukuyiqonda. Uqulunqa ingxaki xa ulindele ukuba ifake imigqa engagqibekanga kule ntloko; akukwazi nje ukwenza ngokuzenzekelayo. Kodwa unokhe ukhethe yonke imigqa ofuna ukuyihlela ngaphambi kokuba wenze uhlobo. Ngamanye amagama, cacisa kwizinto ofuna ukuba i-Excel ihlele; Musa ukuvumela ukuba i-Excel yenza iingcamango zakho.
Imihla nexesha eligcinwe njengombhalo

Ukuba iziphumo zokukhetha ngomhla zingaphenduki njengoko kulindelwe, idatha ekhompheni equkethe ukhiye wohlobo ingaba neentsuku okanye amaxesha agcinwe njengedatha yombhalo kunokuba kunamanani (imihla kunye namaxesha nje kuphela kwedatha yenombolo efomathiweyo).

Kulo mfanekiso ungentla, irekhodi lika-A. Peterson laphela ekupheleni kwoluhlu, xa, ngokusekelwe kumhla wokuboleka - ngoNovemba 5, 2014 -, irekhodi kufuneka ibekwe ngaphezu kwerekhodi ye-A. Wilson, unomhla wokuboleka kaNovemba 5.

Isizathu seziphumo ezingalindelekanga kukuba umhla wokuboleka u-A. Peterson ugcinwe njengombhalo, kunokuba ube nenani
Iinkcukacha ezixubileyo kunye neentlobo ezikhawulezayo.

Xa usebenzisa indlela yohlobo olukhawulezayo lweerekhodi eziqulethe iicatshulwa kunye nenombolo yocingo ixutywe kunye, i-Excel ihambisa inombolo kunye nedatha yecatshulwa ngokwahlukileyo - ukubeka iirekhodi ngedatha yombhalo phantsi kweluhlu oluhleliweyo.

I-Excel inokuquka kwakhona izihloko zekholomu kwiziphumo zolu hlobo - ukuzichazela njengenye enye umqolo wedatha yombhalo kunokuba nje ngamagama endle kwitheyibhile yedatha.
Hlela izilumkiso - Cwangcisa iBhokisi yokuThetha

Njengoko kuboniswe kumfanekiso ongentla, ukuba ibhokisi yebhokisi yencoko isetyenzisiweyo, nokuba kukho iintlobo kwikholomu enye, i-Excel ibonisa umyalezo osilumkisa ukuba ihlangabezane nedatha egcinwe njengombhalo kwaye ikunika ukhetho kwi:

Hlela nantoni na ekhangeleka njengenombolo njengenombolo
Hlunga amanani kunye namanani agcinwe njengombhalo ngokwahlukileyo

Ukuba ukhetha ukhetho lokuqala, i-Excel izama ukubeka idatha yombhalo kwindawo echanekileyo yeziphumo zohlobo.

Khetha ukhetho lwesibini kwaye i-Excel iya kufaka iirekhodi eziqulethwe ngedatha yecatshulwa ngaphantsi kweziphumo zoluhlobo - njengoko kwenzayo ngeendlela ezikhawulezayo.