Engeza i-Preset noma Izihloko zezintandokazi nezilinganiso kuma-Excel Worksheets
Ku-Excel, izinhloko nezinyawo ziyizinhlamvu zombhalo eziphrinta phezulu (ikhanda) nangaphansi (unyaweni) wekhasi ngalinye ekhasini lokusebenzela .
Iqukethe umbhalo ochazayo njengezihloko, izinsuku, kanye / noma izinombolo zekhasi. Njengoba kungabonakali ekubukeni kweshidi lokusebenza, izihloko nezinyawo zivame ukungezwa kushidi lokushicilela elishicilelwe.
Lolu hlelo luza lunezinhlobonhlobo zezihloko ezihleliwe - njengezinombolo zekhasi noma igama lezincwadi - ezilula ukwengeza noma ungakha izihloko ezingokwezifiso nezinyawo ezingabandakanya umbhalo, ihluzo, noma enye idatha yespredishithi.
Nakuba ama-watermark angempela awakwazi ukudalulwa ku-Excel, "ama-watermark" angangeniswa ephepheni lokusebenzela ngokufaka izithombe usebenzisa izinhloko zangasese noma izinyawo.
Izihloko kanye nezindawo ezihamba ngezinyawo
- I-header noma unyawo lingaqukatha izingcezu ezintathu zolwazi. Lolu lwazi lungabonakala ezindaweni ezintathu ekhasini;
- Ngezihloko, izindawo ziyikhoneni eliphezulu lesokunxele, isikhungo esiphakeme, nekhoneni eliphezulu eliphezulu lekhasi;
- Ngezinyawo, izindawo zingezansi ekhoneni elingakwesokunxele, isikhungo esingaphansi, nekhoneni elingezansi elingakwesokudla kwekhasi.
Izihloko ze-Preset / Amapheshana we-Preset
Iningi lezinhlobonhlobo ezihlelwe ngaphambili nezinyathelo ezitholakalayo ezikhompheni zokungena kwe-Excel - njenge- [Ikhasi] noma & [Usuku] - ukungenisa ulwazi olufunayo. Lezi amakhodi enza ukuthi izihloko nezinyawo ziguquke - kusho ukuthi ziyashintsha njengoba kudingeka, kanti izinhloko zezifiso nezinyawo ziyi-static.
Isibonelo, ikhodi ye- [Ikhasi] isetshenziselwa ukuba nezinombolo ezahlukene zekhasi ekhasini ngalinye. Uma ufakwe ngesandla usebenzisa inketho yangokwezifiso, wonke ikhasi lizoba nenombolo efanayo yekhasi
Ukubuka i-Header kanye nezinyawo
Izihloko nezinyawo zibonakala ekubukeni kwekhasi kodwa, njengoba kukhonjisiwe, hhayi ekubukweni kweshidi lomsebenzi ojwayelekile. Uma ungeza ama-header noma izinyathelo ngebhokisi lengxoxo yekhasi le- Page , shintshela ekhasini le-Layout noma sebenzisa I-Print Preview ukuze ubone.
Kunezinketho ezimbili zokwengeza kokubili izinkambiso kanye nezinhloko ezilungiselelwe kanye nezinyawo kwiphepha lokusebenzela:
- besebenzisa ikhasi le-Layout ;
- usebenzisa ibhokisi lengxoxo lokusetha Ikhasi .
Ukungeza i-Header Custom nobe Footer ekhasini Page
Ukwengeza inhloko yenkambiso noma inhloko ekubukweni kwekhasi lekhasi :
- Chofoza kuthebhu Buka yebhebhoni;
- Chofoza kokukhethwa kwekhasi kwi-Ribbon ukuze ushintshe ukubuka kwendawo yekhasi njengoba kuboniswe esithombeni esingenhla;
- Chofoza ngegundane kwelinye lamabhokisi amathathu phezulu noma phansi kwekhasi ukuze ungeze unhlokweni noma unyawo;
- Thayipha ulwazi lwezinhloko noma lezinyawo ebhokisini elikhethiwe.
Ukungeza i-Headset ye-Preset noma i-Footer ekhasini le-Page
Ukwengeza enye yezinhloko ezihleliwe noma izinhloko ekubukweni kwekhasi lekhasi :
- Chofoza kuthebhu Buka yebhebhoni;
- Chofoza kokukhethwa kwekhasi kwi-Ribbon ukuze ushintshe ukubuka kwendawo yekhasi njengoba kuboniswe esithombeni esingenhla;
- Chofoza ngegundane kwelinye lamabhokisi amathathu phezulu noma phansi kwekhasi ukuze ungeze inhloko noma unyawo kunaloo ndawo - ukwenza kanjalo futhi kunezela ithebhu yokuklama kubhebhoni njengoba kuboniswe esithombeni esingenhla;
- Ukwengeza unhlokweni ohleliwe noma unyaweni endaweni ekhethiwe kungenziwa ngu:
- Ukuchofoza ku-Header noma ku-Footer inketho kubhebhoni ukuvula imenyu ehlehlisayo yokukhetha okulungiselelwe;
- Ukuchofoza kwesinye sezinketho ezihleliwe ku-Ribbon - njengeNombolo Yekhasi , Usuku Olukhona , noma Igama Lefayela;
- Thayipha kolwazi lwezinhloko noma lezinyawo.
Ukubuyela ekubukeni okujwayelekile
Uma usuleze isihloko noma unyawo, i-Excel ikushiya ekubukweni kwekhasi lekhasi . Yize kungenzeka ukuthi usebenze kulo mbono, ungase ufune ukubuyela ekubukeni okujwayelekile . Ukwenza kanjalo:
- Chofoza kunoma isiphi iseli ekhasini lokusebenzela ukuze ushiye indawo yesiphezulu / unyawo;
- Chofoza kuthebhu yokubuka;
- Chofoza kwikhotho evamile ku-Ribbon.
Ukwengeza Amakhanda we-Preset nama-footer ku-Ibhokisi le-Dialog Box
- Chofoza ku- Ithebhu yekhasi lekhabhoni ;
- Chofoza kusiqalisi sebhokisi lebhokisi lebhokisi lebhokisi lengxoxo kusukela kwimenyu ukuvula ibhokisi lengxoxo lokusetha Ikhasi ;
- Ebhokisini lebhokisi, khetha ithebhu ye- Header / Footer ;
- Khetha kusuka kusihloko esethiwe noma senkambiso - izinketho ezinyaweni njengoba kuboniswe esithombeni esingenhla;
- Chofoza OK ukuvala ibhokisi lengxoxo;
- Ngokuzenzakalelayo, izingqikithi ezihleliwe nezinyawo zigxile ekhasini lokusebenzela;
- Hlola kuqala isihloko / inyawo ekubukeni kokuphrinta .
Qaphela : Izihloko zezintandokazi kanye nezinyawo zingabuye zengezwe ebhokisini lengxoxo ngokuchofoza kumakhanda okwezifiso noma izinkinobho zonyawo - kuboniswe esithombeni ngenhla.
Ukubuka i-Header noma i-Footer ekubonweni kokuphrinta
Qaphela : Kufanele ube nephrinta efakwe kwikhompyutha yakho ukuze usebenzise ukubuka kuqala kwephrinta.
- Chofoza kwimenyu yefayela ukuze uvule imenyu yokudonsa yezinketho;
- Chofoza kuPrinta kwimenyu ukuvula iwindi lokuphrinta;
- Iphepha lokusebenzela lamanje lizovela kuphaneli lokubuka kuqala ngakwesokudla kwewindi.
Ukususa Ama-Header noma ama-footers
Ukuze ususe ama-header ngabanye kanye / noma izinyathelo ezivela ephepheni lokusebenzela, sebenzisa izinyathelo ezingenhla ukuze ungeze izihloko nezinyawo usebenzisa umbono we-Page Layout bese ususa okuqukethwe okukhona kwekhanda / unyawo.
Ukukhipha izingqikithi kanye / noma izinyathelo ezivela emafishini amaningi emsebenzini ngaso sonke isikhathi:
- Khetha ama-worksheets;
- Chofoza ku- Ithebhu yokuhlela ikhasi;
- Chofoza kusiqalisi sebhokisi lebhokisi lebhokisi lebhokisi lengxoxo kusukela kwimenyu ukuvula ibhokisi lengxoxo lokusetha Ikhasi ;
- Ebhokisini lebhokisi, khetha ithebhu ye- Header / Footer ;
- Khetha (akekho) kusihlokweni esethiwe kanye / noma ebhokisini lezinyawo;
- Chofoza OK ukuvala ibhokisi lengxoxo;
- Yonke inhloko kanye / noma okuqukethwe kwezinyawo kufanele zisuswe emafishini akhethiwe.