Maitiro ekuverenga nhamba yemashoko muExcel spreadsheet cell

MuMicrosoft Office Excel, unogona kuverenga nhamba yezvinhu zvakanyorwa mumaseru etafura. Nokuda kweizvi, nzira iri nyore inowanzoshandiswa. Ruzivo rwakadzama nezvenyaya iyi ruchaburitswa muchinyorwa chino.

Nzira dzekuverenga mazwi muExcel masero

Pane nzira dzakati wandei dzekuita basa rakapihwa, imwe neimwe inoda kudzidza kwakadzama kuti unzwisise zvizere. Zvadaro, tichataura pamusoro pezvakareruka uye zvinonyanya kushanda kwavari.

Method 1: manual kuverenga

Iyi nzira haina kunyatsokodzera MS Excel, zvisinei neshanduro yayo, nekuti. chirongwa ichi chinoshandisa otomatiki maturusi ekuverenga. Nekudaro, zvinokurudzirwawo kufunga nezve account account mukati mechimiro chechinyorwa. Kuti ishandiswe inodiwa:

1. Gadzira rondedzero yetafura yekutanga.
2. Sarudza nekudzvanya bhatani rekuruboshwe mbeva sero yaunoda kuverenga mazwi.
3. Verenga zvinhu zvakaunganidzwa.
4. Kuti urege kurasikirwa nenguva yako, unogona kukopa zviri mukati mesero, iyo inoratidzwa zvachose mumutsara wekupinda mafomula, uye woiisa mundima yekushanda yenzvimbo yakakosha yekukurumidza kuverenga nhamba yemavara, mazwi.

Teerera! Kuverenga mazwi muExcel masero nemaoko hazvishande kana tafura ine ruzivo rwakawandisa.

Nzira 2: Kushandisa Microsoft Office Word

Mune chinyorwa edhita, mazwi ese akataipa anoverengerwa otomatiki uye nhamba yavo inoratidzwa pachiratidziri. Kuti ushandise nzira iyi, mushandisi weExcel achada:

1. Simbisa LMB yemazwi ari mucell cell kuti uwedzere kuverenga nhamba yawo.
2. Chinja kiyibhodhi kuenda kuChirungu dhizaini uye panguva imwe chete bata pasi "Ctrl + C" makiyi kukopa mavara akasarudzwa kuclipboard.
3. Vhura mavara edhita MS Word.
4. Isa mutsara wembeva pakutanga kwechikamu chekushanda chechirongwa uye tinya "Ctrl + V" mabhatani kubva pane keyboard.
5. Tarisa mhinduro. Zvinhu zvakakopwa kubva kuExcel zvinofanirwa kunamirwa muIzwi pasina matambudziko.
6. Teerera kukona yezasi kuruboshwe yepepa rebasa rechirongwa. Taskbar icharatidza nhamba yemazwi akanyorwa parizvino.

Mamwe Mashoko! Excel haina chishandiso chekuverenga mazwi mumasero, nekuti iyi software haina kugadzirwa kuti ishande nemavara.

Nzira 3: Kushandisa Basa Rinokosha

Iyi ndiyo yakanyanya kunaka uye inokurumidza nzira yekuverenga mazwi mumasero, Excel mitsara. Kuti uwane nekukurumidza huwandu hwezvinhu zvinodiwa, mushandisi anozofanirwa kutora akati wandei nhanho zvichienderana nealgorithm:

1. Sarudza chero sero isina chinhu papepa rekushanda rechirongwa. Mhedzisiro yekuverenga icharatidzwa mairi mune ramangwana.
2. Isa mutsara wembeva mumutsara wekuisa mafomula pamusoro pechirongwa uye nyora chirevo chinotevera kubva pane keyboard: "=RERERE(TRIMSPACES(nharo))-DLSTR(SUBSTITUTE(nharo;» «;»»))+1".
3. Panzvimbo pezwi rokuti "Kukakavadzana", kero yesero umo kuverenga kunoitwa kunoratidzwa.

4. Mushure mekunyora fomula, unofanirwa kudzvanya "Enter" kuti uisimbise.
5. Tarisa mhinduro. Sero rakambosarudzwa rinenge riine nhamba inoenderana nehuwandu hwemazwi echinhu chiri kutaurwa.

Maitiro ekuverenga nhamba yemavara muExcel cell

Dzimwe nguva vashandisi veExcel vanofanirwa kuverenga huwandu hwemavara mune imwe sero yetafura array. Kuverenga zviratidzo zviri nyore pane mazwi. Kune nzira dzakawanda dzechinangwa ichi, izvo zvichakurukurwa pasi apa.

Method 1: manual kuverenga

Iyi nzira yakafanana neyekare yakakurukurwa muchikamu chekutanga chechinyorwa. Kuti uishandise, mushandisi achada kusarudza imwe sero yeplate uye kuverenga hunhu hwega hwega mairi.

Zvinokosha! Panogona kuve neakawanda mavara mumaseru eMicrosoft Office Excel tafura, izvo zvinotora nguva yakati wandei kuverenga nemaoko. Nokudaro, kuverenga nemaoko kunokosha kana zvasvika kune ndiro duku.

Nzira 2: Kushandisa Basa Kuverenga Kureba Kwetambo

Excel ine yakakosha formula inobvumidza iwe kuverenga zvinhu mumutsara. Kuti uishandise, unofanirwa kuita akati wandei nhanho dziri nyore maererano nemirairo:

1. Nekiyi yekuruboshwe yemanipulator, sarudza mutsara usina chinhu, sero umo mhedzisiro yekuverenga mavara icharatidzwa.
2. Fambisa mutsara wembeva kumutsara wekuisa mafomula kumusoro kwehwindo rechirongwa uye nyora chirevo: "=DLSTR(nharo)». Panzvimbo pekupokana, kero yeimwe sero inoratidzwa, paunoda kutsvaga nhamba yemavara.

3. Dzvanya "Enter" kana fomula yakanyorwa kuti isimbise kuita kwayo.
4. Tarisa mhinduro. Chinhu chambotaurwa chicharatidza kukosha kwenhamba inoenderana.

Nzira 3: Kushandisa nzvimbo dzakakosha paInternet

Iwe unogona kuenda neimwe nzira yakaoma kuverenga nhamba yemavara mumasero eExcel tafura array. Inosanganisira zvinotevera zviito zvinoenderana nealgorithm:

1. Nenzira imwecheteyo, sarudza sero yaunoda yetafura array neLMB uye fambisa mouse cursor kumutsara wekupinda mafomula pamusoro pechirongwa.
2. Iye zvino, nekiyi imwechete yemanipulator, unofanirwa kusarudza zviri mukati mesero mumutsara wekupinza.
3. Tinya-kurudyi pane chero nzvimbo yekutaura kwakasarudzwa uye muchimiro chechimiro hwindo tinya pane "Copy" sarudzo.
4. Pinda kune browser paPC uye enda kune chero saiti kuverenga nhamba yemavara.
5. Tinya-kurudyi pane yebasa resaiti uye sarudza iyo "Isa" sarudzo.
6. Zvijairire kukosha kwazvinoita. Mushure mekuita manipulations ari pamusoro, saiti icharatidza ruzivo rwese nezve kureba kwechinyorwa.

Teerera! Pamasaiti akadaro, unogona kuverenga nhamba yemitsara mune yakatarwa chinyorwa.

mhedziso

Saka, muExcel, unogona kukurumidza kuwana ruzivo rwehuwandu hwemashoko mumasero anodiwa etafura yetafura. Nzira yekuita izvi yakatsanangurwa zvakadzama pamusoro apa.