Hanyoyi 3 don Canja Harkar Hali a cikin Excel 2013, 2010 da 2007

A cikin wannan labarin, Ina so in gaya muku game da hanyoyi da yawa don canza yanayin haruffa a cikin Excel daga babba zuwa ƙasa ko kuma yadda ake yin babban girman kowace kalma. Za ku koyi yadda ake magance irin waɗannan ayyuka tare da taimakon ayyuka MULKI и KARANTA, ta amfani da VBA macros, da kuma amfani da Microsoft Word.

Matsalar ita ce Excel baya samar da kayan aiki na musamman don canza yanayin rubutu akan takardar aiki. Ya zama abin ban mamaki dalilin da ya sa Microsoft ya ba Word irin wannan fasalin mai ƙarfi kuma bai ƙara shi zuwa Excel ba. Wannan zai sauƙaƙa ayyuka da yawa ga yawancin masu amfani. Amma kada ku yi gaggawar sake buga duk bayanan rubutu na teburinku da hannu! Sa'ar al'amarin shine, akwai wasu hanyoyi masu kyau don canza kimar rubutu a cikin sel zuwa babba ko ƙarami, ko ƙara girman kowace kalma. Bari in raba muku wadannan hanyoyin.

• Ayyukan Excel don canza yanayin rubutu
• Canza rubutun rajista ta amfani da Microsoft Word
• Harka mai canzawa ta amfani da VBA macro

Ayyukan Excel don canza yanayin rubutu

Microsoft Excel yana da manyan siffofi guda uku waɗanda za ku iya amfani da su don canza yanayin rubutu. shi SAURARA (AN RIJITA), KARANTA (KASASHE) da DACEWA (FADAKARWA).

• aiki SAURARA (BAMA) yana canza duk ƙananan haruffa zuwa manyan haruffa.
• aiki KARANTA (LOWER) yana sanya duk manyan haruffa ƙananan haruffa.
• aiki PROvia (PROPER) yana ƙara girman harafin farko na kowace kalma sannan ya rage sauran.

Duk waɗannan ayyukan guda uku suna aiki iri ɗaya, don haka zan nuna muku yadda ɗayansu yake aiki. Bari mu dauki aikin a matsayin misali SAURARA (AN RAJITA):

Shigar da dabara a cikin Excel

0. Saka sabon ginshiƙi (mataimaki) kusa da wanda ke ɗauke da rubutun da kake son juyawa.

lura: Wannan mataki na zaɓi ne. Idan tebur bai yi girma ba, zaku iya amfani da kowane ginshiƙi mara komai a kusa.

0. 
1. Shigar da alamar daidai (=) da sunan aiki SAURARA (BAMA) zuwa tantanin da ke kusa da sabon shafi (B3).
2. A cikin maɓalli bayan sunan aikin, shigar da ma'anar tantanin halitta mai dacewa (C3). Ya kamata tsarin tsarin ku ya yi kama da haka:

   =UPPER(C3)

   =ПРОПИСН(C3)

   inda C3 ita ce tantanin halitta tare da rubutun da za a canza.

   

3. latsa Shigar.Hoton da ke sama yana nuna hakan a cikin tantanin halitta B3 ya ƙunshi rubutu iri ɗaya kamar a ciki C3, a manyan haruffa kawai.

Kwafi dabarar ƙasa da ginshiƙi

Yanzu kuna buƙatar kwafin dabarar zuwa sauran ƙwayoyin ginshiƙan taimako:

4. Zaɓi tantanin halitta tare da dabara.
5. Juya alamar linzamin kwamfutanku akan ƙaramin murabba'i (alama ta atomatik) a cikin ƙananan kusurwar dama na zaɓin tantanin halitta domin mai nuni ya juya zuwa ƙaramin giciye baƙar fata.
6. Danna kuma ka riƙe maɓallin linzamin kwamfuta na hagu sannan ka ja dabarar ƙasa ta duk sel inda kake son kwafi shi.
7. Saki maɓallin linzamin kwamfuta.

lura: Idan kuna buƙatar cika sabon shafi (zuwa cikakken tsayin tebur), to zaku iya tsallake matakai 5-7 kuma kawai danna sau biyu akan alamar autofill.

Cire ginshiƙin taimako

Don haka, kuna da ginshiƙai biyu tare da bayanan rubutu iri ɗaya, waɗanda suka bambanta kawai idan akwai. Ina ɗauka cewa kuna son barin ginshiƙi tare da zaɓin da ake so kawai. Bari mu kwafi dabi'u daga ginshiƙin taimako kuma mu rabu da shi.

