Ukufometha amathebula ku-Excel. Indlela Yokufometha Amathebula - Isinyathelo Ngesinyathelo Umhlahlandlela

Ukufometha kungenye yezinqubo eziyinhloko lapho usebenza ne-spreadsheet. Ngokusebenzisa ukufometha, ungashintsha ukubukeka kwedatha yethebula, futhi usethe izinketho zamaseli. Kubalulekile ukukwazi ukukusebenzisa ngendlela efanele ukuze wenze umsebenzi wakho ohlelweni ngokushesha nangempumelelo. Kusukela esihlokweni uzofunda indlela yokufometha ithebula ngendlela efanele.

Ukufometha Kwethebula

Ukufometha isethi yezenzo ezidingekayo ukuze uhlele ukubukeka kwetafula kanye nezinkomba ezingaphakathi kwalo. Le nqubo ikuvumela ukuthi uhlele usayizi wefonti nombala, usayizi weseli, ukugcwalisa, ifomethi, njalonjalo. Ake sihlaziye isici ngasinye ngokuningiliziwe.

Ukufometha okuzenzakalelayo

Ukufometha okuzenzakalelayo kungasetshenziswa kunoma yiluphi uhla lwamaseli. Iphrosesa yesipredishithi izohlela ngokuzimela ububanzi obukhethiwe, isebenzisa imingcele eyabelwe kuyo. Ukuhamba:

1. Sikhetha iseli, ibanga lamaseli noma ithebula lonke.

2. Iya engxenyeni ethi “Ekhaya” bese uchofoza okuthi “Fometha Njengethebula”. Ungathola lesi sici ebhulokhini elithi "Izitayela". Ngemva kokuchofoza, iwindi elinazo zonke izitayela ezenziwe ngomumo ziyavezwa. Ungakhetha noma yiziphi izitayela. Chofoza inketho oyithandayo.

3. Kuboniswe iwindi elincane esikrinini, elidinga ukuqinisekiswa kokulunga kwezixhumanisi zobubanzi obufakiwe. Uma ubona ukuthi kunephutha ebangeni, ungahlela idatha. Udinga ukucabangela ngokucophelela into "Ithebula elinezihloko." Uma ithebula liqukethe izihloko, khona-ke lesi sakhiwo kufanele sihlolwe. Ngemva kokwenza zonke izilungiselelo, chofoza "OK".

4. Ilungile! Ipuleti lithathe ukubukeka kwesitayela osikhethile. Noma kunini, lesi sitayela singashintshwa sibe esinye.

Ishintshela ekufometheni

Amathuba okufometha okuzenzakalelayo awahambisani nabo bonke abasebenzisi bephrosesa yesipredishithi. Kungenzeka ukufometha ngesandla ipuleti usebenzisa imingcele ekhethekile. Ungahlela ukubukeka usebenzisa imenyu yokuqukethwe noma amathuluzi atholakala kuribhoni. Ukuhamba:

1. Senza ukukhetha kwendawo yokuhlela edingekayo. Chofoza kuyo i-RMB. Imenyu yokuqukethwe ivezwa esibukweni. Chofoza into ethi “Fometha Amaseli…”.

2. Ibhokisi elithi “Fometha Amaseli” livela esikrinini. Lapha ungenza izikhohlisayo zokuhlela idatha yethebula ehlukahlukene.

Ingxenye ethi Ikhaya iqukethe amathuluzi okufometha ahlukahlukene. Ukuze uwasebenzise kumaseli akho, udinga ukuwakhetha, bese uchofoza kunoma iyiphi yawo.

Ukufomatha Idatha

Ifomethi yeseli ingenye yezinto eziyisisekelo zokufometha. Le nto ayishintshi nje kuphela ukubonakala, kodwa futhi itshela iphrosesa yesipredishithi ukuthi icubungula kanjani iseli. Njengendlela yangaphambilini, lesi senzo singenziwa ngemenyu yokuqukethwe noma ngamathuluzi atholakala kuribhoni elikhethekile lethebhu ethi Ikhaya.

Ngokuvula iwindi elithi “Fometha Amaseli” usebenzisa imenyu yokuqukethwe, ungakwazi ukuhlela ifomethi ngesigaba esithi “Amafomethi Ezinombolo”, esikubhulokhi elithi “Inombolo”. Lapha ungakhetha ifomethi eyodwa kulawa alandelayo:

