Canza dukkan haruffa zuwa babban inan wasan a Microsoft Excel

A wasu yanayi, duk rubutu a cikin takardu na Excel suna buƙatar a rubuta a babban jaka, wato, tare da babban harafi. Misali sau da yawa, alal misali, wannan ya zama dole lokacin da ake gabatar da aikace-aikace ko sanarwa ga hukumomin gwamnati daban-daban. Don rubuta rubutu a cikin manyan haruffa akan maballin, akwai maballin Caps Lock. Lokacin da aka matse shi, ana kirkiri yanayi inda dukkan haruffan da aka shigar suka kasance capitalized ko kuma, kamar yadda suke faɗi daban, wanda ke kangara.

Amma idan mai amfani ya manta da canzawa zuwa babban kanada ko ya gano cewa dole ne ya zama ya zama haruffa babba a rubutun bayan an rubuta? Shin da gaske za ku sake rubuta shi gaba ɗaya? Ba lallai ba ne. A cikin Excel akwai dama don warware wannan matsala cikin sauri da sauƙi. Bari mu tsara yadda za ayi.

Babban toara zuwa casearamin baki

Idan a cikin shirin Kalma don sauya haruffa zuwa babban (aramin baki ya isa ya zaɓi rubutun da ake so, riƙe maɓallin Canji kuma danna sau biyu akan maɓallin aiki F3, sannan a cikin Excel ba abu bane mai sauki a warware matsalar. Don sauya casean tsira zuwa babban kanti, dole ne a yi amfani da aiki na musamman da ake kira KYAUTA, ko amfani da macro.

Hanyar 1: Aikin UPRESS

Da farko, bari mu kalli aikin mai aiki KYAUTA. A bayyane yake daga sunan cewa babban burinta shine sauya haruffa a cikin rubutu zuwa babban jigo. Aiki KYAUTA Ya ƙunshi nau'in masu sarrafa rubutun rubutu. Harshen sa na da sauqi kuma yana kama da haka:

= CIGITAL (rubutu)

Kamar yadda kake gani, mai aiki yana da hujja daya kawai - "Rubutu". Wannan gardamar na iya zama magana ce ta rubutu ko, a mafi yawan lokuta, koma baya ga tantanin da ke dauke da rubutun. Wannan dabara tana jujjuyar da rubutun da aka bayar a cikin shigar manya.

Yanzu bari mu bincika wani misali madaidaiciya yadda mai aiki ke aiki KYAUTA. Muna da tebur da sunan ma'aikatan kamfanin. An rubuta sunan mahaifa a cikin al'ada, wato, farkon harafi shi ne babban rubutu, sauran kuma ƙananan ƙananan ne. Aikin shi ne sanya dukkan haruffa babba.

1. Zaɓi kowane ɓoyayyen tantanin halitta akan takardar. Amma ya fi dacewa idan an kafa ta a layi daya da wanda aka rubuta sunayen karshe. Nan gaba danna maballin "Saka aikin", wanda yake gefen hagu na masarar dabara.



2. Tagan taga ya fara Wizards na Aiki. Mun matsa zuwa rukuni "Rubutu". Nemo ka kuma haskaka sunan KYAUTAsannan kuma danna maballin "Ok".



3. Ana kunna taga mai aiki na mai aiki KYAUTA. Kamar yadda kake gani, a wannan taga akwai filin guda ɗaya kawai wanda ya dace da hujja kawai na aikin - "Rubutu". Muna buƙatar shigar da adireshin tantanin farko a cikin shafi tare da sunayen ma'aikatan a wannan filin. Ana iya yin wannan da hannu. Coordinwararru na tuki daga cikin keyboard a can. Hakanan akwai zaɓi na biyu, wanda yafi dacewa. Sanya siginan kwamfuta a cikin filin "Rubutu", sannan danna kan wayar a cikin tebur wanda aka sanya sunan farkon ma'aikaci. Kamar yadda kake gani, adireshin sai a nuna a filin. Yanzu muna kawai yin karshe touch a wannan taga - danna kan maɓallin "Ok".



4. Bayan wannan aikin, abubuwan da ke cikin sel na farko na shafi tare da suna na ƙarshe an nuna su a cikin zaɓin da aka zaɓa a baya, wanda ya ƙunshi tsarin. KYAUTA. Amma, kamar yadda muke gani, duk kalmomin da aka nuna a cikin wannan tantanin halitta ya ƙunshi manyan haruffa ne kawai.



5. Yanzu muna buƙatar aiwatar da juzu'i don duk sauran ƙwayoyin shafi tare da sunayen ma'aikata. A dabi’ance, ba za mu yi amfani da tsari dabam ga kowane ma’aikaci ba, amma kawai kwafa wanda yake akwai ta amfani da alamar cikawa. Don yin wannan, sanya siginan kwamfuta a cikin ƙananan kusurwar dama na ɓangaren takardar da ke ɗauke da tsari. Bayan haka, ya kamata a juya siginan kwamfuta alamar mai cikawa, wacce take kama da ƙaramin gicciye. Mun riƙe maɓallin linzamin kwamfuta na hagu kuma ja alamar cika ta yawan adadin ƙwayoyin daidai daidai da lambar su a cikin shafi tare da sunayen ma'aikatan kamfanin.



6. Kamar yadda kake gani, bayan aikin da aka ƙayyade, duk sunayen mutane an nuna su a kewayon kwafin kuma a lokaci guda suna ƙunshe da manyan haruffa.



7. Amma yanzu duk dabi'u a cikin rajista da muke buƙata suna a wajen tebur. Muna buƙatar shigar dasu cikin teburin. Don yin wannan, zaɓi duk ƙwayoyin da ke cike da tsari KYAUTA. Bayan haka, danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da zai buɗe, zaɓi Kwafa.



8. Bayan haka, zaɓi layi tare da cikakken sunan ma'aikatan kasuwancin a teburin. Mun danna kan shafin da aka zaɓa tare da maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. A toshe Saka Zabi zaɓi gunki "Dabi'u", wanda aka nuna azaman fili mai ɗauke da lambobi.



9. Bayan wannan aikin, kamar yadda kuke gani, za a shigar da juzu'in jujjuyawar fassarar sunayen a cikin manyan haruffa a cikin ainihin teburin. Yanzu zaku iya share kewayon da aka cika tare da dabaru, tunda ba mu sake buƙatar hakan. Zaɓi shi kuma danna-dama. A cikin mahallin menu, zaɓi Share Abun ciki.

Bayan haka, yi aiki a kan tebur don sauya haruffa a cikin sunayen ma'aikata zuwa manyan haruffa za a iya la'akari da kammala.

Darasi: Mayan Maɗaukaki

Hanyar 2: yi macro

Hakanan zaka iya warware aikin sauya toara zuwa manyan haruffa a cikin Excel ta amfani da macro. Amma kafin nan, idan ba a hada macros a cikin tsarin aikin ba, kuna buƙatar kunna wannan aikin.

1. Bayan kun kunna aikin macros, zaɓi kewayon da kuke so ku canza haruffa zuwa babban jigo. Sannan mu buga gajerar hanya Alt + F11.



2. Window yana farawa Kayayyakin aikin Kayayyakin Microsoft. Wannan, a zahiri, editan macro. Muna ɗaukar abin haɗi Ctrl + G. Kamar yadda kake gani, bayan wannan siginar yana motsawa zuwa filin ƙasa.



3. Shigar da lambar a cikin wannan filin:

   ga kowane c cikin zaɓi: c.value = ucase (c): gaba

   Sannan danna maballin Shiga kuma rufe taga Kayayyakin aikin gani a cikin daidaitaccen hanya, wato, ta danna maɓallin rufewa a cikin nau'i na gicciye a kusurwar dama ta sama.



4. Kamar yadda kake gani, bayan yin amfani da abubuwan da aka ambata a sama, ana sauya bayanan a cikin zangon da aka zaɓa. Yanzu an ba da izini sosai.

Darasi: Yadda ake ƙirƙirar macro a cikin Excel

Don a gwada juya da sauri dukkan haruffa a cikin rubutu daga ƙaramin hannu zuwa babban, kuma kada ku ɓata lokaci da hannu sake shigar da shi daga allon, a Excel akwai hanyoyi guda biyu. Na farko ya ƙunshi amfani da aiki KYAUTA. Na biyu shine mafi sauki da sauri. Amma ya dogara ne akan aikin macros, saboda haka dole ne a kunna wannan kayan aikin a cikin misalin aikinku. Amma hada macros shine ƙirƙirar ƙarin yanayin rauni don tsarin aiki don maharan. Don haka kowane mai amfani ya yanke shawara wa kansa wanne ne daga cikin hanyoyin da aka nuna da shi ne mafi alkhairi a gare shi.