Indlela yokongeza iFooter kwi-Excel

I-footer kwi-Excel luphawu olubalulekileyo olukuvumela ukuba wongeze ulwazi olongezelelweyo emazantsi ephepha ngalinye loxwebhu. Qhubeka ufunde ukuze ufunde ukongeza ii-footers kwi-Excel kwaye ujonge iinketho eziphambili ukwenza ngokwezifiso kunye nokwandisa amaxwebhu akho. Kweli nqaku, siya kukukhokela kumanyathelo ayimfuneko kunye neempawu zokufezekisa le njongo, sikwenza ube yingcali yokulawula i-footer kwi-Excel. Ke ulungele ukuyiqonda kakuhle esi sixhobo sobugcisa kwaye uthathe iispreadsheets zakho ukuya kwinqanaba elilandelayo lobuchwephesha.

1. Yintoni i-footer kwi-Excel kwaye isetyenziselwa ntoni?

Umbhalo osemazantsi kwi-Excel licandelo elibekwe emazantsi espredishithi ngasinye. Isetyenziselwa ukubonisa ulwazi olongezelelweyo, olufana neenombolo zephepha, umhla, umbhali woxwebhu, okanye nayiphi na enye idatha efanelekileyo onqwenela ukuyifaka.

Ukongeza i-footer kwi-Excel, kufuneka silandele la manyathelo alandelayo:

1. Khetha ithebhu ethi "Faka" ngaphakathi ibar yesixhobo egqwesileyo.
2. Cofa iqhosha elithi “Header & Footer” kwiqela elithi “Text”.
3. Ibhokisi yencoko yababini iya kuvula apho unokwenza okusemazantsi. Apha ungakhetha phakathi kweenketho ezahlukeneyo ezingagqibekanga okanye ufake owakho okubhaliweyo.
4. Sebenzisa amaqhosha akhoyo kunye neenketho ukongeza izinto ezinje ngeenombolo zephepha, umhla, ixesha, okanye nayiphi na enye idata ofuna ukuyibonisa kumazantsi.
5. Wakuba ugqibile ukwenza i-footer ngokwezifiso, cofa u-"Kulungile" ukuze usebenzise utshintsho kwi-spreadsheet.

Khumbula ukuba okusemazantsi kubonisiwe kuwo onke amaphepha kwincwadi Excel, ngaphandle kokuba kuchazwe ngenye indlela. Ukongeza, ungenza ngokwezifiso ii-footers ezahlukeneyo kwiphepha lokuqala, ezingaqhelekanga kunye namaphepha, phakathi kwezinye iinketho. Qinisekisa ukugcina utshintsho olwenzayo ukuze lusetyenziswe ngokuchanekileyo kuxwebhu lwakho. Jonga zonke iinketho ezikhoyo kwaye wenze uninzi lwalo msebenzi kwi-Excel!

2. Amanyathelo okufikelela kukhetho olusezantsi kwi-Excel

Ukufikelela kukhetho olusezantsi kwi-Excel, kufuneka ulandele la manyathelo alandelayo:

1. Vula i Ifayile ye-Excel apho ufuna ukongeza umbhalo osezantsi.
2. Phezulu kwefestile ye-Excel, cofa ithebhu ethi "Faka".
3. Kwiqela elithi "Umbhalo", uya kufumana i "Header and Footer" ukhetho. Cofa iqhosha lokuhla ngezantsi kolu khetho kwaye ukhethe "Hlela okubhalwe ngasentla" okanye "Hlela uMazantsi."

Wakuba ugqibile la manyathelo, iwindow entsha iya kuvula ngesihloko esichazwe kwangaphambili okanye indawo esezantsi.

Kulo mmandla, unokongeza kwaye wenze ngokusesikweni ulwazi ofuna ukulubonisa ngezantsi. Ungabandakanya izinto ezinje ngeenombolo zephepha, umhla, igama lefayile, kunye nezinye iinkcukacha ngokuxhomekeke kwiimfuno zakho.

