Kune zvimwe zvinangwa, vashandisi vanoda zita retafura nguva dzose vachiona, kunyangwe kana iyo sheet mipumburu ichienda. Mukuwedzera, zvinowanzodiwa kuti, kana kudhinda gwaro pane yepakati pakati (pepa), musoro wetafura wakaratidzwa pane rimwe nerimwe rakadhindwa peji. Ngatione kuti ndedzipi nzira dzaungave dzichigadzirisa zita muMicrosoft Excel application.
Kupinza musoro mumutambo wepamusoro
Kana iyo table zita riripo pane iyo yepamusoro mutsara, uye haina kutora kupfuura mutsara mumwe, ipapo gadziriso kwayo ndeyekutanga kushanda. Kana imwe chete kana imwe mitsetse isina chinhu iri pamusoro pemusoro, ivo vanozoda kubviswa kuti vashandise iyi yekubvuma sarudzo.
Kuti uchengetedze musoro wenyaya, uchiri mu "maonero" tab yeExcel chirongwa, tinya pane "nzvimbo yakachengeteka" bhatani ". Iri bhatani riri patepi mu "hwindo" Toolbar. Kupfuurirazve, mune rondedzero inovhura, sarudza iyo "yakachengetedza iyo yepamusoro mutsara" chinzvimbo.
Mushure meizvozvo, zita riri pamutsetse wepamusoro richagadziriswa, kugara ndichivapo mukati memiganhu ye screen.
Kugadzirisa Dunhu
Kana paine chikonzero chipi nechikonzero, mushandisi haadi kubvisa masero aripo pamusoro pezita, kana kana zvave nemutsara unopfuura mumwe, saka nzira iri pamusoro apa harizofaniri. Isu tinofanirwa kushandisa sarudzo nekumhanya kwenzvimbo, iyo, zvisinei, haisi yakawanda yakaomarara nenzira yekutanga.
Chekutanga pane zvese, tinofambisa kune "maonero" tab. Mushure meizvozvo, tinya pane yakasarudzika sero pasi pemusoro. Tevere, isu tinoita tinya pane bhatani "Simbisa iyo nzvimbo", iyo yakanga yatotaurwa pamusoro apa. Zvadaro, mune iyo menyu yakagadziridzwa, zvakare sarudza chinhu nezita rimwe chete - "Simbisa nzvimbo".
Mushure mekuita uku, zita retafura richanyorwa pane razvino pepa.
Kubvisa iyo pink yemusoro
Chero nzira mbiri idzi dzakanyorwa dzefurafura musoro waizogadziriswa, kuitira kuti uzvipindure, pane imwe chete nzira. Zvekare, isu tinoita tinya pane bhatani riri patepi "Simbisa iyo nzvimbo", asi panguva ino tinosarudza chinzvimbo "kuti tibvise kusanganiswa kwenzvimbo".
Kutevera izvi, musoro wakapenya uchave wakaziviswa, uye kana uchipurudzira pepa pasi, hazvingaonekwe.
Kupinza musoro
Pane zviitiko kana uchidhinda gwaro riripo kuti zita riripo pane rimwe nerimwe rakadhindwa peji. Ehezve, iwe unogona ku "kupwanya" tafura, uye munzvimbo dzinodiwa dzekupinda mumusoro. Asi, maitiro aya anogona kutiza nguva yakakosha, uyezve, shanduko yakadaro inogona kuparadza kutendeka kwetafura, uye maitiro ekuverenga. Pane nzira yakakura kwazvo uye yakachengeteka kudhinda tafura ine zita pane peji rega rega.
Chekutanga pane zvese, isu tinofamba muThebhu "peji peji peji. Tiri kutsvaga "mashizha emahara" marongero. Mumakona aro ekuruboshwe pane chiratidzo pane chiratidzo mune fomu yeiyo oblique museve. Tinya pane ichi chiratidzo.
Iyo hwindo rinovhura nemapuranga emapeji. Isu tinoenda ku "pepa" tab. Mumunda pedyo neyakanyorwa "pundutso pane imwe neimwe peji kuburikidza nemitsetse" iwe unofanirwa kutsanangura iwo marongero emutsara pane iyo zita racho. Nomuzvarirwo, kune mushandisi asina kugadzirira, izvi hazvisi nyore. Naizvozvo, tinya pane bhatani rakaiswa kurudyi kwedata rekupinda munda.
Hwindo rine peji peji rakapetwa. Panguva imwecheteyo, pepa rinova rinoshanda kuti tafura iri kupi. Ingosarudza tambo (kana akati wandei mitsara) pane iyo zita racho rakaiswa. Sezvauri kuona, marongi anopinda muhwindo rakakosha. Dzvanya pane bhatani iri kurudyi kwehwindo rino.
Iyo hwindo rinovhura nemapuranga emapeji. Isu tangosara kuti tidzorere pane "OK" bhatani riri mukona yayo yekurudyi kona.
Zviito zvese zvinodiwa zvakagadzirwa, asi hauzowone chero shanduko. Kuti utarise kana zita retafura racho rave rakadhindwa pane rimwe nerimwe pepa, fambisa kune "Faira" tab yeExcel application. Tevere, enda ku "Prinda" Subsection.
Padivi kurudyi kwewindo iro rakavhura nzvimbo yekutarisa yegwaro rakadhindwa rakatumirwa. Pukuta pasi pasi, uye ita shuwa kuti paunodhinda, musoro wakapetwa ucharatidzwa pane rimwe nerimwe peji.
Sezvauri kuona, pane nzira nhatu dzekugadzirisa zita iri muMicrosoft Excel tafura. Vaviri vavo vakagadzirirwa kusanganisa mumatafura patafura, kana vachishanda negwaro. Nzira yechitatu inoshandiswa kuburitsa zita riri papeji rimwe nerimwe regwaro rakadhindwa. Izvo zvakakosha kuyeuka kuti zvinokwanisika kugadzirisa musoro kuburikidza nekugadziriswa kwetambo chete kana iri pane imwe, ine mutsara wepamusoro wepepa. Pane zvakapesana, iwe unofanirwa kushandisa nzira yekugadzirisa nzvimbo.