Canje-canje a cikin Excel

Case a cikin Microsoft Office Excel shine tsayin haruffa, wurin su a cikin sel na tsararrun tebur. Excel baya samar da aiki na musamman don canza yanayin haruffa. Koyaya, ana iya canza shi ta amfani da dabara. Yadda za a yi wannan da sauri za a tattauna a wannan labarin.

Yadda ake canza harka a cikin Excel

Akwai zaɓuɓɓuka da yawa don canza rajista, kowannensu ya cancanci cikakken la'akari. Na gaba, za mu yi la'akari da duk hanyoyin da ke ba ku damar canza yanayin haruffa.

Hanya 1. Yadda ake girman harafin farko a kalma

Yana da al'ada don fara jimloli a cikin sel na tebur tare da babban harafi. Wannan yana haɓaka ƙayatarwa da gabatar da tsararru. Don canza yanayin harafin farko a cikin kalma, sanya shi babba, kuna buƙatar bin algorithm mai zuwa:

1. Tare da maɓallin linzamin kwamfuta na hagu, zaɓi kewayon sel ko wani ɓangaren tsararrun tebur.
2. A cikin layin shigar da ke saman babban menu na Excel a ƙarƙashin ginshiƙin kayan aiki, ko a cikin kowane ɓangaren tebur, shigar da dabarar da hannu daga maballin PC. "= MAGANAR()". A cikin baka, dole ne mai amfani ya ƙididdige hujjar da ta dace. Waɗannan su ne sunayen sel waɗanda a cikinsu kuke son canza yanayin hali na farko a cikin kalmar.

3. Bayan rubuta dabara, danna "Shigar" don tabbatar da aikin.
4. Duba sakamakon. Yanzu duk kalmomin da ke cikin zaɓaɓɓen kashi ko kewayon sel dole ne su fara da babban harafi.

5. Idan ya cancanta, za'a iya shimfiɗa tsarin da aka rubuta zuwa ƙarshen tsararrun tebur don cika ragowar ƙwayoyin.

Kula! Hanyar da aka yi la'akari da canza rijistar ba ta da daɗi idan an rubuta kalmomi da yawa a cikin tantanin halitta lokaci ɗaya. Sa'an nan dabarar za ta yi girma kowace kalma.

Dabarar "= PROPLANCH()" ya fi dacewa don amfani lokacin da mai amfani yana aiki tare da sunaye masu dacewa, wanda dole ne ya fara da babban harafi.

Hanyar 2. Yadda ake yin duk haruffa a cikin ƙananan haruffa

Hakanan ana aiwatar da wannan hanyar ta hanyar amfani da dabarar da ta dace. Don canza shari'ar da sauri zuwa ƙananan haruffa, kuna buƙatar yin manipulations masu zuwa bisa ga algorithm:

1. Sanya siginan linzamin kwamfuta a cikin tantanin halitta, wanda daga baya zai nuna sakamakon dabarar.
2. A cikin abin da aka zaɓa na jeri na tebur, rubuta dabarar "= KASA ()". A cikin maɓalli, haka kuma, dole ne ka ƙirƙiri hujja ta danna LMB akan abin da ake so na ainihin tantanin halitta wanda ba a canza yanayin a cikinsa ba.

3. Danna "Shigar" daga madannai don kammala tsarin.
4. Duba sakamakon. Idan duk ayyuka sun yi daidai, to, kalma ɗaya ko jerin haruffa masu ƙananan haruffa za a rubuta a cikin tantanin halitta da aka zaɓa.

5. Miƙa sakamakon zuwa ƙarshen tsararrun tebur don cika sauran abubuwan da suka rage. Wannan fasalin yana ba mai amfani damar kada ya shigar da dabara don takamaiman tantanin halitta kowane lokaci.

Muhimmin! Abin takaici, daidaitaccen sigar Excel ba shi da zaɓi na musamman wanda ke da alhakin canza lamarin, kamar a cikin Microsoft Office Word, saboda. An tsara Excel don yin aiki tare da tebur, ba rubutu ba.

Hanya 3. Yadda ake manyan haruffa a cikin kalma

Wani lokaci, lokacin ƙirƙirar tebur a cikin MS Excel, mai amfani yana buƙatar kowane harafi a cikin kalmar tantanin halitta ya zama babba. Wannan ya zama dole don haskaka mahimman gutsuttsura na tsararrun tebur, don mai da hankali.

Don jimre wa aikin a cikin mafi ƙanƙancin lokaci mai yuwuwa, kuna buƙatar amfani da umarni mai sauƙi mataki-mataki:

1. Zaɓi tantanin halitta wanda sakamakon canjin yanayin zai nuna ta hanyar sanya siginan linzamin kwamfuta a ciki.
2. Shigar da dabara "=" akan madannai na kwamfutaPRESCRIPTION()». A cikin ƙididdiga, ta hanyar kwatanci tare da tsare-tsaren da ke sama, kana buƙatar ƙayyade hujja - tantanin halitta inda kake son canza lamarin.

3. Kammala rubuta dabarar ta latsa maɓallin "Shigar".
4. Tabbatar cewa duk haruffa a cikin tantanin halitta suna da babba.

Hanya 4. Canja yanayin haruffa ɗaya a cikin kalma

A cikin Microsoft Office Excel, zaku iya canza girman ɗaya ko fiye da haruffa a cikin kalma. Misali, ta hanyar sanya su manyan haruffa, da barin sauran ƙananan haruffa. Don yin wannan hanya, ba kwa buƙatar amfani da dabarar, kawai bi wasu matakai masu sauƙi:

1. Zaɓi kowane tantanin halitta na tsararrun tebur ta danna shi tare da maɓallin linzamin kwamfuta na hagu.
2. A cikin layin shigar da dabaru a saman babban menu na shirin, za a nuna abubuwan da ke cikin abin da aka zaɓa. Ya fi dacewa don yin gyare-gyaren bayanai a cikin wannan layin.
3. Sanya siginan linzamin kwamfuta kusa da kowane ƙaramin harafi a cikin kalmar kuma share ta ta latsa maɓallin "Backspace" daga madannin kwamfuta.
4. Rubuta haruffa iri ɗaya da hannu, amma ta hanyar sanya shi babba. Don yin wannan, dole ne ka riƙe kowane maɓallin "Shift" kuma danna kan harafin da kake so.
5. Duba sakamakon. Idan komai yana da kyau, to, yanayin harafin zai canza.
6. Yi haka don sauran haruffan da ke cikin kalmar.

Ƙarin Bayani! Hakanan zaka iya canza yanayin duk haruffa a cikin kalma da hannu daga madannai. Koyaya, wannan zai ɗauki tsawon lokaci fiye da amfani da takamaiman tsari.

Kammalawa

Don haka, zaku iya canza yanayin haruffa a cikin Microsoft Office Excel ko dai ta amfani da dabarar da suka dace, ko da hannu ta canza girman haruffa akan madannai na PC. Dukkan hanyoyin biyu an tattauna su dalla-dalla a sama.