Sebenzisa izixhobo ezikwiheda kunye nebar yesixhobo yecandelo elisezantsi ukufomatha umxholo wakho. Ukufaka izinto ezithile, njengenombolo yephepha, cofa amaqhosha ahambelanayo kwibar yesixhobo. Nje ukuba ugqibile ukuhlela okusemazantsi, vala ngokulula iheda kunye nefestile yezantsi ukuze ubuyele kweyakho Ispredishithi se-Excel inkulu.

3. Uyenza njani i-footer kwi-Excel

Ukwenza i-footer kwi-Excel ngumsebenzi olula kodwa oluncedo kakhulu ukuphucula unikezelo lwe-spreadsheets zakho. Okulandelayo, siza kukubonisa amanyathelo ayimfuneko ukwenza ngokwezifiso i-footer kwi-Excel:

1. Vula ifayile ye-Excel apho ufuna ukwenza okusemazantsi. Yiya kwi "Faka" ithebhu kwibar yesixhobo kwaye ucofe ku "Header & Footer." Oku kuyakusa kumbhalo ongasentla kunye nomboniso ongezantsi, apho unokwenza naluphi na uhlengahlengiso oluyimfuneko.

2. Kanye kumbhalo ongasentla kunye nombhalo osezantsi, uya kuba nakho ukongeza okubhaliweyo, amanani ephepha, umhla, ixesha, kunye nezinye izinto kwifooter yakho. Ukongeza inombolo yephepha, umzekelo, nqakraza ngokulula iqhosha elithi "Inombolo yePhepha" kwaye ukhethe indawo efunekayo kwindawo esezantsi.

3. Ukongeza kwizinto ezingagqibekanga, unokongeza ulwazi lwesiko kwi-footer. Ukwenza oku, khetha iqhosha elithi "Umbhalo" kwaye uchwetheze isicatshulwa ofuna ukusibonisa ngezantsi. Unokubandakanya ulwazi olufana negama lefayile, umbhali, umhla wokudala, njl.

Khumbula ukuba unokusebenzisa ezi zilungelelaniso ezifanayo kwisihloko sespredishithi. Nje ukuba ugqibile ukwenza okubhalwe phantsi okanye okubhalwe ngasentla kwekhasi, nqakraza ngokulula iqhosha elithi "Vala i-Header kunye ne- Footer" ukuze ubuyele kumbono we-Excel oqhelekileyo. Kulula ngolo hlobo ukwenza okusemazantsi e-Excel kwaye uphucule inkangeleko ye-spreadsheets zakho!

4. Imiyalelo yokufaka amanani ephepha kwindawo engezantsi

Ukufakela amanani ephepha kumazantsi oxwebhu lwakho, landela la manyathelo:

1. Vula uxwebhu lwenkqubo yokusetyenzwa kwamagama oyisebenzisayo, njenge I-Microsoft Word o Amaxwebhu kaGoogle.

2. Yiya kwi "Faka" isithuba kwibar yesixhobo kwaye ukhethe "Ezantsi." Oku kuya kuvula icandelo ezantsi kwephepha ngalinye apho unokongeza umxholo kwi-footer.

3. Kanye kwindawo esezantsi, beka ikhesa apho ufuna ukuba inombolo yephepha ivele khona. Emva koko, yiya kwithebhu ethi "Faka" kwakhona kwaye ukhethe "Inombolo yekhasi." Oku kuya kufaka ngokuzenzekelayo inombolo yephepha kwindawo ethile.

5. Indlela yokubandakanya isicatshulwa kwi-footer kwi-Excel

Kukho iindlela ezininzi zokubandakanya okubhaliweyo kwi-footer kwi-Excel. Ngezantsi kukho iindlela ezintathu ezilula zokuphumeza oku:

1. Indlela yokwenza ngesandla:
-Vula ifayile ye-Excel apho ufuna ukubandakanya isicatshulwa kwindawo esezantsi.
Cofa kwindawo ethi "Faka" kwibar yesixhobo ephezulu.
– Khetha inketho ethi “Header and Footer” kwiqela elithi “Text”.
Kwicandelo elithi "Footer", cofa kwindawo yokusebenza ukuze ukhethe okusemazantsi.
– Bhala isicatshulwa ofuna ukusifaka ngezantsi.
– Cofa ngaphandle kwendawo yokusebenza ukuze ugqibezele ukuhlela okusemazantsi.

