Yadda ake canza harka a cikin Excel 2016, 2013 ko 2010

Yawancin masu amfani da Excel suna fuskantar matsaloli saboda rashin iya canza yanayin rubutu da sauri a cikin takaddun aiki. Don wasu dalilai, Microsoft kawai ya ƙara wannan fasalin zuwa Word kuma ya bar Excel ba tare da shi ba. Amma wannan baya nufin cewa kana buƙatar canza rubutu da hannu a kowace tantanin halitta - akwai gajerun hanyoyi da yawa. Uku daga cikinsu za a bayyana a kasa.

Ayyuka na musamman na Excel

A cikin Excel, akwai ayyuka waɗanda ke nuna rubutu a cikin wani yanayi daban- HUKUNCI (), KASA () и prop(). Na farko daga cikinsu yana fassara duk rubutu zuwa manyan baƙaƙe, na biyu - zuwa ƙananan haruffa, na uku yana jujjuya haruffan farko kawai zuwa manyan baƙaƙe, sauran suna barin ƙananan haruffa. Dukkansu suna aiki akan ka'ida ɗaya, don haka, ta yin amfani da ɗaya azaman misali - bari ya kasance HUKUNCI () – za ka iya ganin yadda ake amfani da dukan uku.

Shigar da dabara

1. Ƙirƙiri sabon shafi kusa da wanda kake son gyarawa, ko kuma idan ya dace, kawai yi amfani da ginshiƙi mara komai kusa da tebur.

2. Shigar da alamar daidai (=) sannan sunan aiki (MULKI) a cikin tantanin halitta kusa da saman-mafi yawan sel rubutun da ake iya gyarawa.

A cikin baka bayan sunan aikin, rubuta sunan tantanin halitta da ke kusa da rubutu (a cikin hoton da ke ƙasa, wannan shine cell C3). Tsarin tsari zai yi kama = PROPISN(C3).

4. Hit Shiga.

Cell B3 yanzu ya ƙunshi rubutun cell C3 a cikin babban harafi.

Kwafi dabarar zuwa ƙananan sel na ginshiƙi

Yanzu ana iya amfani da wannan dabarar zuwa wasu sel a cikin ginshiƙi.

5. Zaɓi tantanin halitta mai ɗauke da dabara.
6. Matsar da siginan kwamfuta zuwa ƙananan murabba'i (cika alamar), wanda yake a kasan dama na tantanin halitta - kibiya mai siginar ya kamata ta juya zuwa giciye.

7. Tsayawa maɓallin linzamin kwamfuta danna, ja siginan kwamfuta zuwa ƙasa don cika duk sel ɗin da ake buƙata - za a kwafi dabarar a cikinsu.
8. Saki maɓallin linzamin kwamfuta.

Idan kana buƙatar cika dukkan sel na ginshiƙi zuwa gefen ƙasa na tebur, kawai shawagi kan alamar cika kuma danna sau biyu.

Cire ginshiƙin taimako

Yanzu akwai ginshiƙai biyu masu rubutu iri ɗaya a cikin sel, amma a yanayi daban-daban. Don ajiye ɗaya kawai, kwafi bayanan daga ginshiƙi mai taimako, liƙa a cikin ginshiƙi da ake so, sannan share mataimaki.

1. Zaɓi sel ɗin da ke ɗauke da dabara kuma danna Ctrl + C.

2. Danna-dama a farkon sel tare da rubutun da ake so a cikin ginshiƙin gyarawa.
3. A ƙarƙashin "manna zaɓuɓɓuka" zaɓi gunkin Da dabi'u a cikin mahallin menu.

4. Dama danna kan ginshiƙin taimako kuma zaɓi cire.
5. A cikin akwatin maganganu da ya bayyana, zaɓi Gaba ɗaya Rukunin. 

Yanzu an gama komai.

Bayanin na iya zama kamar rikitarwa. Amma kawai bi matakan da aka bayar za ku ga cewa babu wani abu mai wahala a ciki.

Gyara rubutu ta amfani da Microsoft Word

Idan ba kwa son yin rikici tare da dabaru a cikin Excel, zaku iya amfani da umarnin don canza harka a cikin Kalma. Bari mu ga yadda yake aiki.

1. Zaɓi sel ɗin da kuke son yin canje-canje gare su.
2. Aikace -aikace Ctrl + C ko danna dama akan yankin da aka zaɓa kuma zaɓi Copy a cikin mahallin menu.

3. Bude sabon takarda a cikin Word.
4. latsa Ctrl + V ko danna dama akan takardar kuma zaɓi Saka.

Yanzu kwafin teburin ku yana cikin takaddar Word.

5. Zaɓi waɗannan sel ɗin tebur inda kake son canza yanayin rubutun.
6. Danna gunki Yi rijista, wanda ke cikin rukunin font cikin tab Gida.
7. Zaɓi ɗaya daga cikin zaɓuɓɓukan shari'o'i guda biyar daga jerin zaɓuka.

Hakanan zaka iya zaɓar rubutu da nema Canji + F3 har sai rubutun yayi daidai. Ta wannan hanyar, zaku iya zaɓar zaɓin yanayi guda uku kawai - babba, ƙarami da shari'ar Jumla (wanda kowace jumla ta fara da babban harafi, sauran haruffan ƙananan haruffa ne).

Yanzu da rubutun da ke cikin tebur yana cikin sigar da ake so, zaku iya kwafa shi kawai zuwa cikin Excel.

Neman VBA macros

Don Excel 2010 da 2013, akwai wata hanya don canza zaɓuɓɓukan rubutu - VBA macros. Yadda ake saka lambar VBA a cikin Excel kuma sanya shi aiki batu ne na wani labarin. Anan, kawai shirye-shiryen macros waɗanda za a iya sakawa za a nuna.

Kuna iya amfani da macro mai zuwa don canza rubutu zuwa babban harafi:

Babban Babba()

    Ga Kowacce Cell A Zabi

        Idan Ba ​​Cell.HasFormula Sai

            Cell.Value = UCase(Cell.Value)

        Ƙare Idan

    Cell na gaba

karshen Sub

Don ƙarami, wannan lambar za ta yi:

Karamin Harafi()

    Ga Kowacce Cell A Zabi

        Idan Ba ​​Cell.HasFormula Sai

            Cell.Value = LCase(Cell.Value)

        Ƙare Idan

    Cell na gaba

karshen Sub

Macro don sa kowace kalma ta fara da babban harafi:

Ƙarƙashin Ƙarfafawa ()

    Ga Kowacce Cell A Zabi

        Idan Ba ​​Cell.HasFormula Sai

            Cell.Value = _

            Aikace-aikace _

            .Aikin aiki _

            Dace (Cell.Value)

        Ƙare Idan

    Cell na gaba

karshen Sub

Yanzu kun san yadda zaku iya canza yanayin rubutu a cikin Excel. Kamar yadda kake gani, wannan ba haka ba ne mai wahala, kuma babu ko da hanya ɗaya don yin shi - wanne daga cikin hanyoyin da ke sama ya fi kyau ya rage naka.