Yadda za a canza kuɗi daga Sberbank zuwa QIWI

Wani lokacin lokacin yin aiki tare da tebur, kana buƙatar shigar da rubutu a cikin tantanin halitta a tsaye, maimakon a fili, kamar yadda sau da yawa yake. Wannan dama yana samar da shirin Excel. Amma ba kowane mai amfani san yadda za a yi amfani da shi ba. Bari mu ga yadda hanyoyi a Excel zasu iya rubuta rubutun a tsaye.

Darasi: Yadda za a rubuta a tsaye a cikin Microsoft Word

Rubuta rikodin a tsaye

Tambayar yin amfani da rikodi a tsaye a Excel an warware shi tare da taimakon kayan aikin tsarawa. Amma duk da wannan, akwai hanyoyi daban-daban don sanya shi cikin aiki.

Hanyar 1: daidaitawa ta hanyar mahallin menu

Mafi sau da yawa, masu amfani sun fi so su haɗa da rubutun rubutu ta tsaye ta amfani da alignment a cikin taga. "Tsarin tsarin"inda za ku iya shiga cikin menu mahallin.

  1. Mu danna-dama kan tantanin halitta dauke da rikodin, wanda dole ne mu fassara cikin matsayi na tsaye. A cikin jerin mahallin da aka buɗe, zaɓi abu "Tsarin tsarin".
  2. Window yana buɗe "Tsarin tsarin". Jeka shafin "Daidaitawa". A cikin ɓangaren dama na bude taga akwai sashe na saituna "Gabatarwa". A cikin filin "Digiri" Ƙimar da aka ƙayyade ita ce "0". Wannan yana nufin jagorancin kwance na rubutu a cikin sel. Muna motsa cikin wannan filin ta amfani da maballin darajar "90".

    Zaka kuma iya yin wani abu dabam. A cikin "Rubutun" block akwai kalma "Alamar". Danna kan shi, riƙe ƙasa da maɓallin linzamin hagu kuma ja shi har sai kalma ta kasance a matsayi na tsaye. Sa'an nan kuma saki maɓallin linzamin kwamfuta.

  3. Da zarar cikin taga da saitunan da aka bayyana a sama, danna maɓallin "Ok".

Kamar yadda kake gani, bayan wadannan ayyukan, shigarwa a cikin cell da aka zaɓa ya zama tsaye.

Hanyar 2: Aikace-aikacen ayyuka

Ko da sauƙi don yin rubutu a tsaye shi ne yin amfani da maɓalli na musamman a kan rubutun, wanda mafi yawan masu amfani sun san ko kaɗan game da tsarin tsarawa.

  1. Zaɓi tantanin halitta ko kewayon inda muke shirin shirya bayanai.
  2. Jeka shafin "Gida", idan a yanzu muna cikin wani shafin. A tef a cikin asalin kayan aiki "Daidaitawa" danna maballin "Gabatarwa". A cikin jerin da ya buɗe, zaɓi abu "Kunna rubutu".

Bayan wadannan ayyukan, rubutu a cikin cellular da aka zaɓa za a nuna a tsaye.

Kamar yadda kake gani, wannan hanya ta fi dacewa da baya, amma, duk da haka, ana amfani dashi akai-akai. Wanda duk da haka yana so ya yi wannan hanya ta hanyar tsara tsari, to, za ka iya zuwa shafin ta dace daga tef. Don wannan, zama a cikin shafin "Gida", kawai danna gunkin a cikin nau'i mai ƙyama, wadda take a cikin kusurwar dama na ƙungiyar kayan aiki "Daidaitawa".

Bayan haka, taga zai bude. "Tsarin tsarin" da kuma dukkan ayyukan mai amfani da ya kamata ya zama daidai daidai da yadda aka yi a farkon hanya. Wato, dole ne a yi amfani da kayan aiki a cikin toshe "Gabatarwa" a cikin shafin "Daidaitawa".

Idan kana son matsayi na tsaye a cikin rubutu da kuma haruffa su kasance a matsayi na al'ada, ana yin haka kuma ta amfani da maɓallin "Gabatarwa" a kan tef. Danna wannan maɓallin kuma cikin jerin da ya bayyana, zaɓi abu Rubutun Vertical.

Bayan wadannan ayyukan, rubutu zai ɗauki matsayin da ya dace.

Darasi: Tsarin layi na Excel

Kamar yadda ka gani, akwai hanyoyi guda biyu don daidaita daidaiton rubutu: ta hanyar taga "Tsarin tsarin" kuma ta hanyar maballin "Daidaitawa" a kan tef. Bugu da ƙari, dukkanin waɗannan hanyoyi suna amfani da wannan tsari na tsarawa. Bugu da ƙari, ya kamata ka sani cewa akwai zaɓi biyu don daidaitaccen tsari na abubuwa a cikin tantanin halitta: tsarin jeri na haruffa da kuma irin wannan wuri na kalmomi a gaba ɗaya. A cikin wannan akwati, an rubuta haruffa a matsayinsu, amma a cikin wani shafi.