Yawancin masu amfani na Excel suna da matsala mai yawa da suke ƙoƙari su saka dash a kan takarda. Gaskiyar ita ce, shirin ya fahimci dash a matsayin alamar musa, kuma nan da nan ya canza dabi'u a tantanin halitta a cikin wani tsari. Saboda haka, wannan tambaya tana da gaggawa. Bari mu kwatanta yadda ake sanya dash a Excel.
Dash a Excel
Sau da yawa idan kun cika da takardu daban-daban, rahotanni, bayyane, kuna buƙatar nuna cewa tantanin salula din daidai da wani alamar bai ƙunshi dabi'u ba. Ga waɗannan dalilai yana da al'ada don amfani da dash. Domin shirin na Excel, wannan damar ya kasance, amma yana da matsala sosai don fassara shi don mai amfani ba tare da shirye ba, tun lokacin da aka canza shi zuwa wata hanya. Don kauce wa wannan canji, kana buƙatar yin wasu ayyuka.
Hanyar 1: Tsarin Range
Hanyar da ya fi shahara don saka dash a cikin tantanin halitta shi ne sanya wani tsarin rubutu zuwa gare ta. Gaskiya, wannan zaɓi baya taimakawa koyaushe.
- Zaɓi tantanin halitta wanda zaka sanya dash. Danna kan shi tare da maɓallin linzamin linzamin dama. A cikin mahallin menu wanda ya bayyana, zaɓi abu "Tsarin Tsarin". Kuna iya maimakon danna maɓallin gajeren hanya a kan keyboard Ctrl + 1.
- Tsarin tsarin ya fara. Jeka shafin "Lambar"idan an bude shi a wani shafin. A cikin fasalin fasali "Formats Matsala" zaɓi abu "Rubutu". Muna danna maɓallin "Ok".
Bayan haka, za a sanya maɓallin zaɓaɓɓun kayan kayan rubutu. Duk dabi'un da aka shigar da shi za a gane ba a matsayin abubuwa don lissafi ba, amma a matsayin rubutu mai rubutu. Yanzu, a cikin wannan yanki, za ka iya shigar da harafin "-" daga keyboard kuma zai bayyana a matsayin dash, kuma ba za a iya ganin shirin ba a matsayin alamar musa.
Akwai wani zaɓi don sake fasalin tantanin halitta a cikin rubutun rubutu. Don wannan, zama a cikin shafin "Gida", kana buƙatar danna kan jerin jerin bayanai, wanda aka samo a kan tef a cikin akwatin kayan aiki "Lambar". An buɗe jerin jerin samfurori. A wannan lissafi kawai kuna buƙatar zaɓar abu "Rubutu".
Darasi: Yadda za a canza tsarin salula a Excel
Hanyar 2: Latsa maɓallin shigarwa
Amma wannan hanya ba ta aiki a duk lokuta. Sau da yawa, ko da bayan kammala wannan hanya, idan ka shigar da "-" hali, maimakon alamar da kake buƙata, duk waɗannan nassoshi akan wasu jeri suna bayyana. Bugu da ƙari, ba sau da yawa dacewa, musamman idan a cikin tebur temi tare da dashes madadin tare da sel cika da bayanai. Da fari dai, a wannan yanayin dole ne ka tsara kowane ɗayan su daban, na biyu, sassan wannan tebur za su sami tsari daban-daban, wanda ba ma karɓa ba ne. Amma ana iya aikatawa daban.
- Zaɓi tantanin halitta wanda zaka sanya dash. Muna danna maɓallin "Cibiyar Align"wanda yake a kan rubutun a cikin shafin "Gida" a cikin ƙungiyar kayan aiki "Daidaitawa". Kuma danna maballin "Daida a tsakiyar", wanda yake a cikin wannan shinge.Da wajibi ne don cewa dash yana tsakiyar tsakiya, kamar yadda ya kamata, kuma ba a hagu ba.
- Muna buga cikin tantanin halitta daga maballin alamar "-". Bayan haka, ba muyi wani motsi tare da linzamin kwamfuta ba, amma nan da nan danna maballin Shigardon zuwa layi na gaba. Idan maimakon mai amfani ya danna linzamin kwamfuta, to wannan ma'anar zai sake fitowa a cikin tantanin halitta inda dash ya tsaya.
Wannan hanya ce mai kyau ga sauƙinta kuma yana aiki tare da kowane irin tsarawa. Amma, a lokaci guda, yin amfani da shi, kana buƙatar ka mai da hankali da gyara kayan ciki na tantanin halitta, saboda, saboda rashin kuskuren aiki, wata maƙirar zata iya sake bayyanawa maimakon dash.
Hanyar 3: saka hali
Wani mawallafi na dash a Excel shine saka wani hali.
- Zaɓi tantanin halitta inda kake so sakawa dash. Jeka shafin "Saka". A tef a cikin asalin kayan aiki "Alamomin" danna maballin "Alamar".
- Da yake cikin shafin "Alamomin", saita filin a taga "Saita" saiti Alamun Madogara. A tsakiyar ɓangaren taga, bincika alamar "─" kuma zaɓi shi. Sa'an nan kuma danna maballin Manna.
Bayan haka, ana nuna dash a cikin cell da aka zaba.
Akwai wani zaɓi don aiki a cikin wannan hanya. Kasancewa a taga "Alamar", je shafin "Alamun musamman". A cikin jerin da ya buɗe, zaɓi abu "Dash dash". Muna danna maɓallin Manna. Sakamakon zai zama daidai kamar yadda aka yi a baya.
Wannan hanya yana da kyau saboda ba ka buƙatar ka ji tsoron abin da ba daidai ba ya yi ta linzamin kwamfuta. Alamar har yanzu ba ta canja zuwa wannan tsari ba. Bugu da ƙari, dash da aka gani ta wannan hanya ya fi kyau fiye da wani ɗan gajeren hali da aka buga daga keyboard. Babban hasara na wannan zaɓi shi ne buƙatar yin maniputa da yawa sau ɗaya, wanda ya haɗa da hasara ta wucin gadi.
Hanyar 4: ƙara ƙarin haruffa
Bugu da ƙari, akwai wata hanya ta saka dash. Duk da haka, a gani wannan zabin bai yarda da duk masu amfani ba, tun da yake yana ganin kasancewar wani alama a cikin tantanin halitta, sai dai don ainihin "-" alama.
- Zaɓi tantanin da kake so ka saita dash, sa'annan ka sanya shi daga cikin keyboard kalmar "'". An samo shi a kan maɓallin guda kamar harafin "E" a cikin layi na Cyrillic. Nan da nan kuma ba tare da sararin samaniya ya saita hali "-".
- Muna danna maɓallin Shigar ko zaɓi tare da siginan kwamfuta tare da linzamin kwamfuta duk wani tantanin halitta. Lokacin amfani da wannan hanya ba muhimmiyar mahimmanci ba ce. Kamar yadda kake gani, bayan wadannan ayyukan, an sanya alamar dash a kan takarda, kuma ƙarin alama ta "'" ana iya gani ne kawai a cikin tsari lokacin da aka zaba cell.
Akwai hanyoyi da yawa don sanya dash a cikin tantanin halitta, zaɓin tsakanin wanda mai amfani zai iya yin bisa ga manufar amfani da takamaiman takardun. Yawancin mutane suna ƙoƙari su canza tsarin tsarin sel yayin da suka fara kokarin sanya nau'in da ake so. Abin baƙin ciki, wannan ba koyaushe ke aiki ba. Abin farin, akwai wasu zaɓuɓɓukan don yin wannan aiki: motsawa zuwa wani layi ta amfani da maɓallin Shigar, yin amfani da haruffa ta hanyar maballin akan tef, aikace-aikace na ƙarin harafin "'". Kowane irin waɗannan hanyoyin yana da amfani da rashin amfani, waɗanda aka bayyana a sama. Babu wani zaɓi na duniya wanda zai fi dacewa da shigar da dash a Excel a duk yanayi.