2. Indlela yekhowudi:
-Vula ifayile ye-Excel apho ufuna ukubandakanya isicatshulwa kwindawo esezantsi.
- Cofa kwi "Developer" ithebhu kwibar yesixhobo ephezulu. Ukuba awuyiboni le thebhu, yiya ku-"Fayile"> "Ukhetho"> "Yenza iRibhoni ngokwezifiso" kwaye ujonge ibhokisi ethi "Developer".
Kwithebhu ethi "uMphuhlisi", khetha i "Visual Basic" ukhetho lokuvula umhleli weVisual Basic.
– Kumhleli weVisual Basic, cofa kabini i-spreadsheet ofuna ukubandakanya kuyo okubhaliweyo kwi-footer.
Kwiphaneli yekhowudi, chwetheza le khowudi ilandelayo:
ActiveSheet.PageSetup.CenterFooter = "Texto en el pie de página"
Faka endaweni ethi "Umbhalo osemazantsi" ngombhalo ofuna ukuwufaka.
– Vala umhleli weVisual Basic kwaye okubhaliweyo kuya kuboniswa kumazantsi espreadsheet esikhethiweyo.

3. Indlela eneefomula:
-Vula ifayile ye-Excel apho ufuna ukubandakanya isicatshulwa kwindawo esezantsi.
-Khetha iseli ofuna ukuba umbhalo uvele kumazantsi.
– Bhala le fomula ilandelayo kwibha yefomula:
=&"Texto en el pie de página"&CHAR(10)&[Referencia a una celda]
Faka endaweni ethi "Isiqendu esisemazantsi" ngombhalo ofuna ukuwufaka kunye "[Ireferensi yeSeli]" kunye nembekiselo kwiseli equlethe okubhaliweyo ofuna ukukubonisa ngezantsi.
– Cofa iqhosha elithi Faka kwaye isicatshulwa siya kuboniswa kumazantsi espreadsheet.

Ngezi ndlela, unokubandakanya ngokulula okubhaliweyo kumazantsi ephepha lakho. iifayile zakho yeExcel. Khumbula ukuba olu phawu luluncedo ekongezeni ulwazi olongezelelekileyo, olunje ngeenombolo zamaphepha, izihloko, imihla, okanye ezinye iinkcukacha ezifanelekileyo. Linga kwaye wenze okusemazantsi akho ngokweemfuno zakho!

6. Ukusebenzisa izinto eziguquguqukayo kunye neenkalo kwi-footer kwi-Excel

Enye yezona zinto ziluncedo kakhulu ze-Excel kukukwazi ukusebenzisa izinto eziguquguqukayo kunye nemimandla esezantsi kwespredishithi. Oku kukuvumela ukuba wenze ngokwezifiso kwaye wenze ngokuzenzekelayo ulwazi oluboniswe kwi-footer, enokuba luncedo olukhulu xa usebenza ngenani elikhulu ledatha. Kule post, ndiza kuchaza indlela yokusebenzisa izinto eziguquguqukayo kunye namasimi asezantsi kwi-Excel, Inyathelo nenyathelo.

Inyathelo lokuqala lokusebenzisa izinto eziguquguqukayo kunye nemihlaba esemazantsi kukuqinisekisa ukuba unesihloko kunye nemboniselo esezantsi eyenziwe yasebenza. Ukwenza oku, kufuneka siye kwindawo ethi "Faka" kwi-toolbar ye-Excel kwaye ukhethe inketho ethi "Header and Footer". Nje ukuba i-header kunye ne-footer view ibonisiwe, sinokuqala ukongeza izinto eziguquguqukayo kunye nemimandla.

Ukongeza iguquguquko kwindawo esezantsi, kufuneka sikhethe icandelo elisezantsi apho sifuna ukuvela khona kwaye ucofe iqhosha elithi "Iiguquguquko ezisezantsi". Oku kuya kuvula uluhlu oluhlayo ngeendlela ezahlukeneyo esinokuzisebenzisa, njengenombolo yephepha, umhla wangoku, kunye negama lefayile. Xa ukhetha into eguquguqukayo, iya kufakwa kumbhalo osemazantsi kwaye ihlaziywe ngokuzenzekelayo ngalo lonke ixesha sigcina okanye sishicilela i-spreadsheet.

