Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey

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:

  1. Okuvamile.
  2. Ezezimali.
  3. Okwezinombolo.
  4. Ezezimali.
  5. Umbhalo.
  6. Usuku.
  7. Isikhathi.
  8. Okuncane.
  9. Iphesenti.
  10. Imininingwane engeziwe

Amanye amafomethi anezinhlobo zawo ezingaphansi ezengeziwe. Kunezindlela eziningana zokushintsha ifomethi. Ake sihlaziye ngayinye ngokuningiliziwe.

Indlela 1: imenyu yokuqukethwe

Ukusebenzisa imenyu yokuqukethwe ukuhlela ifomethi kungenye yezindlela ezisetshenziswa kakhulu. Ukuhamba ngezinyawo:

  1. Udinga ukukhetha lawo maseli ofuna ukuhlela ifomethi yawo. Sichofoza kubo ngenkinobho yegundane engakwesokudla. Imenyu yokuqukethwe ekhethekile ivuliwe. Chofoza into ethi “Fometha Amaseli …”.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
1
  1. 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".
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
2
  1. 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:

  1. Senza ukushintshela esigabeni "Ekhaya". Okulandelayo, khetha iseli oyifunayo noma uhla lwamaseli bese uvula ibhokisi lokukhetha kubhulokhi elithi “Inombolo”.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
3
  1. Izinketho zefomethi eyinhloko zidaluliwe. Khetha oyidingayo endaweni ekhethiwe. Ukufometha kushintshile.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
4
  1. Kufanele kuqondwe ukuthi lolu hlu luqukethe kuphela izakhiwo eziyinhloko. Ukuze unwebe lonke uhlu, udinga ukuchofoza "Amanye amafomethi ezinombolo".
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
5
  1. Ngemva kokuchofoza lesi sici, iwindi elijwayelekile lizovela nazo zonke izinketho zokufometha ezingaba khona (okuyisisekelo nokungeziwe).
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
6

Indlela yesi-3: “Amaseli” ibhokisi lamathuluzi

Indlela yokuhlela elandelayo yefomethi yenziwa ngebhulokhi "Amaseli". Ukuhamba:

  1. 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 …”.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
7
  1. 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.

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
8

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:

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
9

Senza izenzo ezifanayo ngekholomu yesithathu neyesine. Setha lawo mafomethi kanye nezinhlobo zokubonisa ezihambisana namagama ekholomu adaluliwe. Kunamasistimu wokubonisa amadethi ama-2 kusipredishithi:

  1. Inombolo 1 nguJanuwari 1, 1900.
  2. Inombolo engu-0 inguJanuwari 1, 1904, futhi inombolo engu-1 ingu-02.01.1904/XNUMX/XNUMX.

Ukushintsha ukuboniswa kwezinsuku kwenziwa kanje:

  1. Asiye kokuthi “Ifayela”.
  2. Chofoza okuthi “Izinketho” bese uye engxenyeni ethi “Okuthuthukisiwe”.
  3. 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.

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
10

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:

  1. Indlela yokuqala. Khetha iseli, iya engxenyeni ethi “Ekhaya” bese ukhetha into ethi “Ifonti”. Uhlu luyavuleka lapho umsebenzisi ngamunye engazikhethela ifonti efanelekile.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
11
  1. Indlela yesibili. Khetha iseli, chofoza kwesokudla kuyo. Imenyu yokuqukethwe iyavezwa, futhi ngaphansi kwayo kunefasitela elincane elikuvumela ukuthi ufomethe ifonti.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
12
  1. 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.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
13

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:

  1. Ukusebenzisa izinhlanganisela eziyinhloko:
  • Ctrl+B - ngokugqamile;
  • U-Ctrl+I – italic;
  • Ctrl+U - kudwetshelwe;
  • I-Ctrl + 5 - inqanyuliwe;
  • Ctrl+= – umbhalo ophansi;
  • Ctrl+Shift++ – umbhalo ongenhla.
  1. Ukusebenzisa amathuluzi atholakala kubhulokhi ethi “Ifonti” kuthebhu ethi “Ekhaya”.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
14
  1. Ukusebenzisa ibhokisi elithi Fometha Amaseli. Lapha ungasetha izilungiselelo ozifunayo esigabeni esithi "Lungisa" kanye "Nesibhalo".
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
15

Iqondanisa umbhalo kumaseli

Ukuqondanisa umbhalo kumaseli kwenziwa ngezindlela ezilandelayo:

  • Iya engxenyeni ethi "Ukuqondanisa" yesigaba "Ekhaya". Lapha, ngosizo lwezithonjana, ungaqondanisa idatha.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
16
  • Ebhokisini elithi “Fometha Amaseli”, yiya engxenyeni ethi “Ukuqondanisa”. Lapha ungaphinda ukhethe zonke izinhlobo ezikhona zokuqondanisa.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
17

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:

  1. 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.
  2. 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.

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
18

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:

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
19

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.

Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
20

Kungani Kudingeka Izitayela Eziqanjiwe

Izinjongo eziyinhloko zokusebenzisa izitayela:

  1. Dala amasethi esitayela ahlukile ukuze uhlele izihloko, izihlokwana, umbhalo, nokuningi.
  2. Ukusebenzisa izitayela ezidaliwe.
  3. 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:

  1. Iya kuthebhu ethi “Ekhaya”, thola ibhulokhi elithi “Izitayela Zeseli”.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
21
  1. Umtapo wezincwadi wezitayela ezilungile uboniswa esikrinini.
  2. Khetha iseli oyifunayo bese uchofoza isitayela osithandayo.
  3. 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:

  1. Khetha noma iyiphi iseli bese uyifometha. Sizodala isitayela esisuselwe kulokhu kufometha.
  2. Yiya engxenyeni ethi “Ekhaya” bese udlulela kubhulokhi elithi “Izitayela Zeseli”. Chofoza okuthi “Dala Isitayela Seseli”. Iwindi elibizwa ngokuthi “Isitayela” liyavuleka.
Ungashintsha kanjani ifomethi yeseli ku-Excel. Ngemenyu yokuqukethwe, amathuluzi nama-hotkey
22
  1. Faka noma yiliphi “Igama Lesitayela”.
  2. Sibeka yonke imingcele edingekayo ofuna ukuyifaka kwisitayela esidaliwe.
  3. Sichofoza "OK".
  4. Manje isitayela sakho esiyingqayizivele sengeziwe kumtapo wezincwadi wesitayela, ongasetshenziswa kulo mbhalo.

Ukushintsha Izitayela Ezikhona

Izitayela esezilungile ezitholakala kulabhulali zingashintshwa ngokuzimela. Ukuhamba:

  1. Yiya engxenyeni ethi “Ekhaya” bese ukhetha “Izitayela Zeseli”.
  2. Chofoza kwesokudla kwisitayela ofuna ukusihlela bese uchofoza okuthi Hlela.
  3. Iwindi leSitayela liyavuleka.
  4. Chofoza okuthi “Fometha” futhi efasiteleni elibonisiwe “Fometha Amaseli” lungisa ukufometha. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".
  5. 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:

  1. Sidabula idokhumenti lapho izitayela ezidaliwe zitholakala khona.
  2. Ukwengeza, vula enye idokhumenti lapho sifuna ukudlulisa khona isitayela esidaliwe.
  3. Kudokhumenti enezitayela, hamba kuthebhu ethi “Ekhaya” futhi uthole ibhulokhi elithi “Izitayela Zeseli”.
  4. Chofoza "Hlanganisa". Iwindi elibizwa ngokuthi "Hlanganisa Izitayela" livele.
  5. 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.

shiya impendulo