Maitiro ekuviga zvese zvinyorwa muExcel kamwechete

Manotsi muMicrosoft Office Excel nderumwe ruzivo rwekuwedzera rwunosungirirwa nemushandisi kune chimwe chinhu chetafura array kana kune huwandu hwemasero. Tsamba inokubvumira kunyora rumwe ruzivo musero rimwe chete kuti uyeuchidze chimwe chinhu. Asi dzimwe nguva zvinyorwa zvinoda kuvanzwa kana kubviswa. Nzira yekuita izvi ichakurukurwa munyaya ino.

Nzira yekugadzira chinyorwa

Kuti unzwisise zvizere musoro wenyaya, iwe unofanirwa kutanga wadzidza nezve nzira dzekugadzira manotsi muMicrosoft Office Excel. Hazvina kufanira kufunga nzira dzese mukati mechimiro chechinyorwa ichi. Naizvozvo, kuchengetedza nguva, tinopa iyo yakapusa algorithm yekupedzisa basa:

1. Tinya-kurudyi pachitokisi chauri kuda kunyora chinyorwa.
2. Muwindo remhando yemamiriro ekunze, tinya LMB pamutsara we "Insert note".

3. Bhokisi duku richaonekwa pedyo nesero, umo iwe unogona kuisa zvinyorwa zvinyorwa. Pano unogona kunyora chero chaunoda pakufunga kwemushandisi.

4. Kana zvinyorwa zvanyorwa, iwe uchafanirwa kudzvanya pane chero yemahara sero muExcel kuviga menyu. Chinhu chine chinyorwa chinozoiswa chiratidzo nekatatu dzvuku mukona yepamusoro yekurudyi. Kana mushandisi akafambisa chitubu chegonzo pamusoro pesero iri, mavara akataipa anozoburitswa.

Teerera! Saizvozvo, iwe unogona kugadzira chinyorwa kune chero sero mune Excel worksheet. Nhamba yezvinyorwa zvakapinda muhwindo haisi zvishoma.

Sechinyorwa kune sero, haugone kushandisa kwete zvinyorwa chete, asiwo akasiyana mifananidzo, mifananidzo, maumbirwo akatorwa kubva pakombuta. Nekudaro, ivo vachafanirwa kusungirirwa kune chimwe chinhu chetafura array.

Nzira yekuviga sei chinyorwa

MuExcel, kune nzira dzakati wandei dzekuita basa racho, imwe neimwe inokodzera kutariswa zvakadzama. Izvi zvichakurukurwa mberi.

Method 1: Viga chinyorwa chimwe chete

Kuti ubvise kwenguva pfupi chinyorwa cheimwe chaiyo sero mune tafura array, iwe unofanirwa kuita zvinotevera:

1. Shandisa bhatani reruboshwe kuti usarudze chinhu chine chinyorwa chinoda kugadziriswa.
2. Kurudyi tinya pane chero nzvimbo yesero.
3. Mumenu yemukati inooneka, tsvaga mutsara wekuti "Delete note" uye tinya pairi.

4. Tarisa mhinduro. Iyo siginicha yekuwedzera inofanira kunyangarika.
5. Kana zvichidikanwa, mufafitera rimwe chete remhando yemamiriro, tinya pamutsara wekuti "Edit note" kuti unyore zvakare chinyorwa chakanyorwa kare, gadzirisa zvikanganiso.

Nzira 2. Nzira yekubvisa sei chinyorwa kubva kumasero ose kamwechete

Microsoft Office Excel ine basa rekubvisa panguva imwe chete mazwi kubva kune ese maficha arimo. Kuti utore mukana uyu, unofanirwa kuita zvinotevera:

1. Sarudza tafura yose nebhatani rekuruboshwe.
2. Enda kune "Ongorora" tab, iyo iri mubhari repamusoro rechirongwa.
3. Muchikamu chechikamu chinovhura, sarudzo dzinoverengeka dzicharatidzwa. Mumamiriro ezvinhu aya, mushandisi anofarira bhatani re "Delete", iro riri padivi peshoko rekuti "Gadzira Chinyorwa". Mushure mekudzvanya, masiginicha anozodzimwa otomatiki kubva kumaseru ese eplate rakasarudzwa.

Zvinokosha! Iyo nzira yekuvanza mamwe masiginecha anokurukurwa pamusoro inoonekwa seyepasirese uye inoshanda mune ese mavhezheni esoftware.

Nzira 3: Shandisa menyu yemukati kuti uvanze mhinduro muExcel

Kuti ubvise mavara kubva kumasero ese ari patafura panguva imwe chete, unogona kushandisa imwe nzira. Inosanganisira kuita zvinotevera manipulations:

1. Maererano nechirongwa chakafanana chakakurukurwa mundima yapfuura, sarudza mutsara unodiwa wemasero mutafura.
2. Tinya-kurudyi panzvimbo yakasarudzwa yetabular data array nebhatani rekurudyi.
3. Muwindo remhando yemamiriro ezvinhu rinoonekwa, tinya LMB kamwe pamutsara we "Delete note".

4. Ita shuwa kuti mushure mekuita nhanho yapfuura, mavara emaseru ese anoburitswa.

Nzira 4: Bvisa chiito

Mushure mekugadzira akati wandei akakanganisa manotsi, unogona kuvavanza imwe neimwe, woidzima uchishandisa iyo undo chishandiso. Mukuita, basa iri rinoitwa sezvinotevera:

1. Bvisa sarudzo kubva patafura yese, kana iripo, nekudzvanya LMB pane yemahara nzvimbo yeExcel worksheet.
2. Mukona yepamusoro yekuruboshwe yechirongwa chechirongwa, padivi peshoko rekuti "Faira", tsvaga bhatani muchimiro chemuseve kuruboshwe uye tinya pairi. Chiito chakaitwa kekupedzisira chinofanira kuregererwa.
3. Saizvozvo, tinya bhatani rekuti "Kanzura" kudzamara zvinyorwa zvese zvadzimwa.

Iyi nzira ine drawback inokosha. Mushure mekudzvanya bhatani rakatariswa, zviito zvakakosha zvakaitwa nemushandisi mushure mekugadzira masiginecha zvichabviswa zvakare.

Ruzivo rwakakosha! MuExcel, semupepeti chero weMicrosoft Office, chiito cheKubvisa chinogona kuitwa uchishandisa nzira yekudimbudzira yekhibhodi. Kuti uite izvi, iwe unofanirwa kushandura kiibhodhi yekombuta kune dhizaini yeChirungu uye panguva imwe chete bata mabhatani "Ctrl + Z".

mhedziso

Saka, manotsi muMicrosoft Office Excel anoita basa rakakosha mukugadzira matafura, kuita basa rekuwedzera, kuwedzera ruzivo rwekutanga musero. Zvisinei, dzimwe nguva dzinofanira kuvanzwa kana kubviswa. Kuti unzwisise kuti ungabvisa sei masiginecha muExcel, unofanirwa kunyatsoverenga nzira dziri pamusoro.