• usuku;
• isikhathi;
• okuvamile;
• inombolo;
• umbhalo, njll.

Ngemva kokukhetha ifomethi edingekayo, chofoza "Kulungile".

Ngaphezu kwalokho, amanye amafomethi anezinketho ezengeziwe. Ngokukhetha ifomethi yenombolo, ungahlela inani lamadijithi ngemva kwephoyinti ledesimali lezinombolo eziyingxenye.

Ngokusetha ifomethi ethi "Idethi", ungakhetha ukuthi idethi izovezwa kanjani esikrinini. Ipharamitha ethi "Isikhathi" inezilungiselelo ezifanayo. Ngokuchofoza into ethi "Wonke amafomethi", ungabuka zonke izinhlobo ezingaba khona zedatha yokuhlela kuseli.

Ngokuya esigabeni "Ekhaya" futhi wandise uhlu olutholakala kubhulokhi "Inombolo", ungakwazi futhi ukuhlela ifomethi yeseli noma uhla lwamaseli. Lolu hlu luqukethe wonke amafomethi amakhulu.

Ngokuchofoza into ethi “Amanye amafomethi ezinombolo ..." kuzovezwa iwindi elaziwa kakade elithi "Ifomethi yamaseli", lapho ungenza khona izilungiselelo ezinemininingwane eminingi yefomethi.

Ukuqondanisa okuqukethwe

Ngokuya ebhokisini elithi “Fometha Amaseli”, bese uye esigabeni esithi “Ukuqondanisa”, ungenza izilungiselelo ezengeziwe ukuze wenze ukubukeka kwepuleti kubonakale kakhudlwana. Leli windi liqukethe inani elikhulu lezilungiselelo. Ngokukhetha ibhokisi eliseduze nepharamitha eyodwa noma enye, ungahlanganisa amaseli, usonge umbhalo ngamagama, futhi usebenzise ukukhetha kobubanzi obuzenzakalelayo.

Ngaphezu kwalokho, kulesi sigaba, ungasebenzisa indawo yombhalo ngaphakathi kweseli. Kukhona ukukhetha kwesibonisi sombhalo oqondile novundlile.

Esigabeni esithi "Umumo", ungalungisa i-engeli yokuma yolwazi lombhalo ngaphakathi kweseli.

Esigabeni "Ekhaya" kukhona ibhulokhi yamathuluzi "Ukuqondanisa". Lapha, njengasewindini elithi “Fometha Amaseli”, kunezilungiselelo zokuqondanisa idatha, kodwa ngendlela enqanyulwe kakhulu.

Ukulungiselelwa kwefonti

Ingxenye ethi “Ifonti” ikuvumela ukuthi wenze isethi enkulu yezenzo ukuze uhlele ulwazi kuseli ekhethiwe noma uhla lwamaseli. Lapha ungakwazi ukuhlela okulandelayo:

• uhlobo;
• ubukhulu;
• Umbala;
• isitayela, njll.

Kuribhoni ekhethekile kukhona ibhulokhi yamathuluzi "Ifonti", ekuvumela ukuthi wenze izinguquko ezifanayo.

Imingcele nemigqa

Esigabeni esithi "Border" sewindi elithi "Fometha Amaseli", ungenza ngokwezifiso izinhlobo zemigqa, futhi usethe umbala owufunayo. Lapha ungaphinda ukhethe isitayela somngcele: wangaphandle noma wangaphakathi. Kungenzeka ukususa ngokuphelele umngcele uma kungadingeki etafuleni.

Ngeshwa, awekho amathuluzi okuhlela imingcele yethebula kuribhoni eliphezulu, kodwa kunento encane etholakala kubhulokhi "Ifonti".

Ukugcwalisa amaseli

Esigabeni esithi “Gcwalisa” sebhokisi elithi “Fometha Amaseli”, ungahlela umbala wamaseli ethebula. Kukhona elinye ithuba lokubonisa amaphethini ahlukahlukene.

Njengakwisici sangaphambilini, kunenkinobho eyodwa kuphela kubha yamathuluzi, etholakala kubhulokhi elithi "Ifonti".

