Masu amfani da yawa sun lura cewa lokacin da ke aiki a Microsoft Excel akwai lokuta a cikin sel yayin rubuta bayanai maimakon lambobi, gumakan suna bayyana a cikin nau'i (#). A dabi'a, ba shi yiwuwa a yi aiki tare da bayani a wannan tsari. Bari mu fahimci dalilan wannan matsala kuma mu sami mafita.
Matsalolin matsala
Lattice alamar (#) ko, kamar yadda ya fi dacewa da kira shi, oktotorp ya bayyana a cikin waɗannan sutunan a cikin takardar Excel, wanda bayanai ba su dace da iyakoki ba. Sabili da haka, waɗannan alamomi suna maye gurbin su, duk da cewa, a gaskiya, a yayin lissafi, shirin yana aiki tare da dabi'u na ainihi, kuma ba tare da waɗanda suke nuna akan allon ba. Duk da haka, don mai amfani ba a gano bayanin ba, sabili da haka, batun batun kawar da matsala ta dace. Tabbas, ana iya ganin cikakkun bayanan sirri tare da su ta hanyar tsari, amma ga masu amfani da yawa wannan ba wani zaɓi ba ne.
Bugu da ƙari, tsofaffin sigogi na shirin raguwa ya bayyana idan, lokacin amfani da matakan rubutu, kalmomin a cikin tantanin halitta sun fi 1024. Amma, tun daga fasalin Excel 2010, an cire wannan taƙaitaccen.
Bari mu kwatanta yadda za'a magance wannan matsala ta taswira.
Hanyar 1: Ƙara Magana
Hanyar da ta fi dacewa kuma ta fi dacewa ga mafi yawan masu amfani don fadada iyakokin tantanin halitta, kuma, sabili da haka, magance matsala na nunawa gizon maimakon lambobi, ya kamata a jawo kan iyakokin shafi.
An yi haka ne sosai. Sanya siginan kwamfuta a kan iyaka tsakanin ginshiƙai a cikin kwamiti na kulawa. Muna jira har sai mai siginan kwamfuta ya juya zuwa arrow. Muna danna tare da maballin hagu na hagu kuma, rike shi, ja kan iyakoki har sai kun ga dukkanin bayanai sun dace.
Bayan kammala wannan hanyar, tantanin halitta zai kara, kuma Figures zasu bayyana a maimakon ginin.
Hanyar 2: Gyara rage
Tabbas, idan akwai guda ɗaya ko biyu ginshiƙai wanda bayanai basu shiga cikin kwayoyin ba, yana da sauki don gyara halin da ake ciki kamar yadda aka bayyana a sama. Amma abin da za a yi idan akwai irin wadannan ginshiƙai. A wannan yanayin, zaka iya amfani da rageccen nau'in don warware matsalar.
- Zaɓi yankin da muke so mu rage font.
- Da yake cikin shafin "Gida" a kan tef a cikin asalin kayan aiki "Font" bude samfurin canza tsarin. Mun sanya mai nuna alama ya zama ƙasa da wanda aka nuna yanzu. Idan har yanzu bayanai bazai shiga cikin kwayoyin ba, to, saita sigogi har ma ƙananan har sai an sami sakamako mai so.
Hanyar 3: Width ta atomatik
Akwai wata hanya don canza launin a cikin sel. Ana gudanar da shi ta hanyar tsarawa. A lokaci guda, girman haruffan bazai kasance iri ɗaya ba don dukan jigon, kuma a cikin kowane shafi akwai matakan da za su dace don dace da bayanai a tantanin halitta.
- Zaži kewayon bayanan da za mu yi aiki. Danna maballin linzamin dama. A cikin mahallin menu, zaɓi darajar "Tsarin tsarin ...".
- Tsarin tsarin ya buɗe. Jeka shafin "Daidaitawa". Sa tsuntsu kusa da saitin "Width Auto". Don gyara canje-canje, danna maballin. "Ok".
Kamar yadda ka gani, bayan wannan, lakabi a cikin kwayoyin sun rage girman isa don cikakkun bayanai a cikinsu.
Hanyar 4: canza tsarin lambobi
A farkon, akwai tattaunawa da cewa a cikin tsofaffin fasali na Excel an ƙayyade iyaka a kan adadin haruffan a cikin sel guda yayin shigar da tsarin rubutu. Tun da yawancin masu amfani suna ci gaba da amfani da wannan software, bari mu zauna akan maganin wannan matsala. Don kewaye da wannan iyakance, dole ne ka canza tsarin daga rubutu zuwa gaba ɗaya.
- Zaɓi yankin da aka tsara. Danna maballin linzamin dama. A cikin menu da ya bayyana, danna kan abu "Tsarin tsarin ...".
- A cikin tsarin tsarawa je shafin "Lambar". A cikin saiti "Formats Matsala" canza darajar "Rubutu" a kan "Janar". Muna danna maɓallin "Ok".
Yanzu an cire ƙuntatawa kuma za'a nuna adadin haruffa a cikin tantanin halitta.
Hakanan zaka iya canza tsarin kan rubutun a cikin shafin "Gida" a cikin asalin kayan aiki "Lambar"ta hanyar zaɓar darajar da ta dace a cikin tarar ta musamman.
Kamar yadda kake gani, maye gurbin kytotorp tare da lambobi ko wasu bayanai daidai a cikin Microsoft Excel ba haka ba ne mai wuya. Don yin wannan, dole ne ka yada fadin ginshiƙai ko rage font. Don tsofaffin sassan shirin, canja tsarin rubutun zuwa na kowa yana dacewa.
