Ungawabhala kanjani izinombolo ku-Excel. Kusuka ekhasini elithile, kusuka eshidini lesibili, kucatshangelwa inani lamakhasi efayeleni

Ukufaka izinombolo kuyindlela elula yokudala ukuzulazula okunethezekile okukuvumela ukuthi uzulazule ngokushesha kudokhumenti. Uma umsebenzi wenziwa etafuleni elilodwa, asikho isidingo sokubala izinombolo. Yiqiniso, uma uhlela ukuyiphrinta esikhathini esizayo, khona-ke kuyodingeka ukuyibhala ngaphandle kokwehluleka ukuze ungadideki ngobuningi bemigqa namakholomu. Kunezinketho eziningi zokwenziwa kwe-pagination, esizozihlanganisa ngokuningiliziwe kulesi sihloko.

Ukuqanjwa okulula

Le ndlela ilula kunazo zonke ezitholakalayo futhi ikuvumela ukuthi ufake izinombolo ngokushesha amakhasi. Ukuze wenze lokhu, udinga ukwenza okulandelayo:

1. Udinga ukwenza kusebenze "Izihloko Nezansi", ngenxa yalokhu udinga ukuya ku-Excel kubha yamathuluzi engxenyeni ethi "Faka". Kuyo, udinga ukukhetha into ethi "Umbhalo" bese usebenzisa kuphela "Izihloko Nezansi". Iphuzu elithakazelisayo ukuthi izihloko nonyaweni zingabekwa kokubili ngenhla nangaphansi, ngokuzenzakalelayo aziboniswa, futhi ngesikhathi sokusetha kokuqala, ungasetha ukuboniswa kolwazi ekhasini ngalinye lethebula.

2. Ngemuva kokuya esigabeni osifunayo, into ekhethekile "Izihloko nezasensini" izovela, lapho ungahlela khona izilungiselelo ezitholakalayo. Ekuqaleni, indawo iyatholakala, ihlukaniswe izingxenye ezintathu phezulu noma phansi.

3. Manje kusele ukukhetha ingxenye yesihloko lapho ulwazi luzoboniswa khona. Kwanele ukuyichofoza nge-LMB bese uchofoza entweni ethi “Inombolo yekhasi”.

4. Ngemva kokuqeda izinyathelo, ulwazi olulandelayo luzovela kunhlokweni: &[Ikhasi].

5. Kusele ukuchofoza endaweni engenalutho kudokhumenti ukuze ulwazi olufakile luguqulwe lube inombolo yekhasi.

6. Kungenzeka ukufometha ulwazi olufakiwe. Ukuze wenze lokhu, vele ukhethe idatha ngqo kunhlokweni futhi, ngemva kokukhetha, hamba kuthebhu ethi "Ekhaya", lapho ungashintsha khona ifonti, ukhulise usayizi, noma uguqule amanye amapharamitha.

7. Uma zonke izinguquko sezenziwe, kusasele ukuchofoza endaweni engenalutho yefayela, futhi zizosetshenziswa kunhlokweni.

Ukufaka izinombolo kususelwa enanini eliphelele lamakhasi efayelini

Kukhona enye indlela yokufaka izinombolo zamakhasi kudokhumenti ngokusekelwe enanini eliphelele lamakhasi kuthebula. Ukuze wenze lokhu, uzodinga ukwenza lokhu okulandelayo:

1. Ekuqaleni, kufanele usebenzise izincomo ezisuka endleleni yokuqala ncamashi kuze kube yilapho uya esigabeni esithi “Izihloko Nezansi”.
2. Ngokushesha nje lapho ilebula lokuqala livela kunhlokweni nonyaweni, kufanele ulihlele kancane ukuze uthole umphumela olandelayo: Ikhasi &[Ikhasi] kusuka.

3. Ngemva kokuqeda umbhalo othi “kusuka”, chofoza inkinobho ethi “Inombolo yamakhasi” kubha yamathuluzi phezulu.

