Yadda ake girman harafin farko a cikin Excel

Masu amfani da Excel masu aiki sukan haɗu da yanayi inda ya zama dole a ƙirƙira harafin farko. Idan akwai ƙananan ƙwayoyin sel, zaka iya yin wannan hanya da hannu. Duk da haka, idan muna magana ne game da gyara babban tebur, da yawa zanen gado cike da bayanai, shi ne mafi kyau a yi amfani da ginannen fasali na Excel kanta, wanda zai sarrafa ta atomatik dukan tsari.

Yadda ake maye gurbin ƙananan haruffa na farko da babban baƙaƙe

Ɗaya daga cikin manyan matsalolin shirin Excel shine rashin aikin daban don maye gurbin zaɓaɓɓun haruffa daga sel tare da wasu. Zaɓin mai sauƙi shine yin shi da hannu, amma maimaita hanya ɗaya zai ɗauki lokaci mai yawa idan akwai sel masu cike da yawa. Don kammala aikin da sauri, kuna buƙatar haɗa kayan aikin da aka gina Excel a tsakanin su.

Yadda ake babban girman harafin farko na kalma ɗaya

Don maye gurbin haruffan farko a cikin kalma ɗaya kawai na yanki ko kewayo tare da manyan haruffa, kuna buƙatar amfani da ayyuka uku:

1. "MUSA" shine babban aikin. Ana buƙatar canza juzu'in gabaɗaya daga tantanin halitta ko harafi ɗaya zuwa abin da za'a nuna a cikin gardamar aiki.
2. "BAMA" aiki ne mai alaƙa da tsari na farko. Ana buƙatar maye gurbin ƙananan haruffa da manyan haruffa.
3. "LEFT" aiki ne mai alaƙa da tsari na biyu. Tare da taimakonsa, zaku iya ƙirga haruffa da yawa daga tantanin halitta da aka zaɓa.

Fahimtar yadda za a kammala wannan aikin zai zama mafi sauƙi idan kun bayyana dukan tsari mataki-mataki. Tsari:

1. Cika tebur tare da bayanan da ake buƙata a gaba.
2. Ta danna LMB, yi alama tantanin halitta kyauta akan takardar da ake buƙata na tebur.
3. A cikin tantanin halitta da aka zaɓa, dole ne ka rubuta magana don wurin da kake son maye gurbin ɗayan haruffa da wani. Maganar ta kasance kamar haka: MUSA(A(lambar cell),1,BAMA(HAGU(A(lambar cell),1))).
4. Lokacin da aka shirya dabara, kuna buƙatar danna maɓallin "Shigar" don aiwatar da aikin. Idan an rubuta furcin daidai, fasalin rubutun da aka gyara zai bayyana a cikin tantanin halitta daban.
5. Na gaba, kuna buƙatar yin shawagi akan rubutun da aka canza tare da siginan linzamin kwamfuta, matsar da shi zuwa kusurwar dama ta ƙasa. Baƙar giciye yakamata ya bayyana.
6. Wajibi ne a riƙe gicciye LMB, ja shi ƙasa kamar yadda yake a cikin ginshiƙin aiki.
7. Bayan kammala wannan aikin, sabon shafi zai bayyana, inda za a nuna duk layin ginshiƙin aiki tare da haruffan farko da aka canza zuwa manyan haruffa.

8. Na gaba, kuna buƙatar kwafin bayanan da aka karɓa zuwa wurin ainihin bayanin. Don yin wannan, kuna buƙatar zaɓar sabon shafi, kwafi ta cikin menu na mahallin ko layi tare da kayan aiki a cikin shafin "Gida".
9. Zaɓi duk layuka daga ginshiƙi na asali waɗanda kuke son musanya su. Danna-dama, a cikin mahallin mahallin da ya bayyana, zaɓi aiki na biyu a cikin rukunin "Manna Zaɓuɓɓuka", sunansa "Dabi'u".
10. Idan an yi duk ayyuka daidai, ƙimar da ke cikin sel masu alama za su canza zuwa waɗanda aka samu ta hanyar dabara.
11. Ya rage don cire ginshiƙi na ɓangare na uku. Don yin wannan, zaɓi duk sel da aka canza, danna-dama don buɗe menu na mahallin, zaɓi aikin "Share".
12. Ya kamata taga ya bayyana tare da zaɓi don share sel daga tebur. Anan kuna buƙatar zaɓar yadda za a share abubuwan da aka zaɓa - gabaɗayan ginshiƙi, layuka ɗaya, sel tare da motsi sama, sel tare da motsi zuwa hagu.
13. Don kammala sharewa, danna maɓallin "Ok".

Hanyar maye gurbin haruffan farko na duk kalmomi tare da manyan baki

Aiki tare da tebur Excel, wani lokacin ya zama dole a canza haruffan farko na duk kalmomi a cikin wasu sel zuwa manya. Don yin wannan, ana bada shawarar yin amfani da aikin "PROPER". Hanyar:

1. Zaɓi tantanin halitta mara kyau a cikin tebur ta danna-dama, ƙara ainihin kalmar zuwa gare ta ta amfani da maɓallin "Saka Aiki" (wanda yake gefen hagu na mashaya dabara, wanda "fx") ke nunawa).

2. Taga don ƙara saitunan ayyuka zai bayyana a gaban mai amfani, wanda a ciki kuna buƙatar zaɓar "PROPER", danna maɓallin "Ok".
3. Bayan haka, kuna buƙatar cika hujjar aikin. A cikin filin kyauta, kuna buƙatar rubuta sunan tantanin halitta wanda kuke son canza bayanan. Danna maɓallin "Ok".

Muhimmin! Ga waɗancan masu amfani waɗanda suka san yawancin dabarun Excel ta zuciya, ba lallai ba ne a yi amfani da "Mayen Aiki". Kuna iya shigar da aikin a cikin zaɓaɓɓen tantanin halitta na tebur da hannu kuma ƙara masa ma'amalar tantanin halitta wanda kuke son canza bayanai. Misali =FADAKARWA(A2).

4. Za a nuna sakamakon da aka gama a cikin tantanin halitta na tebur, wanda aka yiwa alama daban daga ginshiƙan aiki.
5. Maimaita matakai 5, 6, 7 daga hanyar da ta gabata. Idan an yi komai daidai, sabon ginshiƙi tare da bayanan da aka canza yakamata ya bayyana.
6. Dole ne a zaɓi wani ginshiƙi daban ta amfani da RMB, daftarin aiki ko haɗin maɓalli akan maballin “CTRL + C”.
7. Zaɓi duk sel daga takaddar aikin wanda kake son maye gurbin bayanansu. Manna sigar da aka gyara ta hanyar aikin "Dabi'u".
8. Mataki na ƙarshe kafin adana sakamakon shine share ginshiƙi da aka ƙara wanda aka kwafi bayanan, kamar yadda aka bayyana a hanya ta farko.

Kammalawa

Idan kun haɗa daidaitattun kayan aikin da ke cikin daidaitaccen sigar Excel, zaku iya canza haruffan farko na kalmomi ɗaya ko fiye daga sel ɗin da aka zaɓa, wanda sau da yawa ya fi dacewa da sauri fiye da shigarwar hannu.