Dash a cikin Excel. Hanyoyi 2 don sanya dash a cikin Excel

Shirin na Excel yana da dukkanin ayyukan da kuke buƙatar sani don yin aiki mai inganci tare da tebur. Saboda rashin ƙwarewa, wasu masu amfani ba za su iya saka irin wannan abu mai sauƙi kamar dash ba. Gaskiyar ita ce shigar da alamar yana da wasu matsaloli. Don haka, alal misali, yana iya zama tsayi da gajere. Abin takaici, babu alamomi na musamman akan madannai da zasu taimaka maka kewayawa da sanya harafin a daidai tsari. Saboda haka, bari mu gano yadda za a saita dash daidai ta amfani da hanyoyi da yawa.

Saka dash a cikin tantanin halitta

Ayyukan shirin Excel na samar da shigarwa na nau'i biyu na dashes - gajere da tsawo. A wasu kafofin, zaku iya samun naɗin dash a matsayin matsakaici. Zamu iya cewa wannan magana ta wani bangare daidai, tun da yake idan akwai rashin sanin ƙa'idodin shigarwa, zaku iya saka alamar ko da ƙarami - "ƙara" ko "raguwa". Gabaɗaya, akwai hanyoyi guda biyu waɗanda zaku iya saita alamar "-" a cikin tebur. Shari'ar farko ta ƙunshi shigarwa ta hanyar buga haɗin maɓalli. Na biyu yana buƙatar shigarwa cikin taga na musamman haruffa.

Magance matsalar tare da shigar da dash # 1: yi amfani da gajeriyar hanyar madannai

Wasu masu amfani da editan rubutu sun ce saita dash a cikin maƙunsar rubutu ana iya yin su kamar yadda yake a cikin Word, amma, abin takaici, wannan ba magana ce ta gaskiya ba. Bari mu kula da yadda ake yin wannan a cikin Word:

1. Rubuta "2014" akan madannai naka.
2. Riƙe haɗin maɓallin Alt+X.

Bayan aiwatar da waɗannan matakai masu sauƙi, Kalma tana saita em dash ta atomatik.

Masu haɓakawa na Excel suma sun kula da masu amfani da su kuma sun ƙirƙiri dabarun nasu don shigar da dash a cikin tebur:

1. Kunna tantanin halitta wanda ke buƙatar ƙarin daidaitawa.
2. Riƙe kowane maɓallin “Alt” kuma, ba tare da sakewa ba, rubuta ƙimar “0151” a cikin maɓalli na lamba (wanda yake gefen hagu na madannai).

Hankali! Idan saitin lambobi za a aiwatar da su a saman maballin, shirin zai tura ku zuwa menu na "File".

3. Bayan mun saki maɓallin Alt, za mu ga dash ɗin da aka nuna a cikin tantanin halitta akan allon.

Don buga ɗan gajeren hali, maimakon haɗuwa da ƙimar dijital u0151bu0150b"XNUMX", buga "XNUMX".

Wannan hanya tana aiki ba kawai a cikin Excel ba, har ma a cikin editan Word. A cewar ƙwararrun masu tsara shirye-shirye, hanyar da za a saita dash ta amfani da haɗin maɓalli za a iya amfani da ita a cikin wasu editocin html da maƙunsar rubutu.

Bayanan kula daga gwani! Alamar cirewa da aka shigar tana canzawa ta atomatik zuwa dabara, wato, lokacin da aka kunna wani tantanin halitta a cikin tebur tare da ƙayyadadden alamar, adireshin tantanin halitta mai aiki yana nunawa. A cikin yanayin shigar en dashes da em dashes, irin waɗannan ayyukan ba za su faru ba. Don cire kunna tsarin, dole ne ka danna maɓallin "Shigar".

Magani don saita dash #2: Buɗe taga halin

Akwai wani zaɓi wanda aka shigar da dash ta taga mai taimako tare da haruffa na musamman.

1. Zaɓi tantanin halitta a cikin tebur wanda ke buƙatar gyara ta latsa LMB.
2. Je zuwa shafin "Saka" da ke saman shirin a cikin kayan aiki.

3. Idan aikace-aikacen yana cikin ƙaramin matsayi, danna maɓallin dama a saman allon don buɗe sauran tubalan tare da kayan aiki.
4. A hannun dama, nemo kayan aiki na ƙarshe na “Alamomin”, wanda ke cikin toshe “Text”, sannan danna shi.
5. Wani sabon taga zai buɗe inda kake buƙatar danna maɓallin "Symbol".

6. Danna wannan maɓallin yana kunna buɗe taga tare da saitin haruffa. A ciki kana buƙatar danna "Haruffa na musamman".

7. Na gaba, zaku iya ganin jerin dogon jerin haruffa na musamman. Kamar yadda kake gani a cikin hoton, wuri na farko a cikinsa yana shagaltar da "Elong dash".

8. Danna kan layi tare da sunan alamar kuma danna maɓallin "Saka". Za ka same shi a kasan taga.
9. Tagar ba ta da aikin rufewa ta atomatik, saboda haka, bayan shigar da halin da ake buƙata a cikin tantanin halitta, rufe taga ta danna maballin ja tare da farin giciye a kusurwar dama ta sama.
10. Bayan rufe taga, zaku iya ganin cewa an saita em dash zuwa tantanin halitta da muke buƙata kuma tebur yana shirye don ƙarin aiki.

Idan kana son saita dash, bi matakan da ke sama a cikin tsari iri ɗaya, amma zaɓi “En dash” a ƙarshe. Kar a manta don kunna alamar a ƙarshen ta danna maɓallin "Saka" kuma rufe akwatin maganganu.

Bayanan kula daga gwani! Haruffan da aka shigar a hanya ta biyu sun yi daidai da waɗanda aka shigar sakamakon buga haɗin maɓalli. Ana iya ganin bambanci kawai a cikin hanyar shigarwa. Saboda haka, waɗannan haruffa ba za a iya amfani da su don ƙirƙirar dabara ko ɗaya ba.

Kammalawa

Bayan karanta labarin, ya bayyana a fili cewa akwai hanyoyin shigarwa guda biyu don saita em da en dashes. A cikin akwati na farko, kuna buƙatar amfani da gajeriyar hanyar maɓalli, kuma a cikin na biyu, buɗe taga mai haruffa na musamman, inda aka zaɓi haruffan da suka dace kuma a saita su a cikin tantanin halitta mai aiki. Dukansu hanyoyin suna ƙirƙirar alamomi iri ɗaya - tare da rufaffiyar rikodi da ayyuka iri ɗaya. Don haka, an zaɓi hanya ta ƙarshe don shigar da dash a cikin tebur bisa zaɓin mai amfani. Masu amfani waɗanda galibi suna buƙatar amfani da waɗannan haruffa sun fi son amfani da gajeriyar hanyar madannai. Ga waɗanda ba koyaushe suna fuskantar gabatarwar dash a cikin tebur ba, zaku iya iyakance kanku zuwa hanya ta biyu.