Njira zitatu Zosinthira Khalidwe mu Excel 3, 2013 ndi 2010

M'nkhaniyi, ndikufuna kukuuzani za njira zingapo zosinthira zilembo za Excel kuchokera kumtunda kupita kumunsi kapena momwe mungatchulire liwu lililonse. Mudzaphunzira momwe mungachitire ndi ntchito zoterezi mothandizidwa ndi ntchito WOPEREKA и Ocheperako, pogwiritsa ntchito VBA macros, komanso kugwiritsa ntchito Microsoft Word.

Vuto ndilakuti Excel sipereka chida chapadera chosinthira mawu pamasamba. Zikadali chinsinsi chifukwa chake Microsoft idapatsa Mawu mawonekedwe amphamvu chotere ndipo sanawonjeze ku Excel. Izi zipangitsa kuti ntchito zambiri zikhale zosavuta kwa ogwiritsa ntchito ambiri. Koma musathamangire kulembanso mwachangu zolemba zonse patebulo lanu pamanja! Mwamwayi, pali njira zina zabwino zosinthira zilembo zama cell kukhala zilembo zazikulu kapena zochepa, kapena kukweza liwu lililonse. Ndiroleni ndikugawireni njira izi.

• Excel imagwira ntchito kuti isinthe zolemba
• Sinthani mawu olembetsa pogwiritsa ntchito Microsoft Word
• Chosinthika chosinthika pogwiritsa ntchito VBA macro

Excel imagwira ntchito kuti isinthe zolemba

Microsoft Excel ili ndi zinthu zitatu zazikulu zomwe mungagwiritse ntchito kusintha mawu. izo Chapamwamba (WOLENDEDWA), Ocheperako (PASI) ndi ZOFUNIKA (PROPANACH).

• ntchito Chapamwamba (UPPER) amasintha zilembo zonse zazing'ono kukhala zazikulu.
• ntchito Ocheperako (LOWER) imapangitsa zilembo zonse zazikulu kukhala zochepa.
• ntchito ovomerezaVia (ZOYENERA) amalemba zilembo zazikulu chilembo choyamba cha liwu lililonse ndikuchepetsa ena onse.

Zonse zitatuzi zimagwira ntchito mofanana, kotero ndikuwonetsani momwe imodzi mwa izo imagwirira ntchito. Tiyeni titenge ntchitoyi monga chitsanzo Chapamwamba (OLENGEDWA):

Kulemba fomula mu Excel

0. Ikani ndime yatsopano (yothandizira) pafupi ndi yomwe ili ndi mawu omwe mukufuna kusintha.

Zindikirani: Sitepe iyi ndi yosankha. Ngati tebulo silili lalikulu, mutha kugwiritsa ntchito gawo lililonse loyandikira lopanda kanthu.

0. 
1. Lowetsani chizindikiro chofanana (=) ndi dzina lantchito Chapamwamba (UPPER) kupita ku selo yoyandikana ndi gawo latsopano (B3).
2. M'mabulaketi pambuyo pa dzina lachidziwitso, lowetsani kalata yoyenera ya selo (C3). Fomula yanu iyenera kuwoneka motere:

   =UPPER(C3)

   =ПРОПИСН(C3)

   kumene C3 ndi cell yokhala ndi mawu oti atembenuzidwe.

   

3. Press Lowani.Chithunzi pamwambapa chikuwonetsa kuti mu cell B3 ili ndi mawu ofanana ndi in C3, m’zilembo zazikulu zokha.

Lembani fomula pansi pamzati

Tsopano muyenera kukopera fomula ku ma cell ena othandizira:

4. Sankhani selo ndi fomula.
5. Yendetsani cholozera cha mbewa yanu pamalopo ang'onoang'ono (chizindikiro chodzaza zokha) kumunsi kumanja kwa selo losankhidwa kuti cholozeracho chisanduke mtanda wawung'ono wakuda.
6. Dinani ndikugwira batani lakumanzere la mbewa ndikukokera fomula m'maselo onse komwe mukufuna kuyikopera.
7. Tulutsani batani la mbewa.

Zindikirani: Ngati mukufuna kudzaza ndime yatsopano (mpaka kutalika kwa tebulo), ndiye kuti mutha kudumpha masitepe 5-7 ndikungodinanso kawiri pa cholembera.

Kuchotsa gawo lothandizira

Chifukwa chake, muli ndi mizati iwiri yokhala ndi zolemba zomwezo, zomwe zimasiyana pokhapokha. Ndikuganiza kuti mukufuna kusiya gawoli ndi njira yomwe mukufuna. Tiyeni titengere zomwe zili pagulu la othandizira ndikuzichotsa.