7. Ufakwa njani oonobumba abahlukeneyo kumaphepha ahlukeneyo e-Excel

Ukufaka iifooter ezahlukeneyo kumaphepha ahlukeneyo e-Excel, unokulandela la manyathelo alula:

1. Vula ifayile ye-Excel apho ufuna ukufaka khona ii-footer ezahlukeneyo kumaphepha ahlukeneyo.
2. Cofa ekunene kwithebhu yokuqala yephepha ezantsi ukusuka kwisikrini kwaye ukhethe "Tshintsha igama". Yabela igama elichazayo kweli phepha.
3. Phinda inyathelo langaphambili kuwo onke amaphepha apho ufuna ukufaka khona amagama asezantsi ahlukeneyo.

Nje ukuba unikeze igama kwiphepha ngalinye, ungaqhubeka nokusebenzisa imibhalo esemazantsi eyahlukeneyo ngokulandela la manyathelo ongezelelweyo:

1. Cofa kwithebhu ethi "Uyilo lwePhepha" phezulu kwesikrini.
2. Kwiqela lesixhobo “UkuSeta iPhepha”, cofa iqhosha elithi “Print Titles”.
3. Kwifestile ezivelelayo, khetha ithebhu ethi “Sheet” kwaye usebenzise amaqhosha athi “Khangela” ecaleni kothi “Phinda imiqolo phezulu” okanye “Phinda iikholamu kwicala lasekhohlo” ukukhetha iphepha elingqamene nombhalo osemazantsi. ndifuna ukufaka isicelo.

Ngokulandela la manyathelo alula, unokufaka ii-footers ezahlukeneyo kumaphepha e-Excel ahlukeneyo ngokukhawuleza nangokufanelekileyo. Khumbula ukuba olu khetho lukunika ukuguquguquka okukhulu ukwenza amaxwebhu akho alungelelanise iimfuno zakho ezithile. Linga ngamazantsi awohlukeneyo ukwenza amaphepha akho e-Excel abe ngobuchule ngakumbi kwaye alungelelaniswe!

8. Iingcebiso zokuphucula umboniso we-footer kwi-Excel

I-footer kwi-Excel yinto ebalulekileyo yokuphucula unikezelo lwe-spreadsheets zakho. Ikunika ukukwazi ukubandakanya iinkcukacha ezongezelelweyo okanye ezenzelwe wena emazantsi ephepha ngalinye elishicilelweyo. Nanga amanye amacebiso okuphucula umboniso kunye noqwalaselo lombhalo osemazantsi kwi-Excel:

• Khetha "Ukusetwa kwePhepha" ukhetho: Ukufikelela kwiinketho zoqwalaselo olusezantsi, kufuneka uye kwithebhu ethi "Ubeko lwePhepha" kwaye ucofe iqhosha elithi "UkuSeta iPhepha".
• Lungiselela umxholo osemazantsi: Kwicandelo elithi “Footer”, ungakhetha ukuba zeziphi izinto ofuna ukuzifaka, ezinjengomhla, ixesha, igama lefayile, okanye inombolo yephepha.
• Sebenzisa iikhowudi zefomathi: Ukwenza ngakumbi okusemazantsi, ungasebenzisa iikhowudi zokufomatha. Umzekelo, ungafaka ikhowudi &[amp;D] ukubonisa umhla wangoku okanye &[amp;F] ukubonisa igama lefayile.

Kwakhona, khumbula ukulungelelanisa ulungelelwaniso kunye nefonti yombhalo osemazantsi ukuze ulungele iprizenteyishini yakho. Ungazama ngeendlela ezahlukeneyo zokhetho de ufumane eyona ifanele iimfuno zakho. Zive ukhululekile ukujonga ii-tutorials kunye nemizekelo ekhoyo kuluntu lwe-Excel ukuze ufumane ezinye iimbono kunye neengcebiso malunga nendlela yokuphucula umboniso ongezantsi kwi-spreadsheets zakho.

9. Uyicima njani okanye uyilungise njani i-footer kwi-Excel

