Ngokuzenzakalelayo, i-Microsoft Excel ayikhiqiza ukubonakala kweshidi elibonakalayo. Ngesikhathi esifanayo, ezimweni eziningi, ikakhulukazi uma idokhumenti ithunyelwa ukuphrinta, idinga ukubalwa. I-Excel ikuvumela ukuba wenze lokhu usebenzisa izihloko nezinyawo. Ake sibheke izinketho ezihlukahlukene zokuthi ungabhala kanjani amashidi kulolu hlelo lokusebenza.
Ukubalwa kwe-Excel
Ungakwazi ukuguqula amakhasi ku-Excel usebenzisa izihloko nezinyawo. Zifihliwe ngokuzenzakalelayo, ezisezindaweni eziphansi nezingenhla zeshidi. Isici sabo ukuthi amarekhodi angeniswe kule ndawo avulekile, okungukuthi, aboniswa kuwo wonke amakhasi alo mbhalo.
Indlela 1: Ukubala Okuvamile
Ukubalwa kwenombolo njalo kuhilela amaphepha onke womqulu.
- Okokuqala, udinga ukunika amandla ukuboniswa kwezihloko nezinyawo. Iya kuthebhu "Faka".
- On the tape ebhodini amathuluzi "Umbhalo" cindezela inkinobho "Izilinganiso".
- Emva kwalokho, i-Excel iya kwimodi yokumaketha, futhi izinyawo zivela kumashidi. Zitholakala ezindaweni ezingenhla nezingezansi. Ngaphezu kwalokho, ngamunye wabo uhlukaniswe izingxenye ezintathu. Sikhetha ukuthi yiziphi izinyawo, kanye nokuthi iyiphi ingxenye yalo, ukubalwa kwenombolo kuzokwenziwa. Ezimweni eziningi, uhlangothi lwesobunxele lwekhanda lukhethiwe. Chofoza ingxenye lapho uhlela khona ukubeka inombolo.
- Kuthebhu "Umakhi" amathebhu angeziwe "Ukusebenza ngezinyawo" chofoza inkinobho "Inombolo yekhasi"okuthunyelwe kwi-tape eqenjini lamathuluzi "Izinyathelo Zezinyawo".
- Njengoba ungabona, ithegi ekhethekile ivela. "& [Ikhasi]". Ukuze uguqule ibe inombolo elandelanayo, chofoza kunoma iyiphi indawo yedokhumenti.
- Manje ekhasini ngalinye lalo dokhumenti i-Excel livele inombolo yenombolo. Ukuze wenze kubonakale iyaphakamisa futhi iphume ngokumelene nesizinda jikelele, ingafomathwa. Ukuze wenze lokhu, khetha ukungena esinqeni bese uhambisa isikhombisi kuso. Imenyu yokufometha ibonakala lapho ungenza khona okulandelayo:
- shintsha uhlobo lwefonti;
- yenza italic noma isibindi;
- shintsha;
- shintsha umbala.
Khetha izenzo ofuna ukuzenza ukuze ushintshe ukuboniswa kokubukwa kwenombolo uze ufinyelele umphumela owanelisa.
Indlela yesi-2: ukubala nenani lamashidi
Ngaphezu kwalokho, ungabhalela amakhasi e-Excel nenombolo yawo yonke eshadini ngalinye.
- Senza kusebenze isibonakaliso sokubala, njengoba kuboniswe endleleni yangaphambilini.
- Ngaphambi komaki sibhala igama "Ikhasi", futhi emva kwakhe sibhala leli gama "".
- Setha isikhombisi ensimini yezinyawo emva kwegama "". Chofoza inkinobho "Inani lamakhasi"okuyinto efakwe kwi riboni kuthebhu "Ikhaya".
- Chofoza kunoma iyiphi indawo kudokhumenti ukuze esikhundleni samanani wamathegi aboniswe.
Manje sinolwazi hhayi kuphela ngenombolo yeshidi samanje, kodwa futhi nangenombolo yabo yonke.
Indlela yesithathu: Ukubalwa ukusuka kukhasi lesibili
Kukhona amacala akudingekile ukubala yonke idokhumenti, kodwa iqala kuphela endaweni ethile. Ake sibone ukuthi singakwenza kanjani.
Ukuze ubeke izinombolo ezivela kukhasi lesibili, futhi lokhu kufanelekile, isibonelo, uma ubhala izinhlobonhlobo, izinkomba kanye nemisebenzi yesayensi, lapho ukutholakala kwezinombolo kungavunyelwe ekhasini lekhasi, kufanele wenze izenzo ezibalwe ngezansi.
- Iya kwimodi yezinyawo. Okulandelayo, hamba kuthebhu "Umklami ongezansi"itholakala kubhulogi yamathebhu "Ukusebenza ngezinyawo".
- Ebhokisini lamathuluzi "Izinketho" Ebhebheni, hlola into yokuhlela "I-footer ekhethekile yekhasi lokuqala".
- Misa inombolo ngokusebenzisa inkinobho "Inombolo yekhasi", njengoba kakade kuboniswe ngenhla, kodwa kwenzeke kunoma iliphi ikhasi ngaphandle kokuqala.
Njengoba ubona, ngemuva kwalokhu wonke amashidi abalwa, ngaphandle kokuqala. Ngaphezu kwalokho, ikhasi lokuqala liyakhunjelwa kwinqubo yokubala amanye amashidi, kodwa, noma kunjalo, inombolo ngokwayo ayiboniswa kuso.
Indlela 4: ukubalwa kusuka kukhasi elichaziwe
Ngesikhathi esifanayo, kunezimo lapho kudingeka ukuthi idokhumenti iqale ukusuka ekhasini lokuqala, kodwa, isibonelo, kusukela kwesithathu noma yesikhombisa. Lesi sidingo asivamile, kodwa, noma kunjalo, ngezinye izikhathi umbuzo obhekene nawo udinga isixazululo.
- Sifeza inombolo ngokujwayelekile, ngokusebenzisa inkinobho ehambelana ne-tape, incazelo eningiliziwe eyanikezwa ngenhla.
- Iya kuthebhu "Ukuhlelwa Kwekhasi".
- Ebhebheni ekhoneni elingezansi elingakwesokunxele lebhokisi lamathuluzi "Izilungiselelo zekhasi" Kukhona isithonjana ngesimo somcibisholo oblique. Chofoza kuso.
- Iwindi yemingcele ivula, iya kuthebhu "Ikhasi"uma kuvulwe kwenye ithebhu. Sifaka insimu yepharamitha "Inombolo yekhasi lokuqala" inombolo ezobalwa. Chofoza inkinobho "Kulungile".
Njengoba ungabona, emva kwalokho inombolo yekhasi lokuqala langempela kudokhumenti lishintshe kulolo olucacisiwe kwimingcele. Ngakho-ke, ukubalwa kwezinhlamvu ezalandela nakho kwashintsha.
Isifundo: Ungasusa kanjani izihloko nezinyawo eziku-Excel
Amakhasi wokubala ku-spreadsheet ye-Excel alula. Le nqubo yenziwa ngezihloko nezinyawo ezinikezwe amandla. Ngaphezu kwalokho, umsebenzisi angakwazi ukwenza ngokwezifiso ukubala: ukufometha ukubonisa kwenombolo, engeza inkomba yezinombolo zamashidi wedokhumenti, inombolo evela endaweni ethile, njll.
