Shoko rine zvigadziriso zvinokutendera kuti ushandure otomatiki makotesheni kuita kaviri makotesheni (makotesheni akakomberedzwa nenzira yakakosha) paunenge uchinyora. Zvisinei, dzimwe nguva mashoko akatwasanuka anodiwa mugwaro, kureva kuti mamwe mapeya anofanira kutsiviwa odzorerwa.
Pane zvikonzero zvakawanda zvekutsiva makotesheni maviri neakatwasuka makotesheni. Tinoda kukuratidza nzira iri nyore yekushandura makotesheni uchishandisa chishandiso Tsvaga uye Tora (Tsvaga uye tsiva).
Usati waenderera mberi nekutsiva, dzima kutsiva otomatiki kweakatwasuka makotesheni neakapetwa muzvirongwa. Muzvinyorwa zvakapfuura, takaratidza kuti iyi gadziriro inogadziriswa sei. Iwe unofanirwa kuvhura iyo autoformat marongero nenzira imwechete uye kudzima quote kutsiva.
Mushure mekunge sarudzo yadzimwa, tinya Ctrl + Hkuvhura dialog Tsvaga uye Tora (Tsvaga uye tsiva).
Isa maquotation marks mundima Tsvaga chii (Tsvaga) uye Tsiva ne (Siva ne), uye tinya Dzorera (Tsvaura). Excel ichakutsvagira makotesheni ekutanga. Kana ari kaviri makotesheni, tinya Dzorera (Tsvanura) kuvatsiva nemakotesheni akatwasuka.
Nenzira imwecheteyo, unogona kuwana oblique apostrophes uye wovatsiva neakatwasuka.
Cherechedza: Kana uchitsvaga uine wildcards akabatidzwa, shandisa mavara macode kuenderana nemakotesheni. Kutsvaga kwakajairika hakusiyanise pakati pemakotesheni maviri nemakotesheni akatwasuka, asi wildcard kutsvaga kunoita. Kana uri kushandisa wildcards, bata pasi kiyi alt uye isa kodhi yaunoda uchishandisa kiyi yepadhi yenhamba mumunda Tsvaga chii (Tsvaga) inoenderana neunhu hunodiwa: 0145 - kuvhura apostrophe; 0146 - kuvhara apostrophe; 0147 - mazwi ekuvhura; 0148 - mazwi ekuvhara.
Mushure memaitiro ese anotsanangurwa muchinyorwa chino, usakanganwa kugonesa zvakare sarudzo yekutsiva yakatwasuka makotesheni nekaviri makotesheni, hongu, kana uchiida.