Ukucima okanye ukuguqula i-footer kwi-Excel kunokuba luncedo xa sifuna ukwenza ngokwezifiso amaxwebhu ethu okanye xa sifuna ukususa ulwazi olungeyomfuneko kwiifayile zethu. Ngethamsanqa, i-Excel ibonelela ngeendlela ezininzi zokufezekisa lo msebenzi ngokulula nangokukhawuleza.

Enye indlela yokususa okanye ukuguqula i-footer kwi-Excel kukusebenzisa i-"Layout yekhasi" ukhetho. Ukwenza oku, cofa kwindawo ethi "Ubeko lwePhepha" phezulu kwefestile ye-Excel. Okulandelayo, khetha i "Footer" ukhetho kwiqela "Useto lwePhepha". Kwifestile eya kuvula, ungacima okanye ulungise umxholo wefooter. Khumbula ukuba unokongeza izinto ezinje ngeenombolo zephepha, umhla, ixesha, igama lefayile, kunye nokunye. Linga kwaye wenze ngokwezifiso i-footer yakho kwiimfuno zakho!

Enye indlela yokucima okanye ukuguqula i-footer kwi-Excel ngokusebenzisa "I-Page Break Preview" ukhetho. Okokuqala, yiya kwithebhu ethi "Ifayile" phezulu kwefestile ye-Excel kwaye ukhethe ukhetho "Shicilela". Okulandelayo, kwimboniselo yoshicilelo, cofa i "Iphepha lokujonga Phambi kwePhepha" ukhetho. Oku kuya kukubonisa indlela amaphepha akho aya kubekwa ngayo xa ushicilela. Ukususa i-footer, cofa ekunene kuyo kwaye ukhethe ukhetho "Cima". Ukuba ukhetha ukulungisa umxholo, nqakraza nje kabini kwindawo esezantsi kwaye ungayihlela ngokuthe ngqo.

10. Ukusombulula iingxaki eziqhelekileyo xa usebenza ngeefooter kwi-Excel

Kwi-Excel, ukusebenza ngeenyawo kunokuba ngumngeni, kodwa ngamanyathelo afanelekileyo unokusombulula naziphi na iingxaki onokudibana nazo. Apha ngezantsi, ndiza kuchaza izisombululo ezithathu eziqhelekileyo kwiingxaki xa usebenza ngeenyawo kwi-Excel:

1. Cima umbhalo osemazantsi okhoyo: Ukuba ufuna ukususa ifooter kwiphepha Ukubala kwe-Excel, landela la manyathelo. Okokuqala, vula incwadi yomsebenzi ye-Excel kwaye ucofe ithebhu ethi "Faka" phezulu kwesikrini. Okulandelayo, cofa u-“Header & Footer” kwiqela lezixhobo zokubhaliweyo. Ithebhu entsha iya kuvula ngeheda kunye neenketho ezisezantsi. Cofa iqhosha elithi "Susa i-Header kunye ne- Footer" kwaye ukhethe "Susa i-Footter" kwimenyu eyehlayo. Ulungile! Okubhalwe ngasezantsi kuya kususwa kwi-spreadsheet.

2. Lungisa ulungelelwaniso lwamagama: Ukuba ufuna ukulungelelanisa ulungelelwaniso lokubhaliweyo okusemazantsi, nasi isisombululo. Okokuqala, khetha i-spreadsheet ofuna ukuguqula kuyo i-footer. Emva koko, cofa kwindawo ethi "Ubeko lwePhepha" phezulu kwesikrini. Kwiqela lesixhobo "Ukuseta iPhepha", cofa iqhosha elithi "Footers" kwaye ukhethe "Ubeko lwePhepha". Kwifestile ethi "Ubeko lwePhepha", yiya kwi "Header & Footer" ithebhu kwaye ucofe "iHeada yesiNtu" okanye "iMazantsi eSiko." Apha ungalungisa ulungelelwaniso lokubhaliweyo ngokweemfuno zakho. Ungalibali ukucofa "Kulungile" ukugcina utshintsho.

