Ungawenza kanjani umbhalo ku-Excel

Enqubweni yokusebenza ekwakhiweni okubonakalayo kombhalo kumathebula e-Excel, ngokuvamile kuyadingeka ukugqamisa lokhu noma lolo lwazi. Lokhu kufezwa ngokulungisa amapharamitha afana nohlobo lwefonti, usayizi wayo, umbala, ukugcwalisa, ukudwebela, ukuqondanisa, ifomethi, njll. Amathuluzi adumile aboniswa kuribhoni yohlelo ukuze ahlale eseduze. Kodwa kunezinye izici ezingadingeki kaningi, kodwa kuyasiza ukwazi ukuthi ungazithola kanjani futhi uzisebenzise uma uzidinga. Lokhu kufaka phakathi, isibonelo, umbhalo we-strikethrough. Kulesi sihloko, sizobona ukuthi ungakwenza kanjani lokhu ku-Excel.

Indlela 1: Shaya Ngeseli Lonke

Ukuze sifinyelele lo mgomo, sinamathela ohlelweni lokusebenza olulandelayo:

1. Nganoma iyiphi indlela elula, khetha iseli (noma indawo yamaseli), okuqukethwe esifuna ukukukhipha. Bese uchofoza kwesokudla kokukhethiwe bese ukhetha into ohlwini lokudonsela phansi "Ifomethi Yeseli". Ungakwazi futhi ukucindezela isinqamuleli sekhibhodi esikhundleni salokho Ctrl + 1 (ngemuva kokukhethwa).
2. Iwindi lefomethi lizovela esikrinini. Ishintshela kuthebhu "Ifonti" kubhulokhi yepharamitha "Shintsha" thola inketho "weqiwe", yimaka bese uchofoza OK.
3. Ngenxa yalokho, sithola umbhalo we-strikethrough kuwo wonke amaseli akhethiwe.

Indlela yesi-2: Ukweqa igama elilodwa (ucezu)

Indlela echazwe ngenhla ifanelekile ezimeni lapho ufuna ukweqa konke okuqukethwe kweseli (uhlu lwamaseli). Uma udinga ukweqa izingcezu ngazinye (amagama, izinombolo, izimpawu, njll.), landela lezi zinyathelo ezingezansi:

1. Chofoza kabili kuseli noma ubeke ikhesa kuyo bese ucindezela inkinobho F2. Kuzo zombili izimo, imodi yokuhlela iyasebenza, ezosivumela ukuthi sikhethe ingxenye yokuqukethwe esifuna ukusebenzisa kukho ukufometha, okuyi-strikethrough.Njengendlela yokuqala, ngokuchofoza kwesokudla ekukhethweni, sivula imenyu yokuqukethwe, lapho sikhetha khona into - "Ifomethi Yeseli".Qaphela: ukukhetha kungenziwa futhi kubha yefomula ngokuqala ngokukhetha iseli oyifunayo. Kulokhu, imenyu yokuqukethwe icelwa ngokuchofoza isiqeshana esikhethiwe kulo mugqa othile.
2. Singaqaphela ukuthi iwindi lokufometha kweseli elivulekayo ngalesi sikhathi liqukethe ithebhu eyodwa kuphela "Ifonti", okuyikhona esikudingayo. Lapha sifaka futhi ipharamitha "weqiwe" bese uchofoza OK.
3. Ingxenye ekhethiwe yokuqukethwe kweseli isinqatshiwe. Chofoza Fakaukuqedela inqubo yokuhlela.

Indlela yesi-3: Sebenzisa Amathuluzi ku-Ribbon

Kuribhoni yohlelo, kukhona nenkinobho ekhethekile ekuvumela ukuthi ungene efasiteleni lokufometha kweseli.

1. Okokuqala, sikhetha iseli/ingxenye yokuqukethwe kwayo noma uhla lwamaseli. Bese kuba kuthebhu eyinhloko eqenjini lamathuluzi "Ifonti" chofoza isithonjana esincane esinomcibisholo obheke phansi ngokudayagonali.
2. Kuye ngokuthi yikuphi okukhethiwe, iwindi lokufometha lizovuleka - kungaba ngawo wonke amathebhu, noma ngeyodwa ("Ifonti"). Ezinye izenzo zichazwe ezigabeni ezifanele ezingenhla.

Indlela yesi-4: ama-hotkeys

Imisebenzi eminingi ku-Excel ingaqalwa kusetshenziswa izinqamuleli zekhibhodi ezikhethekile, futhi umbhalo wokudlulela nawo uyafana. Okufanele ukwenze nje ucindezela inhlanganisela Ctrl + 5, ngemva kokukhethwa.

Indlela, yiqiniso, ingabizwa ngokuthi esheshayo futhi ekhululekile kakhulu, kodwa kulokhu udinga ukukhumbula le nhlanganisela eyisihluthulelo.

Isiphetho

Ngaphandle kweqiniso lokuthi umbhalo we-strikethrough awudumile njengokuthi, ngokwesibonelo, ugqamile noma u-ithalikhi, kwesinye isikhathi uyadingeka ukuze kwethulwe ikhwalithi yolwazi kumathebula. Kunezindlela eziningi zokubhekana nomsebenzi, futhi umsebenzisi ngamunye angakhetha okubonakala kumlungele kakhulu ukuthi ayisebenzise.