Maitiro ekuchinja comma kusvika padanho muExcel

Izvo zvinozivikanwa kuti muRussia-mutauro wenguva yeUnyeseri, comma inoshandiswa seyakagoverwa zviratidzo, nepo panguva yekutaura Chirungu. Izvi zvinokonzerwa nekuvapo kwemitemo dzakasiyana siyana munzvimbo ino. Uye zvakare, munyika inotaura Chirungu, inogamuchirwa seyakapatsanurwa yekupararira kushandisa comma, uye isu tine poindi. Nekudaro, zvinokonzera dambudziko kana mushandisi anovhura iyo faira yakagadzirwa muchirongwa ichi neimwe nzvimbo. Izvo zvinouya kune iyo nzvimbo iyo Excel haina kana kufunga formula, sezvo zvisizvo zviratidzo zvatinonzwisisa. Mune ino kesi, iwe unofanirwa kushandura iyo yekubatana kwechirongwa mumamiriro ezvinhu, kana kutsiva mavara mugwaro. Ngatitsvagei kuti uchinje sei comma kusvika padanho iri mukushandisa uku.

Tsiva maitiro

Usati waenderera kutsiva, zvinodikanwa kuti unzwisise zvese pane zvese zvaunogadzira. Chinhu chimwe chete kana iwe ukashandisa maitiro aya nekuda kwekungonaka zvirinani kuona iyo pfungwa seyekuparadzanisa uye usaronga kushandisa nhamba idzi mukuverenga. Chimwezve chinhu kana iwe uchifanira kuchinja chiratidzo chaicho chekuverenga, sezvo mune ramangwana gwaro rinozoitwa mune yeChirungu vhezheni yeExcel.

Nzira 1: "Tsvaga uye dzorera" Tool

Nzira iri nyore yekuita semicolon shanduko ndeyekushandisa kwe "tsvaga uye kutsiva" chishandiso. Asi, pakarepo, zvinofanirwa kucherechedzwa kuti nzira iyi haina kukodzera kuverenga, nekuti zviri mukati memasero zvichashandurwa kuita chimiro.

1. Isu tinogadzira kusarudzwa kwenzvimbo pane pepa raunoda kushandura makambani pane mapoinzi. Ita bhatani rekurudyi rebuse kurudyi. Mukutanga mamiriro menyu, isu tinoisa chinhu icho "cell form fomati ...". Vashandisi ivavo vanosarudza kunakidzwa neimwe nzira yekushandisa ne "zvinopisa makiyi", mushure mekusarudzwa kunogona kufonera ctrl + 1 kiyi musanganiswa.



2. Hwindo rekugadzira rinotangwa. Isu tinoita kuti kufamba mu "nhamba" tab. Muboka reParameter "manhamba mafomu", tinoita kuti kusarudzwa kune "zvinyorwa". Kuti uchengetedze shanduko dzakaitwa, tinya pane "OK" bhatani. Iyo data yedata mune yakasarudzwa renzande ichashandurwa kuva mavara.



3. Zvakare kugovera iyo tarisiro renji. Uyu ibhuku rakakosha, nekuti pasina kugoverwa kwekutanga, shanduko ichagadzirwa munzvimbo yese yepepa, uye izvi hazviwanzo kuve zvakafanira. Mushure mekunge nharaunda yasimbiswa, ichifamba mu "imba" tab. Dzvanya pane iyo "Tsvaga uye sarudza" bhatani, iyo iri mu "kugadzirisa" chishandiso "block block pane tepi. Ipapo menyu madiki anovhura, umo iwe unofanirwa kusarudza "kutsiva ...".



4. Mushure meizvozvo, iyo "tsvaga uye kutsiva" chishandiso chinotangwa mukutsiva tab. Mu "tsvaga" munda, tinoisa chiratidzo ",", uye mumunda "kutsiva" - ".". Dzvanya pane "chinja zvese" bhatani.



5. Iwindo ruzivo rwunovhura, rinopa chirevo pane shanduko yakaitwa. Isu tinoita tinya pane "OK" bhatani.