Kwenzeka ukuthi umsebenzisi akanawo ama-shades ajwayelekile anele ukuze asebenze ngolwazi lwethebula. Kulokhu, udinga ukuya esigabeni "Eminye imibala ..." ngokusebenzisa inkinobho etholakala kubhulokhi elithi "Ifonti". Ngemva kokuchofoza, iwindi liyavela elikuvumela ukuthi ukhethe umbala ohlukile.

Izitayela zamaseli

Awukwazi ukusetha isitayela seseli ngokwakho, kodwa futhi ukhethe kulezo ezihlanganiswe kusipredishithi ngokwaso. Umtapo wezincwadi wezitayela ubanzi, ngakho umsebenzisi ngamunye uzokwazi ukuzikhethela isitayela esifanele.

Ukuhamba ngezinyawo:

1. Khetha amaseli adingekayo ukuze usebenzise isitayela esiqediwe.
2. Yiya engxenyeni ethi “Ekhaya”.
3. Chofoza "Izitayela Zeseli".
4. Khetha isitayela sakho osithandayo.

Ukuvikelwa kwedatha

Ukuvikela nakho kuyingxenye yokufometha. Efasiteleni elijwayelekile elithi “Fometha Amaseli”, kunesigaba esibizwa ngokuthi “Ukuvikela”. Lapha ungasetha izinketho zokuvikela ezizovimbela ukuhlela ububanzi obukhethiwe bamaseli. Futhi lapha ungavumela ukufihla amafomula.

Kuribhoni yamathuluzi engxenyeni ethi Ikhaya, kubhulokhi yamaseli, kukhona isici sefomethi esikuvumela ukuthi wenze izinguquko ezifanayo. Ngokuchofoza ku-"Fometha", isikrini sizobonisa uhlu lapho into "Yokuvikela" ikhona. Ngokuchofoza okuthi “Vikela ishidi…”, ungavimbela ukuhlela lonke ishidi ledokhumenti oyifunayo.

Izindikimba zethebula

Kuspredishithi i-Excel, kanye ne-word processor Word, ungakhetha itimu yedokhumenti.

Ukuhamba ngezinyawo:

1. Iya kuthebhu "Isakhiwo Sekhasi".
2. Chofoza ku-elementi ethi "Itimu".
3. Khetha enye yezindikimba esezilungile.

Ushintsho lube “Ithebula Elihlakaniphile”

Ithebula “elihlakaniphile” liwuhlobo olukhethekile lokufometha, ngemva kwalokho uhlu lwamaseli luthola izici ezithile eziwusizo ezenza kube lula ukusebenza ngenani elikhulu ledatha. Ngemuva kokuguqulwa, ububanzi bamaseli bubhekwa uhlelo njengento yonke. Ukusebenzisa lo msebenzi kusindisa abasebenzisi ekubaleni kabusha amafomula ngemva kokwengeza imigqa emisha etafuleni. Ngaphezu kwalokho, ithebula elithi “Smart” linezinkinobho ezikhethekile kuzihloko ezikuvumela ukuthi uhlunge idatha. Umsebenzi unikeza ikhono lokuphina unhlokweni wethebula phezulu eshidini. Ukuguqulwa ku-“Smart Table” kwenziwa kanje:

1. Khetha indawo edingekayo ukuze uhlele. Kubha yamathuluzi, khetha into ethi “Izitayela” bese uchofoza okuthi “Fometha Njengethebula”.

2. Isikrini sibonisa uhlu lwezitayela esezilungile ezinamapharamitha asethiwe. Chofoza inketho oyithandayo.

3. Kuvele iwindi elisizayo elinezilungiselelo zobubanzi nokuvezwa kwezihloko. Setha wonke amapharamitha adingekayo bese uchofoza inkinobho ethi "OK".

4. Ngemva kokwenza lezi zilungiselelo, ithebhulethi yethu yaphenduka i-Smart Table, okulula kakhulu ukusebenza nayo.

Isibonelo sokufometha kwethebula

Ake sithathe isibonelo esilula sendlela yokufometha ithebula ngesinyathelo. Isibonelo, sidale ithebula elifana naleli:

Manje ake siqhubekele ekuhleleni kwayo okuningiliziwe:

1. Ake siqale ngesihloko. Khetha uhla A1 … E1, bese uchofoza ku-“Hlanganisa bese uya phakathi nendawo.” Le nto itholakala esigabeni esithi “Ukufometha”. Amaseli ahlanganisiwe futhi umbhalo wangaphakathi uqondaniswe namaphakathi. Setha ifonti ku-“Arial”, usayizi ube ngu-“16”, “Bold”, “Udwetshelwe”, umthunzi wefonti ube “Okuphephuli”.
2. Asiqhubekele ekufometheni izihloko zekholomu. Khetha amaseli A2 no-B2 bese uchofoza okuthi “Hlanganisa Amaseli”. Senza izenzo ezifanayo ngamaseli A7 kanye ne-B7. Setha idatha elandelayo: ifonti - "Arial Black", usayizi - "12", ukuqondanisa - "Kwesobunxele", umthunzi wefonti - "Purple".
3. Sikhetha i-C2 … E2, kuyilapho sibambe u-“Ctrl”, sikhetha i-C7 … E7. Lapha sibeka amapharamitha alandelayo: ifonti - "Arial Black", usayizi - "8", ukuqondanisa - "Okumaphakathi", umbala wefonti - "Purple".
4. Asiqhubekele ekuhleleni okuthunyelwe. Sikhetha izinkomba eziyinhloko zetafula - lawa amaseli A3 ... E6 kanye no-A8 ... E8. Setha imingcele elandelayo: ifonti - "Arial", "11", "Bold", "Centered", "Blue".
5. Qondanisa nonqenqema lwesokunxele B3 … B6, kanye ne-B8.
6. Sidalula umbala obomvu ku-A8 … E8.
7. Sikhetha okuthi D3 … D6 bese ucindezela u-RMB. Chofoza okuthi “Fometha Amaseli…”. Efasiteleni elivelayo, khetha uhlobo lwedatha yezinombolo. Senza izenzo ezifanayo ngeseli D8 bese sibeka amadijithi amathathu ngemva kwephoyinti ledesimali.
8. Asiqhubekele ekufometheni imingcele. Senza ukukhetha kwe-A8 … E8 bese uchofoza “Yonke Imingcele”. Manje khetha "Thick Outer Border". Okulandelayo, sikhetha i-A2 ... E2 futhi siphinde sikhethe "Umngcele wangaphandle owugqinsi". Ngendlela efanayo, sifometha i-A7 … E7.
9. Senza ukusethwa kombala. Khetha i-D3…D6 bese unikeza ukukhanya okuluhlaza okotshani. Senza ukukhetha kwe-D8 bese setha umbala ophuzi okhanyayo.
10. Siqhubekela ekufakweni kwesivikelo kudokhumenti. Sikhetha iseli D8, chofoza kwesokudla kuyo bese uchofoza "Fometha Amaseli". Lapha sikhetha into ethi "Ukuvikela" bese sibeka uphawu eduze kwento ethi "Iseli elivikelwe".
11. Sithuthela kumenyu eyinhloko yokucubungula isipredishithi bese siya esigabeni "Isevisi". Bese sidlulela kokuthi "Ukuvikela", lapho sikhetha khona into ethi "Vikela Ishidi". Ukusetha iphasiwedi kuyisici ozikhethela sona, kodwa ungayisetha uma uthanda. Manje leli seli alikwazi ukuhlelwa.

Kulesi sibonelo, sihlole ngokuningiliziwe ukuthi ungafometha kanjani ithebula kuspredishithi isinyathelo ngesinyathelo. Umphumela wokufometha ubukeka kanje:

Njengoba sibona, isibonakaliso sishintshe kakhulu kusukela ngaphandle. Ukubukeka kwakhe sekunethezekile futhi kuyabukeka. Ngezenzo ezifanayo, ungafometha ngokuphelele noma yiliphi ithebula futhi ubeke ukuvikeleka kulo ekuhleleni ngephutha. Indlela yokufometha eyenziwa ngesandla iphumelela kakhulu kunokusebenzisa izitayela ezichazwe ngaphambilini, njengoba ungasetha mathupha imingcele ehlukile yanoma yiluphi uhlobo lwethebula.

Isiphetho

Iphrosesa yesipredishithi inenani elikhulu lezilungiselelo ezikuvumela ukuthi ufomethe idatha. Uhlelo lunezitayela ezilungele ezakhelwe ngaphakathi ezakhelwe ngaphakathi ezinezinketho zokufometha ezisethiwe, futhi ngewindi elithi “Fometha Amaseli”, ungakwazi ukusebenzisa izilungiselelo zakho ngokwakho.