3. Yongeza izinto ezilungiselelweyo kumbhalo osemazantsi: Ukuba ufuna ukongeza imiba yesiko, enje ngeenombolo zephepha, umhla, okanye igama loxwebhu, kwifooter yakho, eli nyathelo ngenyathelo liya kukunceda. Vula incwadi yomsebenzi ye-Excel kwaye ukhethe i-spreadsheet apho ufuna ukongeza i-footer yesiko. Cofa ithebhu ethi "Ubeko lwePhepha" phezulu kwesikrini. Kwiqela lesixhobo "Ukusetwa kwePhepha", cofa iqhosha elithi "Footers" kwaye ukhethe ukhetho "lweLuko lwePhepha". Kwifestile ethi "Ubeko lwePhepha", yiya kwi "Header & Footer" ithebhu kwaye ucofe "iHeada yesiNtu" okanye "iMazantsi eSiko." Apha unokongeza izinto zesiko ngokukhetha iinketho ezihambelanayo. Nje ukuba ulwenzile uhlengahlengiso, cofa u-"Kulungile" ukusebenzisa i-footer yesiko kwi-spreadsheet sakho se-Excel.

Ndiyathemba ukuba ezi zisombululo ziyakunceda ukusombulula ezona ngxaki zixhaphakileyo xa usebenza ngeefooter kwi-Excel. Khumbula ukulandela la manyathelo ngononophelo kwaye ugcine utshintsho ukuqinisekisa ukuba isiphumo sifunwa. Nqwenelela impumelelo!

11.Ezinye iindlela zokusebenzisa i-footer kwi-Excel

Ziyeyona ndlela ibalaseleyo yokubonisa idatha ngendlela esebenzayo nelungelelanisiweyo. Nazi ezinye iindlela onokuthi uzisebenzise endaweni yeenyawo ezisezantsi:

1. Izihloko zekholamu: Endaweni yokubeka i-footer ngolwazi oluchazayo, ungasebenzisa iiheader zekholamu ukuchonga imixholo yoluhlu ngalunye lwedatha. Oku kuya kwenza kube lula ukufunda nokuqonda ulwazi.

2. Iitafile ezinamandla: Iitafile zePivot yeyona ndlela ibalaseleyo yokushwankathela kunye nokuhlalutya umthamo omkhulu wedatha. Ungasebenzisa esi sixhobo ukuqokelela idatha ngokweendidi ezahlukeneyo, ukuvelisa iigrafu kwaye wenze izibalo zesiko.

3. Ifomathi enemiqathango: Ufomato olunemiqathango luphawu lwe-Excel olukuvumela ukuba uqaqambise ngokuzenzekelayo iiseli ezihlangabezana neendlela ezithile. Ungasebenzisa lo msebenzi ukuqaqambisa amaxabiso aphezulu, amaxabiso aphantsi, abangaphandle, okanye nayiphi na enye indlela ofuna ukuyiqaqambisa kuyo. idatha yakho.

Khumbula ukuba ezi zezinye iindlela zokusebenzisa amagama asezantsi kwi-Excel. Jonga iinketho ezahlukeneyo ezinikezelwa sisixhobo kwaye ukhethe eyona ifanele iimfuno zakho.

12. Indlela yokuthumela ngaphandle kunye nokwabelana ngefayile ye-Excel ngelixa ugcina i-footer

Thumela ngaphandle kunye yabelana ngeefayile I-Excel ngumsebenzi oqhelekileyo emhlabeni ishishini kunye nezemfundo. Nangona kunjalo, iingxaki zihlala zivela xa uzama ukugcina i-footer xa usabelana ngefayile. Kweli nqaku, ndiza kukubonisa ngendlela elula nesebenzayo.

1. Sebenzisa umsebenzi we-Excel's "Save As" ukuthumela ngaphandle ifayile ngendlela efunwayo, nokuba kukwi Ifomathi yePDF okanye kwifomati yefayile ehambelana nesoftware ekujoliswe kuyo. Qinisekisa ukuba ukhetha u- "Gcina i-footer" kwimenyu eyehlayo ukuze ulwazi lugcinwe ngokuchanekileyo.

2. Ukuba ufuna ukwabelana ngefayile ye-Excel nge-imeyile, kuyacetyiswa ukuba uyicinezele kwifayile ye-ZIP ukuphepha iingxaki zokufomatha xa uncamathisela. Oku kuya kukuvumela ukuba ugcine i-footer injalo xa uyithumela kwabanye abamkeli ngaphandle kweengxaki.