Chirongwa ichi chinoita shanduko yekuchinja kwe comma kune nzvimbo dzakazvitsaurira. Iri basa rinogona kutariswa rakagadziriswa. Asi zvinofanirwa kurangarirwa kuti iyo data yakatsiviwa nenzira iyi ichave nerugwaro rwemavara, uye saka haizokwanise kushandiswa mukuverenga.

Chidzidzo: Zviratidzo kutsiva muExcel

Nzira 2: Basa rekushandisa

Iyo yechipiri nzira inoreva kushandiswa kweanoshanda kune chinzvimbo. Kutanga, uchishandisa ichi chimiro, isu tinotsanangura data mune yakaparadzana, uye wobva azvichengeta kunzvimbo yeiyo yekutanga.

1. Sarudza cell cell yakatarisana neCode yekutanga ye data renji umo makomi anofanirwa kushandurwa kusvika padanho. Dzvanya pane iyo "Insert basa" icon, yakaiswa kuruboshwe rweiyo formula tambo.



2. Mushure meizvi zviito, tenzi wemabasa achazotangwa. Tiri kutsvaga muchikamu "bvunzo" kana "yakazara alfabhethi rondedzero" zita "rinotsiva". Isu tinoratidza uye tinya pane iyo "OK" bhatani.



3. Nhaurwa dzebasa dzinovhura. Iyo ine nharo nhatu dzekumanikidzwa "zvinyorwa", "zvinyorwa zvekare" uye "zvinyorwa zvitsva". Mu "zvinyorwa", iwe unofanirwa kutsanangura kero yesero panofanira kuchinjwa data. Kuti uite izvi, isa chikwangwani mumunda uyu, wobva wadzvanya mbeva pane pepa riri muchitokisi chekutanga chebhendi inoshanduka. Pakarepo mushure me kero iyi ichaonekwa muhwindo rekupokana. Mu "zvinyorwa zvekare", tinoisa chiratidzo chinotevera - ",". Mu "zvinyorwa zvitsva", tinoisa pfungwa yacho - ".". Mushure meiyo data yakagadzirwa, tinya pane "OK" bhatani.



4. Sezvauri kuona, nechero yekutanga, shanduko iri kubudirira. Kuvhiya kwakadaro kunogona kuitwa kune mamwe masero ese eiyo yaunoda. Zvakanaka, kana rurami iri idiki. Asi zvekuita kana zvikaitika zvemhando dzakasiyana-siyana? Kupfuura zvese, kushandura nenzira yakafanana, mune ino kesi, huwandu hwakakura hwenguva huchatora. Asi, maitiro anogona kuve akanyanya kukwidziridzwa nekukoka fomula kuti atange kubatsirwa nerubatsiro rwemucherechedzo.

   Isu tinogadza iyo inotsemura kumucheto wakadzika wesero, iyo ine basa. Mucherechedzo wekuzadza fomu remuchinjiro diki anooneka. Pusha bhatani rekuruboshwe mbeva uye kudhonza iyi muchinjiko kufanana nenzvimbo yaunoda kushandura commas kusvika padanho.



5. Sezvauri kuona, zvese zviri mukati meiyo tarisiro huwandu hwakashandurwa kuita data ine mapoinzi pane makondari. Zvino iwe unofanirwa kutevedzera mhedzisiro uye kuisa munzvimbo inobva sosi. Sarudza masero ane formula. Ndichiri muTabha Pamba, tinya pane bhatani pane "Kopa" tepi, iyo iri mu "Buffer" Toolbu. Inogona kuitwa uye nyore, kureva, mushure mekusarudza iyo renji, kufonera iyo kiyi musanganiswa pane kabhodhi yekhibhodi + 1.



6. Sarudza huwandu hwepakutanga. Dzvanya kuratidza iyo kurudyi mbeva bhatani. Mameseji menyu anooneka. Mukati maro, iwe unoita tinya pane "kukosha" chinhu, icho chiri mu "isa parameter" boka. Chinhu ichi chinoratidzwa nenhamba "123".



