Wani lokaci lokacin aiki tare da tebur, kuna buƙatar saka rubutu a cikin sel tsaye, maimakon a kwance, kamar yadda yake sau da yawa. An bayar da wannan fasalin ta hanyar Excel. Amma ba kowane mai amfani da ya san yadda ake amfani da shi ba. Bari mu bincika hanyoyi a cikin Excel za ku iya rubuta rubutu tsaye.
Darasi: Yadda ake rubutu a tsaye a cikin Microsoft Word
Rubuta rikodin a tsaye
Batun samar da rikodin tsaye a cikin Excel an warware shi ta amfani da kayan aikin tsarawa. Amma, duk da wannan, akwai hanyoyi daban-daban don aiwatar da shi.
Hanyar 1: jeri ta cikin menu
Mafi sau da yawa, masu amfani sun fi so don kunna iyawar haruffa a tsaye tare da jeri a cikin taga. Tsarin Cellinda zaku iya bi ta wurin mahalli.
- Danna-dama akan tantanin da aka sanya rikodin, wanda dole ne mu fassara shi a tsaye. A cikin menu na mahallin da zai buɗe, zaɓi Tsarin Cell.
- Window yana buɗewa Tsarin Cell. Je zuwa shafin Jeri. A hannun dama na bude taga akwai toshe tsare-tsaren Gabatarwa. A fagen "Digiri" tsoho darajar shine "0". Wannan yana nufin shugabanci na rubutu a cikin sel. Fitar da darajar "90" a cikin wannan filin ta amfani da keyboard.
Hakanan zaka iya yin ɗan bambanci. A cikin toshe "Rubutu" akwai kalma "Rubutun". Latsa shi, riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi har kalmar ta ɗauka a tsaye. To saika saki maballin linzamin kwamfuta.
- Bayan an saita saitunan da aka bayyana a sama a cikin taga, danna maɓallin "Ok".
Kamar yadda kake gani, bayan waɗannan ayyukan, rikodin a cikin tantanin da aka zaɓa ya zama a tsaye.
Hanyar 2: ayyuka akan tef
Zai fi sauƙi a sanya rubutun a tsaye - yi amfani da maɓallin musamman akan kintinkiri, wanda yawancin masu amfani suka san ko da ƙasa da taga tsarawa.
- Zaɓi waya ko kewayon inda muke shirin sanya bayani.
- Je zuwa shafin "Gida"idan a wannan lokacin muna cikin wani rukuni na daban. A kan kintinkiri a cikin akwatin kayan aiki Jeri danna maballin Gabatarwa. Cikin jeri dake buɗe, zaɓi Juya rubutu sama.
Bayan waɗannan ayyuka, rubutun da aka zaɓa a cikin tantanin halitta ko kewayon an nuna shi tsaye.
Kamar yadda kake gani, wannan hanyar yafi dacewa fiye da wacce ta gabata, amma, duk da haka, ana amfani dashi ƙasa da yawa. Duk wanda har yanzu yana son yin wannan hanya ta taga tsarawa, to, zaku iya zuwa shafin da yake dacewa daga tef ɗin kuma. Don yin wannan, kasancewa a cikin shafin "Gida", kawai danna kan gunki a cikin hanyar kibiya mai rauni, wanda ke cikin ƙananan kusurwar dama na ƙungiyar kayan aiki Jeri.
Bayan haka taga zai bude Tsarin Cell kuma duk abubuwanda ake kara amfani da su yakamata su zama iri daya kamar yadda aka fara amfani da su. Wannan shine, zai zama dole don sarrafa kayan aikin a cikin toshe Gabatarwa a cikin shafin Jeri.
Idan kanaso jigon rubutu da kansa ya kasance a tsaye, yayin da haruffa suke a al'ada, wannan kuma ana yin shi ta amfani da maballin Gabatarwa a kan tef. Latsa wannan maɓallin kuma zaɓi abu a cikin jerin da ya bayyana. Rubutun tsaye.
Bayan waɗannan ayyuka, rubutun zai mamaye matsayin da ya dace.
Darasi: Tsarin tebur a cikin Excel
Kamar yadda kake gani, akwai manyan hanyoyi guda biyu don daidaita jigon rubutun: ta taga Tsarin Cell kuma ta hanyar maballin Jeri a kan tef. Haka kuma, dukkan wadannan hanyoyin suna amfani da tsarin ne iri guda. Kari akan haka, ya kamata ka sani cewa akwai zaɓuɓɓuka guda biyu don shirin tsaye na abubuwan da ke cikin tantanin halitta: tsari na tsaye na haruffa da kuma irin kalmomin gaba ɗaya. A ƙarshen magana, ana rubuta haruffa a matsayin da suka saba, amma a cikin shafi.