8. Sankhani maselo omwe ali ndi fomula ndikudina Ctrl + Ckuwakopera iwo.
9. Dinani kumanja pa selo yoyamba mugawo loyambirira.
10. Mu nkhani menyu pansi Ikani Zosankha (Matani Mungasankhe) sankhani Makhalidwe (Makhalidwe).Popeza timangofunikira zolemba zokha, tidzasankha izi kuti tipewe zolakwika m'mawu mtsogolo.
11. Dinani kumanja pa selo iliyonse ya gawo lothandizira ndikusankha lamulo kuchokera pamenyu yankhani Chotsani (Chotsani).
12. Mu dialog box Chotsani (Chotsani Maselo) sankhani njira Gawo lonse (Column) ndikudina OK.

Zachitika!

Mwachidziwitso, izi zingawoneke zovuta kwambiri. Pumulani ndikuyesera njira zonsezi nokha. Mudzawona kuti kusintha nkhani ndi ntchito za Excel sikovuta konse.

Sinthani nkhani ya zolemba mu Excel pogwiritsa ntchito Microsoft Word

Ngati simukufuna kusokoneza ndi mafomula mu Excel, mutha kusintha nkhani mu Mawu. Umu ndi momwe njira iyi imagwirira ntchito:

1. Sankhani mtundu womwe uli patsamba la Excel lomwe mukufuna kusintha mawuwo.
2. Press Ctrl + C kapena dinani kumanja ndikusankha lamulo kuchokera pamenyu yankhani Koperani (Koperani).
3. Pangani chikalata chatsopano cha Mawu.
4. Press Ctrl + V kapena dinani kumanja pa tsamba lopanda kanthu ndikusankha lamulo kuchokera pamenyu yankhani phala (Ikani). Tebulo la Excel lidzakopera ku Mawu.
5. Sankhani mawu omwe mukufuna kusintha.
6. Pa Advanced tabu Kunyumba (Kunyumba) mu gawo Zilembo (Font) dinani chizindikiro Sinthani Mlandu (Register).
7. Sankhani imodzi mwazosankha za 5 kuchokera pamndandanda wotsitsa.

Zindikirani: Kuphatikiza apo, mutha kukanikiza kuphatikiza Shift + F3mpaka sitayilo yomwe mukufuna itakhazikitsidwa. Ndi makiyi awa, mutha kusankha zilembo zazikulu ndi zazing'ono zokha, komanso nkhani ngati ziganizo.

Tsopano muli ndi tebulo mu Mawu ndi nkhani yosinthidwa. Ingojambulani ndikuyiyika pamalo ake enieni ku Excel.

Sinthani zolemba ndi VBA macro

Mukhozanso kugwiritsa ntchito VBA macros mu Excel 2010 ndi 2013. Osadandaula ngati chidziwitso chanu cha VBA chimasiya zambiri. Sindinadziwe zambiri za izi nthawi yapitayo, ndipo tsopano nditha kugawana ma macros atatu osavuta omwe amasintha mawu kukhala zilembo zazikulu, zilembo zazing'ono, kapena zilembo zazikulu liwu lililonse.

Sindidzachoka pamutuwu ndikukuuzani momwe mungayikitsire ndikuyendetsa nambala ya VBA mu Excel, monga izi zikufotokozedwa modabwitsa m'nkhani zina patsamba lathu. Ndingowonetsa macros omwe mutha kukopera ndikumata mu bukhu lanu.

• Ngati mukufuna kusintha mawu kukhala zilembo zazikulu, gwiritsani ntchito VBA macro:

Sub Uppercase() Pa Cell Iliyonse Mukusankha Ngati Si Cell.HasFormula Ndiye Cell.Value = UCase(Cell.Value) End If Next Cell End Sub

• Kuti mugwiritse ntchito zilembo zazing'ono pa data yanu, gwiritsani ntchito nambala yomwe ili pansipa:

Kalasi kakang'ono () Pa Cell Iliyonse Mukusankha Ngati Si Cell.HasFormula Ndiye Cell.Value = LCase(Cell.Value) End If Next Cell End Sub

• Nayi macro yomwe ipangitsa kuti mawu onse omwe ali m'mawuwo ayambe ndi chilembo chachikulu:

Sub Propercase() Pa Cell Iliyonse Mukusankha Ngati Si Cell.HasFormula Ndiye Cell.Value = _ Application _ .WorksheetFunction _ .Proper(Cell.Value) End If Next Cell End Sub

Ndikukhulupirira kuti tsopano popeza mukudziwa njira zingapo zosinthira nkhani mu Excel, ntchitoyi ikhala yosavuta kwa inu. Ntchito za Excel, Microsoft Word, VBA macros nthawi zonse zimagwira ntchito yanu. Patsala pang'ono kuti muchite - sankhani zida zomwe mumakonda kwambiri.