7. Mushure meizvi zviito, izvo zvinokosheswa zvichaiswa mumhando yakakodzera. Panguva imwecheteyo, commas ichashandurwa kuita mapoinzi. Kuti ubvise nharaunda yaunotadza, yakazadzwa neFormas, simbisa iyo uye tinya bhatani rekurudyi re mbeva. Mune menyu inoonekwa, sarudza iyo "yakajeka zvemukati" chinhu.

Kushandura data pane shanduko yekomfeni kusvika padanho raitwa, uye zvinhu zvese zvisina kukodzera zvinobviswa.

Chidzidzo: Wizard mabasa muExcel

Nzira 3: Macro Shandisa

Nzira inotevera yekuchinja kwemakomichi mune mapoinzi inosanganiswa nekushandiswa kweMacros. Asi, nyaya ndeyekuti neiyo default macros muExle yakaremara.

Chekutanga pane zvese, macros inofanira kugoneswa, pamwe nekumisa iyo yekuvandudza tab, kana ikasatorwa muchirongwa chako. Mushure meizvozvo, iwe unofanirwa kuita zvinotevera zviito:

1. Isu tinofambisa kune "yekuvandudza" tab uye tinya pane "Visual Basic" bhatani, iro rakaiswa mu "kodhi" bhokisi rekushandisa patepi.



2. Macros anovhura. Isu tinoita iyo inotevera code isa:

   Sub Macro_transformation___V_V_CHKI ()

   Seclection.COPPA chii: = ", kutsiva: =". "

   Kupera sub.

   Isu tinopedzisa kushanda kwemupepeti neiyo nzira yekudzvanya nekudzvanya bhatani rekuvhara mukona yekurudyi kurudyi.



3. Tevere, isu tinogovera iyo nzvimbo iyo shanduko inofanira kuitwa. Dzvanya pane "macros" bhatani, iyo iri mune ese muboka rimwe chete rekodhi zvekushandisa.



4. Iyo hwindo rinovhura nerondedzero yeMacros inowanikwa mubhuku. Sarudza iyo ichangobva kugadzirwa kuburikidza neMupepeti. Mushure mekunge wasarudza tambo nezita rayo, tinya pane "run" bhatani.

Kutendeuka kunoitwa. Commas ichashandurwa kuita mapoinzi.

Chidzidzo: Maitiro ekugadzira macro muExcel

Nzira 4: Excel Zvirongwa

Nzira inotevera ndiyo yega iri pamusoro apa, umo kana kushandura makambani pane mapoinzi, kutaura kuchaonekwa nechirongwa sehuwandu hwenhamba, uye kwete chinyorwa. Kuti tiite izvi, isu tichazoda kuchinja hurongwa hwekuparadzaniswa muChinyorwa cheChinyorwa kusvika padanho.

1. Kuva mu "Faira" tab, tinya pazita re "parameter" block.



2. Mune parameter hwindo, isu tinoenda kune "yepamusoro" Subsection. Isu tinoburitsa kutsvaga kweiyo "kurongedza paramita" marongero ezvivakwa. Isu tinobvisa bhokisi rekutarisa padhuze kukosha "shandisa system kuparadzaniswa". Zvadaro, muchikamu "chinoparadzanisa chikamu chose uye chifeve" chatinoburitsa "," "pa". ". Kupinda parameter, tinya pane "OK" bhatani.

Mushure mezviri pamusoro, kambani, iyo yaishandiswa sevaparadzaniswa kuti zvidimbu zvidimbu, zvichashandurwa kuita mapoinzi. Asi, chinhu chikuru, kutaura kwavanoshandiswa kucharamba kuchiverengera, uye hakuzozoshandurwi kune zvinyorwa.

Kune nzira dzinoverengeka dzekushandura matanda akadekira mune excel zvinyorwa. Dzakawanda dzezvisarudzo izvi zvinoratidza shanduko yedata nemavara mavara. Izvi zvinotungamira kune chokwadi chekuti chirongwa hachigone kusanganisira izvi kutaura mukuverenga. Asi kune zvakare nzira yekuita shanduko yemakomichi mune mapoinzi uchiramba uchichengetedza nzvimbo yekugadzira. Kuti uite izvi, iwe uchazoda kuchinja marongero echirongwa pachawo.