8. Zaɓi sel ɗin da ke ɗauke da dabara kuma danna Ctrl + Cdon kwafa su.
9. Danna-dama akan tantanin halitta na farko a cikin asalin ginshiƙi.
10. A cikin mahallin menu a ƙarƙashin Manna Zabuka (Zaɓuɓɓukan Manna) zaɓi dabi'u (Dabi'u).Tun da muna buƙatar ƙimar rubutu kawai, za mu zaɓi wannan zaɓi don guje wa kurakurai a cikin ƙididdiga a nan gaba.
11. Danna-dama akan kowane tantanin halitta na ginshiƙin taimako kuma zaɓi umarni daga menu na mahallin share (Share).
12. A cikin akwatin maganganu share (Share Sel) zaɓi wani zaɓi Gaba ɗaya shafi (Shafi) kuma danna OK.

Anyi!

A ka'ida, wannan na iya zama kamar rikitarwa. Huta kuma gwada duk waɗannan matakan da kanku. Za ku ga cewa canza harka tare da ayyukan Excel ba shi da wahala ko kaɗan.

Canza yanayin rubutu a cikin Excel ta amfani da Microsoft Word

Idan baku son yin rikici tare da dabaru a cikin Excel, zaku iya canza harka a cikin Word. Ga yadda wannan hanyar ke aiki:

1. Zaɓi kewayon kan takardar aikin Excel wanda a ciki kake son canza harka rubutu.
2. latsa Ctrl + C ko danna dama kuma zaɓi umarnin daga menu na mahallin Copy (Kwafi).
3. Ƙirƙiri sabon takaddar Kalma.
4. latsa Ctrl + V ko danna dama akan wani shafi mara komai kuma zaɓi umarni daga menu na mahallin kuje (Saka). Za a kwafi teburin Excel zuwa Word.
5. Zaɓi rubutun da kuke son canza harka.
6. A kan Babba shafin Gida (Gida) a cikin sashin font (Font) danna icon Canza Harka (yi rijista).
7. Zaɓi ɗayan zaɓuɓɓukan shari'o'i 5 daga jerin abubuwan da aka saukar.

lura: Bugu da kari, za ka iya danna hade Canji + F3har sai an saita salon da ake so. Tare da waɗannan maɓallan, zaku iya zaɓar babba da ƙarami kawai, da harka kamar cikin jimloli.

Yanzu kuna da tebur a cikin Word tare da canjin rubutu. Kawai kwafa shi kuma manna shi a ainihin inda yake a cikin Excel.

Canja harafin rubutu tare da macro VBA

Hakanan zaka iya amfani da macros VBA a cikin Excel 2010 da 2013. Kada ku damu idan ilimin ku na VBA ya bar abin da ake so. Ban san da yawa game da wannan ko wani ɗan lokaci ba, kuma yanzu zan iya raba sauƙaƙan macros guda uku waɗanda ke canza yanayin rubutu zuwa babban baƙaƙe, ƙarami, ko ƙara girman kowace kalma.

Ba zan yi watsi da batun ba kuma in gaya muku yadda ake sakawa da gudanar da lambar VBA a cikin Excel, kamar yadda aka kwatanta wannan da ban mamaki a cikin wasu labaran kan rukunin yanar gizon mu. Zan kawai nuna macro cewa zaku iya kwafa da liƙa a cikin littafinku.

• Idan kana son canza rubutu zuwa babban harafi, yi amfani da macro na VBA mai zuwa:

Karamin Babba() Ga Kowacce Cell A Zabi Idan Ba ​​Cell.HasFormula Sai Cell.Value = UCase(Cell.Value) Ƙarshe Idan Na Gaba Ƙarshen Ƙarshen Ƙarshen

• Don amfani da ƙananan haruffa zuwa bayanan ku, yi amfani da lambar da aka nuna a ƙasa:

Karamin Harafi() Ga Kowacce Cell A Zabi Idan Ba ​​Cell.HasFormula Sai Cell.Value = LCase(Cell.Value) Karshen Idan Na Gaba Ƙarshen Ƙarshen Ƙarshen Ƙarshen

• Ga macro wanda zai sa duk kalmomin da ke cikin rubutun su fara da babban harafi:

Sub Propercase() Ga Kowacce Cell A Zabi Idan Ba ​​Cell.HasFormula Sai Cell.Value = _ Application _ .WorksheetFunction _ .Proper(Cell.Value) Ƙarshen Idan Na Gaba Ƙarshen Ƙarshen Ƙarshen Ƙarshe

Ina fatan cewa yanzu da kuka san wasu manyan dabaru don canza shari'ar a cikin Excel, wannan aikin zai kasance da sauƙi a gare ku. Ayyukan Excel, Microsoft Word, VBA macros koyaushe suna cikin sabis ɗin ku. Akwai kaɗan kaɗan da za ku yi - yanke shawara daga cikin waɗannan kayan aikin da kuka fi so.