Okuqukethwe
Iseli ngalinye linefomethi yalo ekuvumela ukuthi ucubungule ulwazi ngendlela eyodwa noma enye. Kubalulekile ukuyibeka ngendlela efanele ukuze zonke izibalo ezidingekayo zenziwe ngendlela efanele. Kusuka esihlokweni uzofunda ukuthi ungashintsha kanjani ifomethi yamaseli kuspredishithi se-Excel.
Izinhlobo eziyinhloko zokufometha nokushintsha kwazo
Kunamafomethi ayisisekelo ayishumi esewonke:
- Okuvamile.
- Ezezimali.
- Okwezinombolo.
- Ezezimali.
- Umbhalo.
- Usuku.
- Isikhathi.
- Okuncane.
- Iphesenti.
- Imininingwane engeziwe
Amanye amafomethi anezinhlobo zawo ezingaphansi ezengeziwe. Kunezindlela eziningana zokushintsha ifomethi. Ake sihlaziye ngayinye ngokuningiliziwe.
Ukusebenzisa imenyu yokuqukethwe ukuhlela ifomethi kungenye yezindlela ezisetshenziswa kakhulu. Ukuhamba ngezinyawo:
- Udinga ukukhetha lawo maseli ofuna ukuhlela ifomethi yawo. Sichofoza kubo ngenkinobho yegundane engakwesokudla. Imenyu yokuqukethwe ekhethekile ivuliwe. Chofoza into ethi “Fometha Amaseli …”.
- Ibhokisi lefomethi lizovela esikrinini. Sithuthela engxenyeni ebizwa ngokuthi "Inombolo". Naka ibhulokhi "amafomethi ezinombolo". Nawa wonke amafomethi akhona anikezwe ngenhla. Sichofoza ifomethi ehambisana nohlobo lolwazi olunikezwa kuseli noma uhla lwamaseli. Ngakwesokudla sebhulokhi yefomethi kukhona ukulungiselelwa kokubuka okungaphansi. Ngemva kokwenza zonke izilungiselelo, chofoza "OK".
- Ilungile. Ukuhlela ifomethi kube yimpumelelo.
Indlela yesi-2: Inombolo yebhokisi lamathuluzi kuribhoni
Iribhoni yamathuluzi iqukethe izakhi ezikhethekile ezikuvumela ukuthi ushintshe ifomethi yamaseli. Ukusebenzisa le ndlela kuyashesha kakhulu kuneyangaphambili. Ukuhamba:
- Senza ukushintshela esigabeni "Ekhaya". Okulandelayo, khetha iseli oyifunayo noma uhla lwamaseli bese uvula ibhokisi lokukhetha kubhulokhi elithi “Inombolo”.
- Izinketho zefomethi eyinhloko zidaluliwe. Khetha oyidingayo endaweni ekhethiwe. Ukufometha kushintshile.
- Kufanele kuqondwe ukuthi lolu hlu luqukethe kuphela izakhiwo eziyinhloko. Ukuze unwebe lonke uhlu, udinga ukuchofoza "Amanye amafomethi ezinombolo".
- Ngemva kokuchofoza lesi sici, iwindi elijwayelekile lizovela nazo zonke izinketho zokufometha ezingaba khona (okuyisisekelo nokungeziwe).
Indlela yesi-3: “Amaseli” ibhokisi lamathuluzi
Indlela yokuhlela elandelayo yefomethi yenziwa ngebhulokhi "Amaseli". Ukuhamba:
- Sikhetha iseli noma ububanzi bamaseli esifuna ukushintsha ifomethi yawo. Sithuthela engxenyeni ethi "Ekhaya", chofoza umbhalo othi "Format". Lesi sakhi sitholakala kubhulokhi "Amaseli". Ohlwini oluya phansi, chofoza okuthi “Fometha Amaseli …”.
- Ngemuva kwalesi senzo, iwindi lokufometha elijwayelekile livele. Senza zonke izenzo ezidingekayo, sikhetha ifomethi oyifunayo bese sichofoza "Kulungile".
Indlela yesi-4: ama-hotkeys
Ifomethi yeseli ingahlelwa kusetshenziswa okhiye abakhethekile besipredishithi. Okokuqala udinga ukukhetha amaseli owafunayo, bese ucindezela inhlanganisela yokhiye u-Ctrl + 1. Ngemva kokukhwabanisa, iwindi lokushintsha ifomethi elijwayelekile lizovuleka. Njengezindlela zangaphambilini, khetha ifomethi oyifunayo bese uchofoza "Kulungile". Ukwengeza, kunezinye izinqamuleli zekhibhodi ezikuvumela ukuthi uhlele ifomethi yeseli ngaphandle kokubonisa ibhokisi lefomethi:
- Ctrl+Shift+- – jikelele.
- U-Ctrl+Shift+1 — izinombolo ezinokhefana.
- Ctrl+Shift+2 - isikhathi.
- Ctrl+Shift+3 - idethi.
- Ctrl+Shift+4 - imali.
- Ctrl+Shift+5 – iphesenti.
- Ifomethi ka-Ctrl+Shift+6 – O.OOE+00.
Ifomethi yedethi enesikhathi ku-Excel kanye nezinhlelo zokubonisa ezi-2
Ifomethi yedethi ingafomethwa ngokuqhubekayo kusetshenziswa amathuluzi espredishithi. Isibonelo, sinale thebhulethi enolwazi. Kudingeka siqinisekise ukuthi izinkomba emigqeni zilethwa efomini elikhonjiswe emagameni amakholomu.
Kukholomu yokuqala, ifomethi ekuqaleni isethwe ngendlela efanele. Ake sibheke ikholomu yesibili. Khetha wonke amaseli ezinkomba wekholomu yesibili, cindezela inhlanganisela yokhiye CTRL + 1, engxenyeni ethi “Inombolo”, khetha isikhathi, bese kuthebhu ethi “Uhlobo” khetha indlela yokubonisa ehambisana nesithombe esilandelayo:
Senza izenzo ezifanayo ngekholomu yesithathu neyesine. Setha lawo mafomethi kanye nezinhlobo zokubonisa ezihambisana namagama ekholomu adaluliwe. Kunamasistimu wokubonisa amadethi ama-2 kusipredishithi:
- Inombolo 1 nguJanuwari 1, 1900.
- Inombolo engu-0 inguJanuwari 1, 1904, futhi inombolo engu-1 ingu-02.01.1904/XNUMX/XNUMX.
Ukushintsha ukuboniswa kwezinsuku kwenziwa kanje:
- Asiye kokuthi “Ifayela”.
- Chofoza okuthi “Izinketho” bese uye engxenyeni ethi “Okuthuthukisiwe”.
- Kubhulokhi ethi “Lapho ubala kabusha leli bhuku, khetha inketho ethi “Sebenzisa uhlelo lwedethi lwango-1904”.
Ithebhu Yokuqondanisa
Usebenzisa ithebhu "Ukuqondanisa", ungasetha indawo yenani ngaphakathi kweseli ngamapharamitha ambalwa:
- maqondana;
- ngokuvundlile;
- mpo;
- isihlobo nesikhungo;
- njalo njalo.
Ngokuzenzakalelayo, inombolo ethayiphiwe kuseli iqondaniswe kwesokudla, futhi imininingwane yombhalo iqondaniswe kwesokunxele. Kubhulokhi ethi "Ukuqondanisa", ithebhu "Ekhaya", ungathola izici zokufometha eziyisisekelo.
Ngosizo lwezakhi zeribhoni, ungahlela ifonti, usethe imingcele futhi ushintshe ukugcwaliswa. Udinga nje ukukhetha iseli noma uhla lwamaseli bese usebenzisa ibha yamathuluzi engaphezulu ukuze usethe zonke izilungiselelo ozifunayo.
Ngihlela umbhalo
Ake sibheke izindlela ezimbalwa zokwenza umbhalo ngendlela oyifisayo kumaseli ukwenza amathebula anolwazi afundeke ngendlela esingakhona ngayo.
Ungashintsha kanjani ifonti ye-Excel
Ake sibheke izindlela ezimbalwa zokushintsha ifonti:
- Indlela yokuqala. Khetha iseli, iya engxenyeni ethi “Ekhaya” bese ukhetha into ethi “Ifonti”. Uhlu luyavuleka lapho umsebenzisi ngamunye engazikhethela ifonti efanelekile.
- Indlela yesibili. Khetha iseli, chofoza kwesokudla kuyo. Imenyu yokuqukethwe iyavezwa, futhi ngaphansi kwayo kunefasitela elincane elikuvumela ukuthi ufomethe ifonti.
- Indlela yesithathu. Khetha iseli bese usebenzisa inhlanganisela yokhiye u-Ctrl + 1 ukuze ubize “Amaseli Fometha”. Ewindini elivelayo, khetha isigaba "Ifonti" bese wenza zonke izilungiselelo ezidingekayo.
Ungazikhetha kanjani Izitayela ze-Excel
Izitayela ezigqamile, ezimalukeke, nezidwebelayo zisetshenziselwa ukugqamisa ulwazi olubalulekile kumathebula. Ukushintsha isitayela seseli lonke, udinga ukuchofoza kuso ngenkinobho yegundane kwesokunxele. Ukushintsha ingxenye yeseli kuphela, udinga ukuchofoza kabili kuseli, bese ukhetha ingxenye oyifunayo yokufometha. Ngemva kokukhetha, shintsha isitayela usebenzisa enye yezindlela ezilandelayo:
- Ukusebenzisa izinhlanganisela eziyinhloko:
- Ctrl+B - ngokugqamile;
- U-Ctrl+I – italic;
- Ctrl+U - kudwetshelwe;
- I-Ctrl + 5 - inqanyuliwe;
- Ctrl+= – umbhalo ophansi;
- Ctrl+Shift++ – umbhalo ongenhla.
- Ukusebenzisa amathuluzi atholakala kubhulokhi ethi “Ifonti” kuthebhu ethi “Ekhaya”.
- Ukusebenzisa ibhokisi elithi Fometha Amaseli. Lapha ungasetha izilungiselelo ozifunayo esigabeni esithi "Lungisa" kanye "Nesibhalo".
Iqondanisa umbhalo kumaseli
Ukuqondanisa umbhalo kumaseli kwenziwa ngezindlela ezilandelayo:
- Iya engxenyeni ethi "Ukuqondanisa" yesigaba "Ekhaya". Lapha, ngosizo lwezithonjana, ungaqondanisa idatha.
- Ebhokisini elithi “Fometha Amaseli”, yiya engxenyeni ethi “Ukuqondanisa”. Lapha ungaphinda ukhethe zonke izinhlobo ezikhona zokuqondanisa.
Fometha ngokuzenzakalelayo umbhalo ku-Excel
Nakani! Umbhalo omude ofakwe kuseli ungase ungangeni kuwo futhi uzovezwa ngokungalungile. Kukhona isici sokufometha ngokuzenzakalela ukuze ugweme le nkinga.
Izindlela ezimbili zokufometha okuzenzakalelayo:
- Ukusebenzisa ukugoqa amagama. Khetha amaseli owafunayo, yiya engxenyeni ethi “Ekhaya”, bese uye kokuthi “Ukuqondanisa” bese ukhetha okuthi “Hambisa Umbhalo”. Ukunika lesi sici amandla kukuvumela ukuthi usebenzise ngokuzenzakalelayo ukugoqa amagama futhi ukhuphule ubude bomugqa.
- Ukusebenzisa umsebenzi we-AutoFit. Iya ebhokisini elithi “Fometha Amaseli”, bese uthi “Ukuqondanisa” bese uqoka ibhokisi eliseduze kokuthi “Ububanzi Be-AutoFit”.
Ungawahlanganisa kanjani amaseli ku-Excel
Ngokuvamile, lapho usebenza namatafula, kuba kudingekile ukuhlanganisa amaseli. Lokhu kungenziwa kusetshenziswa inkinobho ethi "Hlanganisa kanye Nesikhungo", etholakala kubhulokhi ethi "Ukuqondanisa" yesigaba "Ekhaya". Ukusebenzisa le nketho kuzohlanganisa wonke amaseli akhethiwe. Amanani angaphakathi kwamaseli aqondaniswe nendawo.
Ukushintsha Ukuma Nendlela Yombhalo
Ukuqondiswa kombhalo kanye nomumo kuyizilungiselelo ezimbili ezihlukene abanye abasebenzisi abazididayo. Kulo mfanekiso, ikholomu yokuqala isebenzisa umsebenzi wokuma, futhi ikholomu yesibili isebenzisa isiqondiso:
Ngokuya esigabeni esithi "Ekhaya", ibhulokhi ethi "Ukuqondanisa" kanye "noMayelana", ungasebenzisa le mingcele emibili.
Ukusebenza nge-Excel Cell Formatting Styles
Ukusebenzisa izitayela zokufometha kungasheshisa kakhulu inqubo yokufometha ithebula futhi kunikeze ukubukeka okuhle.
Kungani Kudingeka Izitayela Eziqanjiwe
Izinjongo eziyinhloko zokusebenzisa izitayela:
- Dala amasethi esitayela ahlukile ukuze uhlele izihloko, izihlokwana, umbhalo, nokuningi.
- Ukusebenzisa izitayela ezidaliwe.
- Ukuzenzakalela komsebenzi ngedatha, njengoba usebenzisa isitayela, ungafometha yonke idatha ebangeni elikhethiwe.
Ukusebenzisa izitayela kumaseli eshidi lokusebenzela
Kunenani elikhulu lezitayela ezihlanganisiwe esezilungile kuphrosesa yesipredishithi. Umhlahlandlela wesinyathelo ngesinyathelo sokusebenzisa izitayela:
- Iya kuthebhu ethi “Ekhaya”, thola ibhulokhi elithi “Izitayela Zeseli”.
- Umtapo wezincwadi wezitayela ezilungile uboniswa esikrinini.
- Khetha iseli oyifunayo bese uchofoza isitayela osithandayo.
- Isitayela sisetshenziswe kuseli. Uma nje uhambisa imawusi phezu kwesitayela esiphakanyisiwe, kodwa ungachofozi kuso, ungabuka kuqala ukuthi izobukeka kanjani.
Ukudala Izitayela Ezintsha
Ngokuvamile, abasebenzisi abanazo izitayela ezanele ezenziwe ngomumo, futhi baphendukela ekuthuthukiseni ezabo. Ungenza esakho isitayela esiyingqayizivele ngale ndlela elandelayo:
- Khetha noma iyiphi iseli bese uyifometha. Sizodala isitayela esisuselwe kulokhu kufometha.
- Yiya engxenyeni ethi “Ekhaya” bese udlulela kubhulokhi elithi “Izitayela Zeseli”. Chofoza okuthi “Dala Isitayela Seseli”. Iwindi elibizwa ngokuthi “Isitayela” liyavuleka.
- Faka noma yiliphi “Igama Lesitayela”.
- Sibeka yonke imingcele edingekayo ofuna ukuyifaka kwisitayela esidaliwe.
- Sichofoza "OK".
- Manje isitayela sakho esiyingqayizivele sengeziwe kumtapo wezincwadi wesitayela, ongasetshenziswa kulo mbhalo.
Ukushintsha Izitayela Ezikhona
Izitayela esezilungile ezitholakala kulabhulali zingashintshwa ngokuzimela. Ukuhamba:
- Yiya engxenyeni ethi “Ekhaya” bese ukhetha “Izitayela Zeseli”.
- Chofoza kwesokudla kwisitayela ofuna ukusihlela bese uchofoza okuthi Hlela.
- Iwindi leSitayela liyavuleka.
- Chofoza okuthi “Fometha” futhi efasiteleni elibonisiwe “Fometha Amaseli” lungisa ukufometha. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".
- Chofoza okuthi KULUNGILE futhi ukuze uvale ibhokisi Lesitayela. Ukuhlelwa kwesitayela esiqediwe kuqediwe, manje kungasetshenziswa ezintweni zedokhumenti.
Ukudlulisa Izitayela Kwenye Incwadi
Kubalulekile! Isitayela esidaliwe singasetshenziswa kuphela kudokhumenti esakhiwe kuyo, kodwa kukhona isici esikhethekile esikuvumela ukuthi udlulisele izitayela kwamanye amadokhumenti.
Ukuhamba ngezinyawo:
- Sidabula idokhumenti lapho izitayela ezidaliwe zitholakala khona.
- Ukwengeza, vula enye idokhumenti lapho sifuna ukudlulisa khona isitayela esidaliwe.
- Kudokhumenti enezitayela, hamba kuthebhu ethi “Ekhaya” futhi uthole ibhulokhi elithi “Izitayela Zeseli”.
- Chofoza "Hlanganisa". Iwindi elibizwa ngokuthi "Hlanganisa Izitayela" livele.
- Leli windi liqukethe uhlu lwawo wonke amadokhumenti esipredishithi avuliwe. Khetha idokhumenti ofuna ukudlulisa kuyo isitayela esidaliwe bese uchofoza inkinobho ethi "KULUNGILE". Ilungile!
Isiphetho
Kunenombolo enkulu yezindlela ezikuvumela ukuthi uhlele ifomethi yeseli kuspredishithi. Ngenxa yalokhu, umuntu ngamunye osebenza ohlelweni angazikhethela indlela elula yokuxazulula izinkinga ezithile.