Izvo zvinoitika kuti pane Excel sheet iwe unofanirwa kuvanza ruzivo rwuri mune mamwe maseru, kana kutovanza mutsara wese kana koramu. Iyi inogona kunge iri imwe mhando yedata yekubatsira iyo mamwe maseru anotaura nezvayo uye yausingade kuratidza.
Isu tichakudzidzisa nzira yekuvanza maseru, mitsetse uye makoramu muExcel sheet uye wozoita kuti aonekwe zvakare.
Kuviga masero
Iko hakuna nzira yekuvanza sero kuitira kuti iparare zvachose kubva papepa. Mubvunzo unomuka: chii chicharamba chiri panzvimbo yesero iri? Pane kudaro, Excel inogona kuzviita kuitira kuti pasave nezvinyorwa zvinoratidzwa muchitokisi ichocho. Sarudza sero rimwe chete kana boka remasero uchishandisa makiyi kusuduruka и Ctrl, sepakusarudza mafaera akawanda muWindows Explorer. Tinya-kurudyi pane chero maseru akasarudzwa uye mumenu yemukati tinya Sero format (Format Cells).
Bhokisi renhaurirano rezita rimwechete richavhurwa. Enda kune tab nhamba (Nhamba) uye mune rondedzero Mafomu enhamba (Chikamu) sarudza Mafomu ese (Custom). Mundima yekupinza Rudzi (Rudzi) isa semicolons matatu - ";;;" (pasina makotesheni) uye tinya OK.
Cherechedza: Zvichida, usati washandisa chimiro chitsva kumasero, unofanira kusiya chiyeuchidzo chehuwandu hwehuwandu hwehuwandu hwaive mune imwe neimwe yemasero, kuitira kuti mune ramangwana iwe unogona kudzorera chimiro chekare kune sero uye kuita kuti zvinyorwa zvionekwe zvakare.
Iyo data iri musero yakasarudzwa ikozvino yakavanzwa, asi kukosha kana fomula ichiripo uye inogona kuoneka mubhawa yeformula.
Kuita kuti zviri mukati memasero zvionekwe, tevera matanho ese ari pamusoro uye isa yekutanga nhamba fomati yesero.
Cherechedza: Chese chaunonyora musero chine zvakavanzwa chinovanzwa otomatiki kana wadzvanya pinda. Muchiitiko ichi, kukosha kwaive muchitokisi ichi kuchatsiviwa nehutsva hutsva kana fomula yawakaisa.
Kuviga mitsetse nemakoramu
Kana iwe uri kushanda netafura hombe, ungangoda kuvanza mamwe mitsara nemakoramu e data izvo zvisiri kudikanwa pakuona. Kuti uvanze mutsara wese, tinya-kurudyi pane nhamba yemutsara (musoro) uye sarudza Hide (Hide).
Cherechedza: Kuti uvanze mitsetse yakawanda, tanga wasarudza mitsara iyoyo. Kuti uite izvi, tinya kumusoro wemutsara uye, usingaburitse bhatani rekuruboshwe, dhonza chinongedzo kuburikidza nezera rese remitsara yaunoda kuvanza, wobva wadzvanya-kurudyi panzvimbo yakasarudzwa wodzvanya. Hide (Hide). Unogona kusarudza mitsetse isiri pedyo nekudzvanya pamisoro yayo uchibata kiyi Ctrl.
Nhamba mumisoro yemitsara yakavanzwa ichasvetuka, uye mutsara wakapetwa uchaonekwa mumapaka.
Maitiro ekuviga makoramu akafanana zvakanyanya nemaitiro ekuviga mitsetse. Tinya-kurudyi pane iyo column yaunoda kuvanza, kana kuti sarudza akawanda makoramu uye tinya pane yakaratidzirwa boka. Kubva pane menyu inooneka, sarudza Hide (Hide).
Mabhii ari mumisoro yakavanzika yekoramu achasvetuka uye mutsara wakapetwa uchaonekwa munzvimbo yavo.
Kuti uratidze mutsara wakavanzika kana mitsara yakawanda, sarudza mitsara kune rimwe divi remitsara yakavanzika (s), wobva wadzvanya-kurudyi pane yakasarudzwa uye sarudza kubva pane yemukati menyu. ratidza (Unhide).
Kuti uratidze koramu yakavanzika kana makoramu akawanda, sarudza makoramu kudivi ripi neripi rekoramu (ma) yakavanzika, wobva wadzvanya-kurudyi panzvimbo yakanamirwa uye sarudza kubva kumenyu inooneka. ratidza (Unhide).
Kana uri kushanda netafura hombe asi usingade kuvanza mitsara nemakoramu, unogona kuapinira kuitira kuti kana uchikwenya data riri patafura, misoro yakasarudzwa irambe iripo.