Dash muExcel. 2 nzira dzekuisa dashi muExcel

Chirongwa cheExcel chine seti yemabasa aunoda kuziva kuti uite basa remhando yepamusoro nematafura. Nekuda kwekushaya ruzivo, vamwe vashandisi havakwanise kuisa chinhu chakareruka senge dash. Chokwadi ndechekuti kuiswa kwechiratidzo kune zvimwe zvinonetsa. Saka, semuenzaniso, inogona kuva yakareba uye pfupi. Nehurombo, hapana akakosha zviratidzo pane kiibhodhi kuti akubatsire kufamba uye nekuisa iyo hunhu mune chaiyo fomu. Saka, ngationei kuti tingaisa sei dashi nenzira yakarurama uchishandisa nzira dzakawanda.

Kuisa dash muchitokisi

Kushanda kwechirongwa cheExcel kunopa kuiswa kwemhando mbiri dzemadheshi - mapfupi uye marefu. Mune mamwe masosi, unogona kuwana kudomwa kween dash seavhareji. Tinogona kutaura kuti chirevo ichi chikamu chakarurama, sezvo mukusaziva kwemitemo yekuisa, unogona kuisa chiratidzo chiduku - "hyphen" kana "minus". Pakazara, pane nzira mbiri dzaunogona kuseta "-" chiratidzo mutafura. Yekutanga nyaya inosanganisira kuisirwa nekunyora kiyi musanganiswa. Yechipiri inoda kupinda muhwindo remavara anokosha.

Kugadzirisa dambudziko nekuisa dash # 1: shandisa nzira yekudimbudzira keyboard

Vamwe vashandisi vezvinyorwa zvekunyora vanoti kuisa dash muspredishiti kunogona kuitwa nenzira imwechete senge muShoko, asi, zvinosuruvarisa, ichi hachisi chirevo chechokwadi. Ngatitarisei maitiro ekuita izvi muIzwi:

1. Nyora "2014" pane kiibhodhi yako.
2. Bata pasi Alt+X kiyi musanganiswa.

Mushure mekuita nhanho idzi dzakareruka, Shoko rinogadzika iyo em dash.

Vagadziri veExcel vakatarisirawo vashandisi vavo uye vakagadzira yavo nzira yekupinda em dash mutafura:

1. Activate sero rinoda kumwe kugadziridzwa.
2. Bata pasi chero "Alt" kiyi uye, pasina kuburitsa, nyora kukosha kwe "0151" mubhuroka renhamba (iri kuruboshwe rwekhibhodi).

Chenjerera! Kana iyo seti yenhamba ichaitwa kumusoro kwekhibhodi, ipapo chirongwa chinokuendesa kune "Faira" menyu.

3. Mushure mekuburitsa kiyi yeAlt, tichaona em dash inoratidzwa muchitokisi pachiratidziri.

Kufona chidimbu chipfupi, pachinzvimbo chemusanganiswa wemadhijitari u0151bu0150b”XNUMX”, dial “XNUMX”.

Iyi nzira inoshanda kwete chete muExcel, asiwo muIzwi mupepeti. Zvinoenderana nenyanzvi dzekugadzira zvirongwa, nzira yekuseta dash uchishandisa kiyi misanganiswa inogona kushandiswa mune mamwe html uye spreadsheet vapepeti.

Cherechedza kubva kune nyanzvi! Iyo yakapinda minus sign inoshandurwa otomatiki kuita fomula, ndiko kuti, kana imwe sero mutafura ine chiratidzo chakatarwa chaitwa, kero yesero rinoshanda rinoratidzwa. Munyaya yekupinda en dashes uye em dashes, zviito zvakadaro hazvizoitiki. Kuti ubvise activation yeformula, unofanirwa kudzvanya "Enter" kiyi.

Mhinduro yekuseta dash #2: Kuvhura iyo hunhu hwindo

Pane imwe sarudzo iyo dash inopinzwa nepahwindo rinobatsira rine mavara akakosha.

1. Sarudza sero riri patafura rinoda kugadziriswa nekudzvanya LMB.
2. Enda ku "Insert" tab iri pamusoro pechirongwa mubhara rekushandisa.

3. Kana iyo application iri munzvimbo yakaderedzwa, tinya bhatani rekurudyi kumusoro kwechidzitiro kuti uvhure mamwe mabhuraki nematurusi.
4. Kurudyi, tsvaga chishandiso chekupedzisira "Symbols", chiri mu "Text" block, uye tinya pairi.
5. Hwindo idzva richavhura paunoda kudzvanya bhatani re "Symbol".

6. Kudzvanya bhatani iri kunoita kuti kuvhurwa kwehwindo rine mavara seti. Mariri unofanira kudzvanya "Special characters".

7. Tevere, unogona kuona runyorwa rurefu rwemavara akakosha. Sezvauri kuona mumufananidzo, nzvimbo yekutanga mairi inogarwa ne "Elong dash".

8. Dzvanya pamutsetse une zita rechiratidzo uye tinya bhatani rekuti "Isa". Iwe uchaiwana pazasi pehwindo.
9. Hwindo harina otomatiki yekuvhara basa, saka, mushure mekuisa chimiro chinodiwa muchitokisi, vhara hwindo nekudzvanya bhatani dzvuku nemuchinjikwa muchena mukona yekurudyi.
10. Mushure mekuvhara hwindo, unogona kuona kuti em dash yakaiswa kune sero yatinoda uye tafura yakagadzirira rimwe basa.

Kana iwe uchida kuseta en dash, tevera matanho ari pamusoro muhurongwa hwakafanana, asi sarudza "En dash" kumagumo. Usakanganwa kumisa chiratidzo kumagumo nekudzvanya bhatani re "Insert" uye vhara iyo dialog box.

Cherechedza kubva kune nyanzvi! Mavara apinzwa nenzira yechipiri anoenderana zvizere neakapinda semhedzisiro yekutaipa kiyi musanganiswa. Kusiyana kunogona kuonekwa chete mukugadzirisa nzira. Naizvozvo, mavara aya haagone kushandiswa kugadzira mafomula.

mhedziso

Mushure mekuverenga chinyorwa, zvinova pachena kuti kune nzira mbiri dzekuisa dzekuisa em uye en dashes. Muchiitiko chekutanga, iwe uchada kushandisa nzira yekudimbudzira yekhibhodi, uye yechipiri, vhura hwindo rine mavara akakosha, apo mavara anodiwa anosarudzwa uye akaiswa musero inoshanda. Nzira mbiri idzi dzinogadzira zviratidzo zvakafanana - zvine encoding yakafanana uye kushanda. Naizvozvo, nzira yekupedzisira yekuisa dash mutafura inosarudzwa zvichienderana nezvinodiwa nemushandisi. Vashandisi vanowanzoda kushandisa mavara aya vanofarira kushandisa nzira yekudimbudzira kiibhodhi. Kune avo vasingagare vachisangana nekusumwa kwedash mutafura, unogona kuzviganhurira iwe kune yechipiri nzira.