Yadda ake Canja wuri a cikin tantanin halitta

Anonim

Yi ƙaura layi a Microsoft Excel

Kamar yadda ka sani, ta tsohuwa, a cikin sel na biyu, farkon takardar yana located layi daya tare da lambobi, rubutu ko wasu bayanai. Amma me zan yi idan kun buƙaci canja wurin rubutun a cikin sel guda zuwa wani layin? Za'a iya yin wannan aikin ta amfani da wasu fasali na shirin. Bari mu sifance ta yadda ake yin yawo cikin sel a Forecel.

Hanyoyi don canja wurin rubutu

Wasu masu amfani suna ƙoƙarin canja wurin rubutu a cikin tantanin ta danna maɓallin Shigar Maɓallin. Amma ta wannan suna neman kawai la'anar suna motsawa zuwa layin takarda na gaba. Zamuyi la'akari da zaɓuɓɓukan canja wurin daidai a cikin sel, mai sauqi qwarai da yawa.

Hanyar 1: Yin amfani da keyboard

Zaɓin zaɓi na sauƙi zuwa wani kirtani shine don saita siginan siginan kafin ɓangaren da kake son canja wuri, sannan ka buga maɓallin maballin Alt (hagu) + Shigar.

Cell inda kuke buƙatar canja wurin kalmomi zuwa Microsoft Excel

Ba kamar amfani da maɓallin Shigar ɗaya kaɗai ba, ta amfani da wannan hanyar, zai kasance cewa an sanya shi.

Canja wurin kalma yana da mahimmanci a Microsoft Excel

Darasi: Makullin zafi a cikin excele

Hanyar 2: Tsara

Idan mai amfani bai saita ɗawainiyar ba don canja wurin takamaiman kalmomin, kuma kawai kuna buƙatar dacewa da su a cikin sel ɗaya, zaku iya amfani da kayan aiki.

  1. Zaɓi tantanin halitta wanda rubutun ke wuce iyakokin. Danna shi dama linzamin kwamfuta. A cikin jerin da ke buɗe, zaɓi sel "tsari na tsari ...".
  2. Canji zuwa Tsarin Cell a Microsoft Excel

  3. Taga taga yana buɗewa. Je zuwa "jeri" shafin. A cikin "nuni" saitunan ", zaɓi" canja wurin "na" sigogi, lura da "sigogi, lura da shi da alamar bincike. Latsa maɓallin "Ok".

Sel sel a Microsoft Excel

Bayan haka, idan bayanai suka bayyana fiye da iyakokin sel, za su iya fadada ta atomatik, kuma za a canja kalmomin ta atomatik. Wani lokaci dole ne ku fadada iyakokin da hannu.

Domin haka a daidai wannan kar a tsara kowane kashi ɗaya, zaku iya zaɓin duka yankin. Rashin kyawun wannan zaɓi shine cewa canja wurin ana yi kawai idan kalmomin basu dace da iyakokin ta atomatik ba tare da yin la'akari da sha'awar mai amfani ba.

Hanyar 3: Yin Amfani da Tsarin

Hakanan zaka iya aiwatar da canja wurin a cikin wayar ta amfani da tsari. Wannan zabin yana da dacewa musamman idan ana nuna abubuwan da ke ciki ta amfani da ayyuka, amma ana iya amfani da shi a lokuta na al'ada.

  1. Tsara tantanin halitta kamar yadda aka nuna a sigar da ta gabata.
  2. Selectel kuma shigar da wannan magana a kai ko a cikin kirtani:

    = Kama ("rubutu1"; alama (10); "Rubutun2")

    Madadin "rubutu1" da "rubutun rubutu," kuna buƙatar musayar kalmomi ko kuma kalmomin da kake son canja wurin. Ba a buƙatar sauran haruffan da aka yi.

  3. Ayyukan aikace-aikacen suna kama Microsoft Microsoft

  4. Domin a sakamakon a nuna shi a kan takardar, danna maɓallin Shigar a kan keyboard.

Kalmomin da aka jinkirtawa suna amfani da fnca a Microsoft Excel

Babban hasara na wannan hanyar ita ce gaskiyar ita ce mafi wahala a aiwatar da zaɓuɓɓuka na baya.

Darasi: Proff Oxcel

Gabaɗaya, mai amfani dole ne ya yanke shawarar wane ne daga cikin hanyoyin da aka gabatar shi ne mafi kyau duka don amfani da shi. Idan kana son dukkan haruffan ne kawai zasu dace da kan iyakokin tantanin halitta, sai kawai kawai tsara shi a hanyar da ake so, kuma mafi kyawun tsari gaba ɗaya. Idan kana son saita canja wurin takamaiman kalmomi, to sai buga lambar maɓallin haɗuwa, kamar yadda aka bayyana a cikin bayanin farkon hanyar. Zaɓin na uku ana bada shawarar kawai lokacin da aka ja bayanan daga wasu yangwaye ta amfani da tsari. A cikin wasu halaye, amfani da wannan hanyar ba zahiri ce, kamar yadda akwai zaɓuɓɓuka mafi sauƙin don magance aikin.

Kara karantawa