A wasu yanayi, ana buƙatar dukkan rubutu a cikin takardun Excel don a rubuta su a babba, wato, tare da babban harafi. Sau da yawa, alal misali, wannan wajibi ne a lokacin da aka aika aikace-aikacen ko takaddun shaida ga wasu jihohi. Don rubuta rubutu a babban haruffa a kan keyboard akwai maɓallin Caps Lock. Lokacin da aka guga man, an fara yanayin, wanda duk harufa da aka shigar za su kasance babba ko, kamar yadda suke faɗi a wata hanya dabam, babba.
Amma abin da za a yi idan mai amfani ya manta ya sauya zuwa babban akwati ko ya gano cewa haruffa ya zama babba cikin rubutu kawai bayan rubuta shi? Dole ku sake sake rubuta shi duka? Ba dole ba ne. A cikin Excel, yana yiwuwa a warware wannan matsala da sauri da sauki. Bari mu kwatanta yadda ake yin hakan.
Duba kuma: Yadda za a yi rubutu a cikin Kalma a babban haruffa
Canji na ƙananan harufa zuwa babba
Idan Kalmar kalma don maida haruffa zuwa babba (babba) ya ishe don zaɓar rubutu da ake so, riƙe ƙasa da maballin SHIFT kuma danna danna maballin sau biyu F3to, ba sauki ba ne don warware matsalar a Excel. Domin ya juya ƙananan haruffa zuwa babba, zaku yi amfani da aikin musamman da ake kira UPPERko amfani da Macro.
Hanyar 1: aikin UPPER
Na farko, bari mu dubi aikin mai aiki UPPER. Daga lakabi nan da nan ya bayyana cewa ainihin manufar shi shine maida haruffa a cikin rubutu zuwa babba. Yanayi UPPER yana cikin nau'in kayan aiki na Excel. Its syntax ne m sauki kuma kama da wannan:
= UPPER (rubutu)
Kamar yadda kake gani, mai aiki yana da hujja daya kawai - "Rubutu". Wannan hujja na iya zama kalma a cikin rubutu, ko, mafi sau da yawa, hanyar kula da tantanin halitta dauke da rubutun. Wannan rubutun wannan tsari da sabobin tuba zuwa wani shigarwa a cikin babba.
Yanzu bari mu ɗauki misali mai kyau don gano yadda mai aiki yana aiki. UPPER. Muna da tebur tare da sunan ma'aikatan kamfanin. An rubuta sunan mai suna a cikin al'ada, wato, harafin farko shine babban birnin kuma sauran su ne ƙananan. Ayyukan shine a sanya dukkan haruffa da aka ƙaddara (babban birnin).
- Zaɓi kowane komai marar ciki a kan takardar. Amma ya fi dacewa idan an samo shi a cikin layi daya zuwa wanda aka rubuta sunayen. Kusa, danna maballin "Saka aiki"wanda yake a gefen hagu na tsari.
- Wurin ya fara. Ma'aikata masu aiki. Matsa zuwa category "Rubutu". Nemi kuma zaɓi sunan UPPERsannan ka danna maballin "Ok".
- Ƙaddamarwa da taga mai gudanarwa UPPER. Kamar yadda kake gani, a cikin wannan taga akwai filin daya kawai wanda ya dace da hujja guda ɗaya na aikin - "Rubutu". Muna buƙatar shigar da adireshin farkon tantanin halitta a wannan filin a cikin shafi tare da sunayen ma'aikata. Ana iya yin haka da hannu. Beat daga keyboard akwai daidaituwa. Akwai kuma zaɓi na biyu, wanda ya fi dacewa. Saita siginan kwamfuta a filin "Rubutu", sa'an nan kuma mu danna kan tantanin salula na tebur wanda aka sanya sunan mahaifi na farko na ma'aikaci. Kamar yadda kake gani, ana nuna adireshin a filin. Yanzu dole muyi ta karshe a cikin wannan taga - danna maballin. "Ok".
- Bayan wannan aikin, an nuna abubuwan da ke cikin sel na farko na shafi tare da sunaye na karshe a cikin ɓangaren da aka zaɓa, wanda ya ƙunshi nau'i UPPER. Amma, kamar yadda muka gani, duk kalmomin da aka nuna a wannan tantanin sun kunshi manyan haruffa.
- Yanzu muna buƙatar canza dukkan kwayoyin halitta a cikin shafi tare da sunayen ma'aikata. A dabi'a, ba za mu yi amfani da takamammen tsari na kowane ma'aikaci ba, amma kawai ka kwafa wanda ya riga ya kasance ta amfani da alamar cikawa. Don yin wannan, sanya siginan kwamfuta a cikin kusurwar dama na takardar takardar shaidar, wanda ya ƙunshi nau'i. Bayan haka, ya kamata a juya siginan ya zama alamar cika, wanda yayi kama da ƙananan giciye. Muna yin zane na maballin hagu na hagu kuma zana alama mai cikawa don yawan kwayoyin halitta daidai da lambar su a shafi tare da sunayen ma'aikatan kamfanin.
- Kamar yadda ka gani, bayan wannan aikin, duk sunayen sunaye sun canja zuwa ga kwafin kundin kuma a lokaci guda sun ƙunshi manyan haruffa.
- Amma yanzu duk dabi'u a cikin rijistar da muke buƙatar suna waje a tebur. Muna buƙatar saka su cikin tebur. Don yin wannan, zaɓi dukkanin sel waɗanda aka cika da siffofi UPPER. Bayan haka, danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. A cikin jerin mahallin da aka buɗe, zaɓi abu "Kwafi".
- Bayan wannan, zaɓi shafi tare da sunan ma'aikatan kamfanin a teburin. Danna maballin da aka zaba tare da maɓallin linzamin linzamin dama. Yarda da menu mahallin. A cikin toshe "Zaɓuɓɓukan Zaɓuka" zaɓi gunkin "Darajar"wanda aka nuna a matsayin square dauke da lambobi.
- Bayan wannan aikin, kamar yadda kake gani, za a saka sabon rubutun mawuyacin sunayen sunaye a cikin haruffan haruffa a cikin tebur na asali. A yanzu zaku iya cire kewayon cike da tsari, tun da ba zamu buge shi ba. Zaɓi shi kuma danna maɓallin linzamin maɓallin dama. A cikin mahallin menu, zaɓi abu "Sunny Content".
Bayan wannan, aikin da ake yi a kan tebur a kan juyawa haruffa a cikin sunayen ma'aikatan cikin manyan haruffa za a iya daukan kammala.
Darasi: Maɓallin aiki na Excel
Hanyar 2: Yi amfani da Macro
Don magance aikin yin juyawa haruffa zuwa babba a Excel, zaka iya amfani da macro. Amma kafin, idan shirin ku bai ƙunshi aikin tare da macros ba, kuna buƙatar kunna wannan aikin.
- Da zarar ka kunna macro, zaɓi layin da kake so a sake mayar da haruffan zuwa babban akwati. Sa'an nan kuma rubuta gajeren hanya Alt F11.
- Ginin yana farawa Microsoft Visual Basic. Wannan, a gaskiya ma, editan macro. Kurtu a hade Ctrl + G. Kamar yadda kake gani, bayan wannan, siginan kwamfuta yana motsawa zuwa filin filin.
- Shigar da wadannan shafuka a wannan filin:
ga kowane c a zabin: c.value = ucase (c): gabaSa'an nan kuma danna kan maɓallin Shigar kuma rufe taga Kayayyaki na asali a hanya madaidaiciya, wato, ta danna kan maɓallin kusa a cikin hanyar giciye a kusurwar dama na dama.
- Kamar yadda zaku iya gani, bayan yin aikin da aka yi a sama, an canza bayanan da aka zaɓa a cikin jerin. Yanzu sun ƙunshi dukkanin haruffan haruffa.
Darasi: Yadda za a ƙirƙiri macro a Excel
Domin yaduwa da sauri canza dukkan haruffa a cikin rubutu daga ƙananan zuwa babba, kuma kada ku ɓace lokaci don sake shigar da shi daga cikin keyboard, akwai hanyoyi biyu a Excel. Na farko ya shafi amfani da aikin UPPER. Zaɓin na biyu shine ma sauki da sauri. Amma yana dogara ne akan aikin macros, don haka dole ne a kunna wannan kayan aiki a misali na shirin. Amma hada macros - shine ƙirƙirar ƙarin mahimmanci na rashin lafiyar tsarin aiki ga masu kai hari. Saboda haka kowanne mai amfani ya yanke shawara kan kansa wane ne daga cikin hanyoyin da aka nuna ya fi kyau a yi masa amfani.
