Maitiro ekuita sheetwork pepa muExale

Paunenge uchidhinda gwaro rekunyorera, mamiriro acho kazhinji mamiriro ezvinhu apo tafura yehupamhi isingakwanisi pane pepa renyama. Naizvozvo, zvese zvinofamba kupfuura muganho uyu, purinda inodhinda pamashiti ekuwedzera. Asi, kazhinji, mamiriro ezvinhu aya anogona kururamisa nekungochinja kutaridzika kwegwaro nebhuku, iro rakaiswa nekusvibiswa, pamamiriro ekunze. Ngatizvione nzira yekuita izvi nerubatsiro rwenzira dzakasiyana siyana mukubudirana.

Chidzidzo: Maitiro Ekuita Kuti Utore Mamiriro Ekutanga muMicrosoft Word

Shandura gwaro

Muchikumbiro cheExcel, pane maviri sarudzo dzekutarisa kwemashiti kana kudhinda: bhuku uye mamiriro. Yekutanga yakakodzera iyo default. Izvi ndizvo, kana usati wakaita chero manipolister neiyi mamiriro mugwaro, ipapo kana uchidhindisa zvichaenda kubhuku rekutarisa. Musiyano mukuru pakati pemhando mbiri idzi dzekumisa nderekuti pasi pebhuku racho kukwirira kwe peji rakawanda, uye nemamiriro ekunze - pane zvinopesana.

Mukukosha, iyo nzira yehunhu hwekutendeudza peji nebhuku rekutarisa kune iyo nyika muChirongwa cheBexcel ndiro chete, asi inogona kutangwa uchishandisa imwe yeanosarudza sarudzo. Panguva imwecheteyo, pepa rega rega rebepa rinogona kushandisirwa chinzvimbo charo. Panguva imwecheteyo, mukati me pepa rimwe, paramende iyi inoshandurwa kune zvinhu zvega (mapeji).

Chekutanga pane zvese, zvakakosha kuti uzive kuti kushandura gwaro zvachose. Mune izvi zvinangwa, unogona kushandisa fungidziro. Kuti uite izvi, kutendeuka mu "Faira" tab, fambisa kune "Prinda" chikamu. Mukuruboshwe kwepahwindo mune munda wekuratidzira pre-kuratidza gwaro, sezvo richaratidzika senge rinodhinda. Kana ari mundege yakatwasuka yakakamurwa kuita mapeji akati wandei, saka izvi zvinoreva kuti tafura haina kupora papepa.

Kana, mushure mezviitwa izvi, isu tichadzokera ku "Imba" tab, tobva taona tambo yakadhindwa. Panyaya iyo iyo yakatsauka inotsauka tafura pachikamu, saka ichi chiratidzo chekuwedzera kuti kana kudhinda, midziyo yese pane imwe peji haigone kuiswa.

Nekuda kwemamiriro ezvinhu aya, zvakanaka kuti uchinje kutaridzika kwegwaro racho kumamiriro ekunze.

Nzira 1: Dhinda Zvirongwa

Kazhinji, vashandisi vanoshanduka kushandirirwa vari mumarongedzo anodhindwa.

1. Enda kune "Faira" tab (mu Excel 2007, pachinzvimbo, iwe unofanirwa kudzvanya paMicrosoft Office logo mukona yekuruboshwe kwewindo).



2. Fambisa mu "printa" chikamu.



3. Inovhura yatojaira isu nharaunda yeiyo fungidziro. Asi panguva ino hazvizofariri isu. Mu "Setup" block nekudzvanya pane "bhuku rekutarisa" bhatani ".



4. Kubva pane yekudonha-pasi rondedzero, sarudza chinhu icho "Manera anotarisisa".



5. Mushure meizvozvo, kutaridzika kweiyo Excel Speet Spews mapeji anozoshandurwa kune mamiriro ezvinhu, ayo anogona kucherechedzwa mune fungidziro yegwaro rakadhindwa.

Nzira yechipiri: Peji Markup Tab

Pane nzira yakapusa yekuchinja kutaridzika kwepepa. Inogona kuitwa mu "Peji Markup" tab.

1. Enda kune iyo tab "peji peji makop". Dzvanya pane "bhatani" bhatani, iro rakaiswa mu "peji paramende" toolbar. Kubva pane yekudonha-pasi rondedzero, sarudza iyo "loomge" chinhu.



2. Mushure meizvozvo, kutaridzika kweiyo razvino pepa kuchatsiviwa nemamiriro ekunze.

Nzira 3: Shanduko iyo mabvazuva yemashizha akati wandei panguva imwe chete

Paunenge uchishandisa nzira dzakatsanangurwa pamusoro apa, iyo nzvimbo yenzvimbo inoratidzwa chete pane razvino pepa. Panguva imwecheteyo, pane mukana wekushandisa iyi paramende yezvinhu zvakafanana zvinhu zvakafanana panguva imwe chete.

1. Kana mashitsi aunoda kushandisa chikamu cheboka chiri padyo nemumwe, wozoparadza bhatani rekhibhodi uye pasina kusunungura, tinya pane yekutanga kuruboshwe chikamu chepahwindo pamusoro peganda riri pamusoro peganda. Wobva wadzvanya pane yekupedzisira yegwaro. Saka, huwandu hwese hucharatidzwa.

   

   Kana iwe uchida kuchinjisa mafambiro emapeji pane akati wandei mashizha, mapfupi ezvisina kuwanikwa padivi peumwe neumwe, saka iyo algorithm yekuita ndeye yakasiyana. Dzvanya bhatani reCTRL pane iyo khibhodi uye tinya pane imwe neimwe pfupi, pamusoro pauchazoda kuita kushanda kuruboshwe-tinya. Saka, zvinhu zvinodiwa zvicharatidzwa.



2. Mushure mekusarudzwa kwakaitwa, tatojaira isu. Enda kune iyo tab "peji peji makop". Isu tinodzvanya bhatani pane "kutaridzika" tepi, iri mu "peji repa" Toolbar. Kubva pane yekudonha-pasi rondedzero, sarudza iyo "loomge" chinhu.

Mushure meizvozvo, mashizha ese akasarudzwa anozove neyekutaurwa pamusoro pezvinhu zvacho.

Sezvauri kuona, pane nzira dzinoverengeka dzekuchinja bhuku rekutarisa kumamiriro ekunze. Nzira mbiri dzekutanga dzinotsanangurwa nesu zvinoshanda kuti uchinje paramita dzenzvimbo iripo. Mukuwedzera, pane imwe sarudzo yekuwedzera inokutendera kuti uite shanduko kune akati wandei mashitsi panguva imwe chete.