Maitiro ekuvanza zvinyorwa zvese muExcel panguva imwe chete

Zvinyorwa muMicrosoft Office Excel ndeye rumwe ruzivo rwekuwedzera iyo mushandisi anosungira kune chimwe chinhu chakananga pane tafura yakarongeka kana kumasero emasero. Cherechedzo inokutendera kuti unyore rumwe ruzivo mune imwe sero kuyera chero chinhu. Asi dzimwe nguva zvinyorwa zvinoda kuvanzika kana kubviswa. Maitiro ekuita izvi zvichaudzwa muchinyorwa chino.

Maitiro Ekugadzira Cherechedzo

Kunzwisisa kwakazara kwenyaya, iwe unotanga kudzidza nezve nzira dzekugadzira zvinyorwa muMicrosoft Office Excel. Funga nezvenzira dzese dziri mukati mechinyorwa ichi nezviitiko. Naizvozvo, kuponesa nguva, tinopa iyo iri nyore kwazvo algorithm yebasa rakapedza:

1. Dzvanya iyo kiyi yekurudyi kune iyo manipulator neiyo cell iyo iyo tsamba inofanirwa kunyoreswa.
2. Mune mamiriro emukati-mhando yepahwindo rwindo, tinya LKM pane "INTERT NYAYA" mutsara.

Zviito zvakapusa kugadzira masaini muExcel, yakapihwa pane imwe skrini

1. Kutevera kuchitokisi kunenge kuri saizi zvishoma mauri iwe unogona kuisa zvinyorwa zvecherechedzo. Pano iwe unogona kunyora chero chinhu pakufunga kwemushandisi.

Kutaridzika kwehwindo rekupinda zvinyorwa muExcel

1. Kana iwo mavara akanyorwa, iwe uchafanirwa kudzvanya pane chero sero remahara muExcel kuti menyu yakavanzika. Chinhu chacho chine chinyorwa chichaverengeka nekona diki tsvuku mukona yekumusoro kurudyi. Kana mushandisi akashanyira cursor kana iyi cell, mavara akaunganidzwa achavhura.

Sechinyakare kuchitokisi, iwe unogona kushandisa kwete chete zvinyorwa, asi zvakare zvifananidzo zvakasiyana, mifananidzo, manhamba akatakura kubva pakombuta. Nekudaro, ivo vanofanira kusungirirwa kune chimwe chinhu chakarongeka patafura.

Maitiro Ekuviga Kuona

MuBross, pane nzira dzinoverengeka dzakajairika dzekushandisa basa iri, chimwe nechimwe chazvo chakafanirwa nehanya. Izvi zvichakurukurwa mberi.

Nzira 1. kuviga imwe noti

Kuti ubvise kwenguva pfupi siginecha yeimwe sero sero muTafura yakarongeka, iwe unofanirwa kuita zvinotevera:

1. Iyo kiyi yekuruboshwe yemanipulator ndeyekunyatsojekesa chinhu icho chinyorwa chinoda kuti chibve chiripo.
2. Dzvanya PCM pane chero nzvimbo yemusero.
3. Mumamiriro akaratidzwa menyu, tsvaga "Delete noti" mutsara uye tinya pairi.

Nzira iri nyore yekubvisa kusaina imwe neimwe sero muMicrosoft Office Excel

1. Tarisa uone mhedzisiro yacho. Imwe siginecha inofanirwa kunyangarika.
2. Kana zvichidikanwa, mune imwecheteyo yemhando yemhando yewindo, tinya pane "Rongedza Cherechedzo" tambo kunyora tsamba yakaunganidzwa, gadzirisa zvikanganiso.

Hwindo rekugadzirisa tsamba yemhando. Pano iwe unogona kuchinja iyo yakapinda nzira nzira 2. Maitiro ekubvisa chinyorwa nekukurumidza kubva kumasero ese

MuMicrosoft Office Excel kune basa rekubvisa panguva imwe chete kubva pazvinhu zvese izvo zviripo. Kuti ushandise mukana wakadaro, zvinodikanwa kuti uite seanotevera:

1. Simbisai tafura yeTafura yeiyo yekuruboshwe bhatani bhatani.
2. Enda kune iyo "ongororo" tab, iyo iri kumusoro kwechirongwa chekushandisa.
3. Munzvimbo yekuvhura yechikamu, sarudzo dzinoverengeka dzichaziviswa. Mumamiriro ezvinhu emushandisi uyu, iwe unofarira iyo Delet bhatani, iyo iri padyo neIzwi "Gadzira Cherechedzo". Mushure mekumanikidza kusaina kunodzimwa kubva pamasero ese epaneti yakasarudzwa.

Zviito zvekunyatso bvisa zvese tafura yese yakagadzirwa panguva imwe chete. Nzira 3. Kushandisa mamiriro emenyu kuviga manotsi muExcel

Kuitira masero ese ari patafura kuti abvise zvakafanana masaini, unogona kushandisa imwe nzira. Inosanganisira kuita manipulati inotevera:

1. Maererano nehurongwa hwakafanana hunokurukurwa mundima yapfuura, sarudza iwo masero anodiwa ari patafura.
2. Nekurudyi-kiyi manipulator peta pane yakasarudzwa nzvimbo ye tafura yakarongeka yedata.
3. MuComerTual Type Window inoonekwa, tinya iyo lx kamwe pane "Delete noti" mutsara.

Pfungwa Menyu Kubvisa zvese zvinyorwa muExcel

1. Ita shuwa kuti mushure mekuita kwekutanga, masaini emasero ese haana kusimbiswa.

Nzira 4. Kanzura

Sezvo anga ambogadzira manhamba akati wandei, iwe unogona kuvavanza neimwe nzira, bvisa nechishandiso chekubvisa zviito zvakapfuura. Mukuita, basa rakadai rakaitwa seinotevera:

1. Bvisa kusarudzwa kubva patafura yese, kana iripo nekutsikirira iyo LKM pane yakasununguka nzvimbo yeExcel inoshanda shopu.
2. Mukona yekumusoro kuruboshwe yeProgram Interface padhuze nezwi "faira", tsvaga bhatani riri muchimiro chemuseve kuruboshwe uye tinya pairi. Chiito chakazadziswa neicho chekupedzisira chinofanira kudzimwa.
3. Saizvozvo, tinya iyo "Cancel" bhatani kusvikira zvese zvinyorwa zvabviswa.

Cancel bhatani muExcel. Iyo "Ctrl + Z" Kiyi musanganiswa zvakare ichimhanya, yakakora kubva kuPC keyboard

Iyi nzira ine yakakosha dhizaini. Mushure mekudzvanya pamusoro pekuratidzwa, zviito zvakakosha zvakaurayiwa nemushandisi mushure mekugadzira masaini zvichabviswa.

Mhedziso

Nekudaro, zvinyorwa muMicrosoft Office Excel tamba basa rakakosha mukugadzirira matafura, vachiita chinhu chekuwedzera, chengetedza ruzivo rwekutanga muchitokisi. Nekudaro, ivo vanofanirwa kuviga kana kudzima. Kuti unzwisise maitiro ekubvisa masasaina muExcel, iwe unofanirwa kuverenga nenzira dziri pamusoro apa.

Mharidzo Maitiro ekuvanza zvese zvinyorwa muExcel panguva imwe chete iyoyo yakaonekwa yekutanga kune tekinoroji yeruzivo.