13. Izixhobo eziluncedo kunye neendlela ezimfutshane zokukhawulezisa uHlelo lweeFowu kwi-Excel

Kukho izixhobo ezininzi eziluncedo kunye neendlela ezimfutshane ezinokukunceda ukukhawulezisa ukuhlela okusezantsi kwi-Excel. Nazi ezinye iindlela onokukhetha kuzo ukuze uphucule ukuhamba kwakho komsebenzi:

1. Iindlela ezimfutshane zekhibhodi: I-Excel inoluhlu lweendibaniso eziphambili ezikuvumela ukuba wenze iintshukumo ngokukhawuleza. Umzekelo, ungasebenzisa u-"Ctrl + Shift + E" ukuvula i-header kunye nebhokisi yebhokisi yencoko yababini. Ungacofa kwakhona u-“Ctrl + Shift + P” ukuze uvule umboniso ongezantsi kwaye ujonge ukuba iya kujongeka njani na phambi koshicilelo.

2. Ukwenziwa ngokwezifiso okubhalwe ngasezantsi: Unokwenza umxholo osezantsi ngokweemfuno zakho. Ukwenza oku, khetha ithebhu ethi "Faka" kwiribhoni kwaye ucofe "iHeader kunye neMazantsi." Ukusuka apho, unokongeza okanye ucime izinto, ezinje ngeenombolo zephepha, umhla, amaxesha, igama lefayile, phakathi kwabanye. Ungabandakanya ulwazi oluthile kumacandelo ahlukeneyo, njengephepha elisezantsi lephepha lokuqala, inombolo esezantsi yephepha elisezantsi, okanye inani elisezantsi lephepha elibhalwe amanani.

3. Ipeyinti yokuFomatha: Ukuba ufuna ukusebenzisa ukufomatha kwamagama asezantsi afanayo kumaphepha amaninzi okanye iincwadi zokusebenza, ungasebenzisa isici sePeyinta yokuFomatha. Okokuqala, khetha iphepha okanye incwadi yomsebenzi equlethe ukufomatha okufunayo kwaye ucofe ekunene kwileyibhile yephepha. Emva koko, khetha ukhetho "Khetha onke amaphepha" okanye "Khetha zonke iincwadi", ngokufanelekileyo. Okokugqibela, cofa ekunene kwakhona kwileyibhile yephepha apho ufuna ukusebenzisa ukufomatha kwaye ukhethe u-"Cola ukuFomatha." Ngale ndlela, unokonga ixesha ngokunqanda ukuqwalasela okubhalwe phantsi kwiphepha ngalinye ngokwahlukeneyo.

Ukusebenzisa ezi zixhobo kunye neendlela ezimfutshane unokukhawulezisa ukuhlela okusezantsi kwi-Excel kwaye ukwandise ukuhamba kwakho komsebenzi. Khumbula ukuba ukuziqhelanisa rhoqo kuya kukunceda ukuba uqhelane nobu buchule kwaye ube yingcaphephe kuhlelo olusezantsi kwi-Excel. Yiya phambili kwaye uzame kwaye ufumanise indlela yokuphucula ukusebenza kakuhle kwakho ekuphatheni lo msebenzi!

14. Imizekelo ebonakalayo yendlela yokubeka i-footer kwi-Excel kwiimeko ezahlukeneyo

Ukubandakanya i-footer kwi-spreadsheet ye-Excel kunokuba luncedo ekunikezeni ulwazi olongezelelweyo, njengomthombo wedatha okanye umbhali woxwebhu. Kwiimeko ezahlukeneyo, kunokufuneka sisebenzise ifooter ngokwahlukileyo. Ngoku bayabonisa eminye imizekelo Iingcebiso ezisebenzayo malunga nokubeka i-footer kwi-Excel kwiimeko ezahlukeneyo:

1. Yongeza inombolo yephepha kwindawo esezantsi:
-Kuqala, khetha ithebhu ethi "Faka" kwibar yemenyu.
- Cofa ku "Footer" kwaye ukhethe "Hlela amazantsi".
Kwicandelo elithi "Izixhobo ezisezantsi", khetha ukhetho "Inombolo yekhasi".
-Unokwenza ngokwezifiso ifomathi yenombolo yephepha ngokweemfuno zakho.
- Cofa "Vala iHeader kunye neFoter" ukugqiba.

