Kamar yadda kuka sani, ta hanyar sirri a cikin sel ɗaya na takaddara na Excel akwai layi ɗaya tare da lambobi, rubutu ko wasu bayanan. Amma abin da za a yi idan kuna buƙatar canja wurin rubutu a cikin sel ɗaya zuwa wani layi? Ana iya yin wannan aikin ta amfani da wasu fasalulluka na shirin. Bari mu ga yadda za a yi abincin layin a cikin sel a Excel.
Hanyoyin Rubutun rubutu
Wasu masu amfani suna ƙoƙarin canja wurin rubutu a cikin sel ta latsa maɓallin a kan maballin Shigar. Amma sun cimma wannan kawai ta motsa siginar kwamfuta zuwa layi na gaba na takardar. Za mu yi la’akari da zaɓin canja wuri a cikin tantanin, duka mai sauƙi ne kuma mafi rikitarwa
Hanyar 1: yi amfani da maballin
Hanya mafi sauki don canzawa zuwa wata layin shine sanya siginan kwamfuta a gaban sashin da kake son canja wurin, sannan saika sanya madannin maballin a key din keyboard Alt + Shiga.
Ba kamar amfani da maɓallin guda ɗaya ba Shigar, amfani da wannan hanyar za'a sami daidai sakamakon da aka saita.
Darasi: Babban hotkeys
Hanyar 2: tsarawa
Idan mai amfani ba shi da aikin canja wurin kalmomin da aka tsayar don zuwa sabon layi, amma kawai suna buƙatar dacewa da su a cikin sel ɗaya ba tare da wuce iyakokinsa ba, to, zaku iya amfani da kayan aikin tsarawa.
- Zaɓi sel wanda rubutun ya wuce kan iyakoki. Mun danna shi tare da maɓallin linzamin kwamfuta na dama. Cikin jeri dake buɗe, zaɓi "Tsarin kwayar halitta ...".
- Tsarin tsarawa yana buɗe. Je zuwa shafin Jeri. A cikin toshe saitin "Nuna" zaɓi siga Kunshin Maganata hanyar latsa shi. Latsa maballin "Ok".
Bayan haka, idan bayanan suka haɓaka da iyakokin tantanin halitta, to, zai haɗu ta atomatik a tsawo, kuma za a fara canja kalmomin. Wani lokaci dole ne ku fadada iyakoki da hannu.
Domin kada a tsara kowane kayan aikin ta wannan hanyar, kai tsaye zaka iya zaɓar yankin gaba daya. Rashin kyawun wannan zaɓi shine cewa ana yin murhu ne kawai idan kalmomin basu dace da iyakokin ba, bugu da ,ari, ana aiwatar da aiki ta atomatik ba tare da yin la'akari da nufin mai amfani ba.
Hanyar 3: yi amfani da dabara
Hakanan zaka iya aiwatar da canja wurin cikin kwayar ta amfani da dabaru. Wannan zaɓi yana dacewa musamman idan an nuna abun cikin ta amfani da ayyuka, amma ana iya amfani dashi a al'adane.
- Tsara tantanin halitta kamar yadda aka bayyana a sigar da ta gabata.
- Zaɓi tantanin halitta kuma shigar da magana mai zuwa a ciki ko a cikin mashaya dabara:
= CLICK ("TEXT1"; SYMBOL (10); "TEXT2")Madadin abubuwa CIGABA da CIGABA kuna buƙatar sauya kalmomin ko jerin kalmomin da kuke son canja wurin. Sauran haruffa na asalin basu buƙatar canza su.
- Don nuna sakamakon a kan takardar, danna Shigar a kan keyboard.
Babban kuskuren wannan hanyar shine gaskiyar cewa yana da wahalar aiwatarwa fiye da zaɓuɓɓukan da suka gabata.
Darasi: Abubuwan Kyakkyawan fasali na Excel
Gabaɗaya, mai amfani dole ne ya yanke shawara wa kansa wanne daga cikin hanyoyin samarwa da ya fi dacewa don amfani da su a wani yanayi. Idan kanaso dukkan haruffan suyi daidai da iyakokin tantanin, to kawai a tsara shi yadda ake bukata, kuma yafi dacewa a tsara dukkan kewayon. Idan kuna son shirya canja wurin takamaiman kalmomi, to sai a buga maɓallin maɓallin da ya dace, kamar yadda aka bayyana a cikin bayanin hanyar farko. Zaɓin na uku ana bada shawarar yin amfani da shi lokacin da aka cire bayanai daga wasu jeri ta amfani da dabara. A wasu halaye, amfanin wannan hanyar ba na ɗabi'a ba ne, tunda akwai zaɓuɓɓuka da yawa da suka fi sauƙi don warware matsalar.