4. Uma konke kwenziwa ngendlela efanele, ngemva kokuchofoza endaweni engenalutho yekhasi, uzobona unhlokweni ozobonisa ulwazi mayelana nenombolo yekhasi kanye nenani eliphelele lamashidi.

Ukufaka izinombolo eshidini lesibili

Uma uke wabhala iphepha lethemu ngaphambilini noma ithisisi, cishe uyawazi umthetho wokuklama oyinhloko: inombolo yekhasi ayifakwa ekhasini lesihloko, futhi ikhasi elilandelayo linamathiselwe ku-deuce. Amathebula angase adinge le nketho yokuklama, ngakho-ke sincoma ukuthi wenze okulandelayo:

1. Udinga ukwenza kusebenze izihloko nonyaweni, ngenxa yalokhu, sebenzisa izincomo ezivela endleleni yokuqala.
2. Manje esigabeni esivelayo, iya entweni ethi “Amapharamitha”, lapho ungamaka khona ibhokisi eliseduze kwento ethi “Isihloko esikhethekile sekhasi lokuqala”.

3. Kusele ukubala amakhasi nganoma iyiphi yezindlela ebezicatshangelwe ngaphambili. Yiqiniso, ukuze uthole izinombolo, kufanele ukhethe ikhasi lesibili ukuze umise unhlokweni.
4. Uma wenza konke kahle, uzothola umphumela oyifunayo. Eqinisweni, unhlokweni ekhasini lokuqala uzoba khona, ngeke uvele uboniswe. Idizayini ebonakalayo izovele iqale ekhasini lesibili, njengoba ibidingeka ekuqaleni.

Le nketho yokufaka izinombolo ifanele ukuklanywa kwezinhlobonhlobo zamaphepha esayensi futhi esimweni sokuhlinzeka ngetafula njengento efakwe ephepheni locwaningo.

Ukufaka izinombolo ekhasini elithile

Isimo singenzeka futhi lapho kudingeka ukuba uqale ukufaka izinombolo hhayi ekhasini lokuqala, kodwa kusukela ekhasini lesithathu noma ngisho neleshumi. Nakuba lokhu kuyivelakancane kakhulu, ngeke kube yinto engafanele ukwazi mayelana nokuba khona kwendlela enjalo, i-algorithm yezenzo imi kanje:

1. Okokuqala, kuyadingeka ukukhiqiza izinombolo eziyisisekelo usebenzisa enye yezindlela ezixoxwe ngenhla.
2. Ngemva kokuqeda izinyathelo zokuqala, kufanele uye ngokushesha engxenyeni ethi “Isakhiwo Sekhasi” kubha yamathuluzi.
3. Sifunde ngokucophelela lesi sigaba futhi unake umbhalo othi "Ukusethwa Kwekhasi" ngezansi ngaphansi kwezinto "Indawo Yokuphrinta", "Amakhefu", njll. Eduze kwalesi siginesha ungabona umcibisholo, chofoza kuwo.

4. Iwindi elinezilungiselelo ezengeziwe lizovela. Kuleli windi, khetha ingxenye ethi "Ikhasi", bese uthola into ethi "Inombolo Yekhasi Lokuqala". Kuyo udinga ukucacisa ukuthi yiliphi ikhasi odinga izinombolo. Lapho yonke into isethiwe, chofoza "OK".

5. Ngemva kokuqeda izinyathelo, izinombolo zizoqala ncamashi nenombolo oyicacisile kumapharamitha.

Uma ufuna ukususa izinombolo, mane ukhethe imininingwane engaphakathi kwesihloko bese uchofoza ku- “Susa".

Isiphetho

Inqubo yokufaka izinombolo ayithathi isikhathi esiningi futhi ikuvumela ukuthi ukwazi kahle lawa makhono awusizo ngaphandle kwezinkinga. Kwanele ukusebenzisa izincomo ezikhona ezikhonjiswe ngenhla ukuze uqedele umsebenzi.