2. Bandakanya umhla kunye nexesha langoku kwi-footer:
-Kwakhona, khetha ithebhu ethi "Faka" kwaye ucofe ku-"Footer".
-Khetha "Hlela iFotter" kwaye emva koko ukhethe "Umhla kunye nexesha".
-Kuluhlu oluhlayo, khetha ifomathi oyifunayo yomhla kunye nexesha.
-Ukuba ufuna umhla kunye nexesha lokuhlaziya ngokuzenzekelayo xa uvula ifayile, jonga ibhokisi ethi "Hlaziya ngokuzenzekelayo".
- Cofa "Vala iHeader kunye neFoter" ukugqiba.

3. Sebenzisa umxholo olungiselelweyo kumazantsi:
-Ukubandakanya ulwazi oluthile kumazantsi, khetha ithebhu ethi "Faka" kwaye ucofe u-"Footer."
-Khetha "Hlela iFotter" kwaye uchwetheze umbhalo ofunekayo okanye idatha kwindawo yokuhlela.
-Ungasebenzisa iinketho zokufomatha ezikhoyo kwibar yesixhobo ukwenza ngokwezifiso inkangeleko yesicatshulwa.
-Ukugqiba, cofa ku-"Vala i-header kunye ne-footer".

Le yeminye yemizekelo esebenzayo yendlela onokubeka ngayo i-footer kwi-Excel kwiimeko ezahlukeneyo. Khumbula ukuba i-Excel ibonelela ngoluhlu olubanzi lweenketho kunye nezixhobo zokwenza umxholo osezantsi, ukuze ulungelelaniswe neemfuno zakho ezithile. Zama ngeseto ezahlukeneyo kunye neefomathi ukuze ufumane ukhetho olufanelena neemfuno zakho. Ngala manyathelo alula, unokuphucula unikezelo kunye nokufundeka kweespredishithi zakho ze-Excel.

Isishwankathelo, ukongeza i-footer kwi-Excel ngumsebenzi olula kodwa obalulekileyo ovumela ngcono ukunikezelwa kwedatha kwincwadi yomsebenzi. Ingaba ufuna ukubandakanya ulwazi olongezelelweyo, olufana nenombolo yephepha, umhla, okanye naluphi na olunye ulwazi olufanelekileyo, i-footer inikeza isisombululo esisebenzayo sokulungelelanisa kunye nomxholo womxholo wakho kwi-spreadsheet.

Ukongeza i-footer kwi-Excel, kufuneka ulandele amanyathelo ambalwa alula. Okokuqala, khetha ithebhu ethi "Faka" kwibar yesixhobo kwaye emva koko ucofe kukhetho luka "Header and Footer". Okulandelayo, khetha indawo esemazantsi (phezulu, ezantsi, okanye zombini), khetha uyilo olufunekayo, kwaye uchwetheze okubhaliweyo okanye ufake izinto eziyimfuneko ezongezelelweyo.

Kubalulekile ukukhankanya ukuba i-Excel inikezela ngokhetho olongezelelweyo lokwenziwa ngokwezifiso kwi-footer, njengokulungelelaniswa kwesicatshulwa, ukufomatha ifonti, kunye nokufaka iindawo ezichazwe kwangaphambili, ezifana nomhla kunye nexesha elihlaziyiweyo. Olu khetho lunokulungelelaniswa nencwadi yakho yomsebenzi kunye neemfuno zokubonisa.

Ekugqibeleni, ukongeza i-footer kwi-Excel sisixhobo esinamandla nesiguquguqukayo esiphucula ukubonakala kunye nokulungelelaniswa kwe-spreadsheets zakho. Kungakhathaliseki ukuba iinjongo zobugcisa, izifundo okanye zomntu, i-footer inika isisombululo sobugcisa ukuhambisa ulwazi olongezelelweyo ngendlela ecacileyo kunye nefutshane. Landela la manyathelo akhankanywe ngasentla kwaye ufumanise ukuba i-footer inokuwuthatha njani umsebenzi wakho kwi-Excel ukuya kwinqanaba elilandelayo lokubonisa kunye nobungcali.