Ungazifaka kanjani amakhasi e-Excel: Imiyalo enemininingwane

Ngokuzenzakalelayo, iMicrosoft Excel ayikhiqizi izinombolo ezibonakalayo zamashidi. Ngasikhathi sinye, ezimweni eziningi, ikakhulukazi uma idokhumenti ithunyelwa ukuphrinta, kufanele ibalwe. I-Excel ikuvumela ukuba wenze ngonyawo. Ake sicabangele izinketho ezahlukahlukene njengezinombolo kulolu hlelo lokusebenza.

Inombolo ku-Excel

Amakhasi enombolo ku-Excel angaba usebenzisa ama-footer. Zifihliwe ngokuzenzakalelayo, ezitholakala endaweni engezansi nephezulu yeshidi. Isici sabo ukuthi amarekhodi alotshwe kule ndawo adlula kuwo, okungukuthi, aboniswe kuwo wonke amakhasi edokhumenti.

Indlela 1: Izinombolo ezijwayelekile

Ukubala okujwayelekile kubandakanya ukubala wonke amashidi edokhumenti.

1. Okokuqala, udinga ukuvula ikhanda lonyawo. Iya kuthebhu ethi "Insert".



2. Ethepheni ku-Ithuluzi "Lombhalo" sichofoza inkinobho ethi "Footer".



3. Ngemuva kwalokho, ukushintshwa kwe-Excel kumodi yokumaka, futhi ama-footer aboniswa kumashidi. Zitholakala endaweni engenhla nangaphansi. Ngaphezu kwalokho, ngamunye wabo uhlukaniswe izingxenye ezintathu. Khetha, lapho unyaweni, kanye nalapho kungukuthi khona ingxenye, izinombolo zizokwenziwa. Ezimweni eziningi, ingxenye yesobunxele ye-tooter ephezulu iyakhethwa. Chofoza engxenyeni lapho uhlela ukubeka khona igumbi.



4. Kuthebhu yokwakha ye-block yethebhu eyengeziwe ye- "Work With Footer" ngokuchofoza inkinobho yenombolo yekhasi, ebekwe ethepheni eqenjini lamathuluzi weTogbin.



5. Njengoba ubona, ithegi ekhethekile "nekhasi] liyavela. Ukuze uguqulwe ibe inombolo ethile yokulandelana, chofoza kunoma iyiphi inkambu yedokhumenti.



6. Manje inombolo yokulandelana yavela ekhasini ngalinye lombhalo we-EXEL. Ukuze kubukeke kube lula ukwenzeka futhi kuvezwe ngemvelaphi ejwayelekile, kungahlelwa. Ukuze wenze lokhu, qokomisa ukuqopha ngonyawo bese uletha isikhombisi kuyo. Imenyu yokufometha ivela lapho ungenza khona izenzo ezilandelayo:
   • shintsha uhlobo lwefonti;
   • kwenze kube ngaphakathi noma ngesibindi;
   • Shintsha usayizi;
   • Shintsha umbala.

   

   Khetha izenzo ofuna ukuzishintsha ukubonisa kwenombolo kuze kube yilapho umphumela wanelise.

Indlela 2: Inombolo ekhombisa inani eliphelele lamashidi

Ngaphezu kwalokho, ungabe usubala amakhasi e-Excel, ekhombisa inombolo yawo ephelele ephepheni ngalinye.

1. Yenza kusebenze ukubonisa kwezinombolo, njengoba kukhonjisiwe ngendlela edlule.
2. Ngaphambi ithegi, ukubhala igama elithi "ikhasi", futhi ngemva kwaso sibhala igama elithi "ngaphandle".



3. Faka isikhombisi in the unyaweni ensimini ngemva kwegama elithi "out". Chofoza inkinobho "Inombolo yamakhasi", esemgwaqweni eteyipini ku "Ekhaya" ithebhu.



4. Chofoza kunoma iyiphi indawo idokhumenti ukuze esikhundleni amathegi, amagugu ukuvela.

Manje sinolwazi ayigcinanga ngokuchaza ukuthi inombolo ishidi lamanje, kodwa yayihlanganisa nokuthi inani eliphelele kubo.

Indlela 3: Njengoba babengaphezu asuka kukhasi lesibili

Kukhona amacala ukuthi yonke idokhumenti kuyadingeka ukuze olunezinombolo, kodwa kusukela endaweni ethile kuphela. Masithole ukuthi singakwenza kanjani.

Ukuze usethe i-izinombolo kusuka ekhasini lesibili, futhi lokhu kuyafaneleka, isibonelo, uma ubhala izifushaniso, mqondo kanye amaphepha isayensi, lapho ikhasi lesihloko akuvumeli khona izinombolo, kuzomele wenze izenzo ngezansi.

1. Iya unyaweni imodi. Ngokulandelayo, sitshelwa ngo ukudlulela "Footswear Umakhi" ithebhu, ise "Sebenza nge umbhalo wasezansi" ithebhu.



2. Esikhathini "Amapharamitha" yamathuluzi eteyipini, uphawu izilungiselelo nto "unyaweni Specific ekhasini lokuqala".



3. Sazibekela izinombolo usebenzisa inkinobho "Ikhasi Inombolo", njengoba kuboniswe ngenhla kakade, kodwa ukukwenza ikhasi, ngaphandle kuqala.

Njengoba sibona, ngemva kwalokho, wonke amashidi zibaliwe, ngaphandle kuqala. Ngaphezu kwalokho, ekhasini lokuqala is kubonelelwe inqubo ngezinombolo nezinye amashidi, kodwa, nokho, kube kungaveli kuso ngokwaso.

Indlela 4: Njengoba babengaphezu asuka kukhasi esibekiwe

Ngesikhathi esifanayo, kunezimo lapho kubalulekile ukuthi idokhumenti iqala hhayi kusukela ekhasini lokuqala, kodwa, isibonelo, ne wesithathu noma lesikhombisa. nesidingo esingaka akuvamile, kodwa, nokho, ngezinye izikhathi umbuzo uye nayo idinga isisombululo.

1. Thina ukuqhuba izinombolo ngendlela evamile, ngokusebenzisa inkinobho ohambelana eteyipini, zichazele kahle ngokuzokwenzeka enganikwa ngenhla.
2. Iya kuthebhu "MarkUP yekhasi".



3. Eteyipini elingezansi kwesokunxele "Ikhasi Izilungiselelo" ithuluzi block kukhona isithonjana ngesimo umcibisholo ezintweni ezingafanele. Chofoza kuyo.



4. Iwindi imingcele kuvula, ukuya "Page" ithebhu, uma kwaba ivulekile kwenye ithebhu. Sabeka emkhakheni we "Okokuqala Page" ipharamitha, inombolo, ukuhlukanisa ngezinombolo kusukela lapho kudingeka kwenziwe. Chofoza inkinobho ethi "KULUNGILE".

Njengoba ubona, ngemuva kwalokhu, inani lekhasi lokuqala kudokhumenti selishintshele kulowo ochaziwe kumapharamitha. Ngokuvumelana nalokho, inani lamashidi alandelayo liyashintshwa.

Isifundo: Ungasusa Kanjani Unyaweni Ku-Excel

Amakhasi enombolo ku-Excel Table Propector alula impela. Le nqubo yenziwa ngemodi yekhanda ku. Ngaphezu kwalokho, umsebenzisi angahlela ukubalwa kwezinombolo ngokwawo: fometha ukuboniswa kwenombolo, engeza inkomba yenani eliphelele lamashidi wedokhumenti, ukuze libe khona endaweni ethile, njll.