Maitiro Ekuomesa Mitsetse muExcel

Maitiro ekusunungura Mitsetse⁢ muExcel

Excel chishandiso chine simba chespredishiti chinopa akawanda mabasa uye kugona kwekuongorora uye kuronga data. Chimwe chezvinhu zvinonyanya kukosha zveExcel kugona kwayo kuomesa mitsara, izvo zvinokutendera kuti uchengetedze mimwe mitsara ichioneka paunenge uchipfuura nepakati peseti yespredishiti Izvi zvinogona kunyanya kubatsira kana Paunenge uchishanda nemaseti makuru edata kana paunoda kuchengetedza rumwe ruzivo ruchionekwa nguva dzese.

Kugona kuomesa mitsara mu⁤ Excel Inowanikwa mu "View" tab yeribhoni. Nekudzvanya pane iyi tebhu, menyu ine akasiyana ekuratidzira sarudzo icharatidzwa. Iyo "Freeze panels" sarudzo ndiyo inotitendera kuomesa mitsara. Kuti tishandise basa iri, tinongosarudza mutsara watinoda kuomesa uye tinya pane inoenderana sarudzo.

Kana tangosarudza mutsara watinoda kuomesa, Excel ichaparadzanisa spreadsheet muzvikamu zviviri: chikamu chepamusoro chicharamba chakanyatsogadziriswa uye chikamu chepasi chichafamba apo isu tinofamba pepa rakasarudzwa rinoramba richionekwa, kwete hazvinei kuti tinopeta zvakadii mamwe pepa.

Sezvo isu tichifambisa chituri pasi, mitsara pamberi pemutsara wakaoma ichavanzwa, asi isu tinogona kuona mutsara wakaoma nechando pamusoro. kubva pachiratidziro. Izvi zvinonyanya kukosha kana isu tichida kugara tichitarisa musoro wemutsetse kana data yakakosha.

Muchidimbu, basa re omesa mitsara muExcel Icho chishandiso chakakosha chinokutendera iwe kuti uchengetedze rumwe ruzivo ruchionekwa nguva dzose uchipururudza kuburikidza neseti huru yedata Zviri nyore kushandisa uye iri muTarisa tab yeribhoni. Iyi ficha inogona kunyanya kubatsira kune avo vanoda kugara vachinongedzera misoro mitsetse kana yakakosha data, kuvandudza kugona uye kurongeka. kubasa nemaspredishiti.

1. Nhanganyaya yeRow Yechando⁤ muExcel

Kuomesa mitsara muExcel chinhu chinobatsira kwazvo chinokutendera kuti ugadzirise mamwe mitsara muspredishiti iwe uchipfuura nepakati pese peji. Izvi zvinonyanya kukosha kana uchishanda nemaspredishiti akareba kana kuita ongororo yedata. ,

Kupinza mitsara muExcel, unongosarudza mutsara waunoda kubaya wobva waenda ku "Tarisa" tebhu mubhara rekushandisa. Ikoko iwe unowana sarudzo "Freeze panels". Paunosarudza sarudzo iyi, Excel inopinza mutsara wakasarudzwa kumusoro uye iwe unogona kupururudza wakasununguka mukati meimwe pepa usingarasikirwe neruzivo rwakakosha.

Imwe nzira yekuomesa mitsara muExcel ndeye kushandisa bhatani rekukurumidza kuomesa, iro riri kudivi rekurudyi. kubva kubhawa vertical displacement. Paunodzvanya bhatani iri, Excel inoomesa mitsetse pamberi pesero rinoshanda pamusoro pechidzitiro. Izvi zvinobatsira zvakanyanya kana uine spreadsheet ine mitsara yakawanda uye iwe uchida kuchengetedza ruzivo rwakakosha ruchionekwa uchikwenya mune yese data.

Pamusoro pemitsara inotonhora, zvinogonekawo kuomesa makoramu muExcel. Iyi nzira yakafanana nemitsara yekuomesa uye inogona kubatsira paunenge uchishanda nespredishiti rine makoramu akawanda uye uchida kuchengetedza ruzivo rwuri mumakoramu ekutanga achionekwa uchikwenya wakachinjika kuburikidza nemamwe makoramu ese. Makoramu echando anoitwa nenzira imwechete semitsara inotonhora, iwe unongosarudza iyo column yaunoda kugadzirisa pane mutsara. ‍

Iyo immobilization⁢ yemazita uye mbiru muExcel chishandiso chichakubatsira iwe kuvandudza mafambiro ako ebasa uye kuramba uchiteedzera data yakakosha mumaspredishiti ako. Ungave uri kushanda pakurondedzera zvemari, kuongorora dhata, kana chero rimwe basa rinosanganisira maspredishiti akakura, mutsara nekoramu yekuomesa chando ichave sosi yakakosha yekuwedzera goho nekubudirira kwako.

2. Maitiro ekuseta mitsara yekuomesa nechando muExcel

Basa re kusafamba kwe⁢ mitsara muExcel inobatsira zvakanyanya kana uchishanda nemaspredishiti makuru. Zvinotibvumira simbisa mimwe mitsetse pamusoro ⁤pamusoro⁤ pahwindo, ⁢kuvimbisa kuti zvinoramba zvichionekwa kunyangwe isu tikafamba⁤ pasi. Kana iwe uchida kudzidza maitiro ekuita zvakanyanya basa iri, pano tinokuratidza nhanho nhanho.

1.Sarudza mutsara⁤ waunoda kuomesa: Usati watanga, unofanira kusarudza⁤ mutsara waunoda kuti urambe uchionekwa. Dzvanya nhamba yemutsara kuruboshwe rwespredishiti kuti uisarudzire zvizere. Kana iwe uchida kuomesa mitsara yakawanda, ingobata pasi "Ctrl" kiyi uchisarudza mimwe mitsetse.

2. Svika iyo immobilization sarudzo:⁣ Kana wasarudza mutsara kana mitsara yaunoda kuomesa, enda kuTarisa tab paribhoni wobva wadzvanya Freeze Panels Menyu yekudonhedza ichaonekwa ichikuratidza Unogona kusarudza kuomesa chete mutsara wakasarudzwa kana ese ari maviri mutsara uye mbiru.

3. Tarisa kuti immobilization yaitwa: Mushure mekusarudza ⁢kuomesa sarudzo, unozoona⁤ mutsetse wakasviba ⁢wakachinjika unoratidza kupatsanurwa ⁤pakati pemutsara wakaoma nechando ⁢nesara yese spreadsheet. Pamusoro pezvo, iyo yakatwasuka uye yakachinjika yekupurudzira sarudzo ichave inoshanda, ichikubvumidza kuti ufambe pepa uchichengeta mutsara wakasarudzwa uchigara uchioneka. "chisarudzo.

Kutora mukana weiyo mutsara wekuomesa chimiro muExcel inzira huru yekuita kuti zvive nyore kuverenga uye kuongorora huwandu hukuru hweruzivo mumaspredishiti. Iye zvino zvaunoziva matanho anodiwa kuti uzvigadzirise, iwe unozogona kushanda zvakanyanya uye zvine pundutso pamapurojekiti ako eExcel.

3. Kushandisa "Lock Panels" basa muExcel

Iyo⁤ "Lock Panels" basa muExcel chinhu chinobatsira⁢ chishandiso⁢ chinobvumira⁢ kuomesa ⁢mitsara⁢ nemakoramu. papepa Izvi zvinonyanya kukosha kana isu tichishanda nehombe data seti uye tinoda kuwana nekukurumidza kune mamwe mitsara kana makoramu nguva dzese. Nechinhu ichi, tinokwanisa kubaya mutsara chaiwo kana koramu kuitira kuti irambe ichionekwa isu tichipeta pepa rose, zvichiita kuti zvive nyore kuona uye kuongorora data.

Kuti ushandise "Lock Panels" muExcel, ingosarudza mutsara kana koramu yaunoda kuomesa. Tevere, enda kune "Tarisa" tebhu mubhabhu yeturusi uye tinya "Panel Lock". Iwe uchaona mutsara wakatwasuka kana wakatwasuka wawedzerwa kuspredishiti, zvichiratidza kuti mutsara wakasarudzwa kana koramu yakakiiwa. Zvino, kana iwe uchikwenya pasi kana kurudyi, mutsara uyu kana koramu icharamba ichionekwa kumusoro kana kuruboshwe rwechidzitiro.

Imwe sarudzo inobatsira⁢ kugona kuomesa kupfuura mutsara mumwe kana koramu. Kuti uite izvi, ingosarudza mutsara kana koramu yaunoda kuomesa nemitsara kana makoramu kumusoro kana kuruboshwe kwayo. Zvadaro, tevera matanho akafanana nepamusoro kuti uite "Panel Lock" basa. Nenzira iyi, mitsara yakasarudzwa kana makoramu uye ese ari pamusoro kana kuruboshwe pawo acharamba achionekwa paunenge uchipfuura nepaspredishiti.

Rangarira kuti iwe unogona zvakare kudzima iyo "Panel Lock" basa chero nguva. ⁢Ingoenda pakabhurocha rekuti “Ona” wodzvanya “Panel Lock” zvakare kuti ⁤bvisa⁤ mitsara yakachinjika kana yakatwasuka⁢ nekudzoreredza⁤ maonero espredishiti. Izvi zvinonyanya kubatsira kana iwe uchida kuchinja kumitsara kana makoramu awakaomesa. Edza nechinhu ichi uye uchaona kuti inguva yakawanda sei uye kushanda nesimba kwazvinogona kukuchengetedza paunenge uchishanda nemaspredishiti makuru muExcel.

4. Kuomesa sei mitsara chaiyo muspredishiti

Kana iwe uchitsvaga Excel, iwe uri munzvimbo chaiyo. Dzimwe nguva, zvinodikanwa kuve nemimwe mitsara inogara ichionekwa iwe uchipfuura nepakati pese data. Neraki, Excel inopa chimiro chinokutendera kuti uite izvi zviri nyore uye nemazvo.

Kuomesa mitsetse muExcel, tevera matanho aya:

1. Vhura spreadsheet yako yeExcel uye sarudza mutsara waunoda kuomesa.
2. Enda kune "Tarisa" tab pamusoro pe toolbar.
3. Dzvanya "Freeze Panels" muboka re "Window".
4. Zvadaro, sarudza “Freeze Top Row” kana uchida kuomesa mutsara wekutanga, kana kuti “Freeze Row” kana uchida kuomesa mutsara wakasiyana.

Paunenge uchinge waomesa mitsara yaunoda, unogona kupuruzira mune yese data usingarasikirwe neruzivo rwakakosha rwawakasarudza. Izvi zvinonyanya kubatsira kana iwe uchishanda nemahombe data seti uye uchida kuwana nekukurumidza kune mamwe makiyi mitsara.

Rangarira kuti iwe unogona zvakare kusunungura mitsara nekutevera matanho akafanana ataurwa pamusoro. ⁢Sarudza zviri nyore sarudzo yekusagadzika pachinzvimbo chekuti ⁣“Gadzirisa‍ Row” ⁤kudzoreredza maonerwo enguva dzose⁤ spreadsheet. Tinovimba kuti mazano aya zvave zvinobatsira kwauri uye kuti iwe unogona kutora mukana wakazara weiyi Excel basa kufambisa basa rako nedata. Edza Kuomesa Mitsetse nhasi uye chengetedza nguva nesimba pamabasa ako espredishiti!

5. Mazano—ekuomesa nechando mitsetse muExcel

Basa re immobilize rows ⁤muExcel inoshanda⁤ zvakanyanya ⁤kana ukashanda⁤ nemaspreadsheets akakura, sezvo achikubvumidza gadzirisa mitsara imwe kana yakawanda Pamusoro pechidzitiro iwe ⁢kupururudza mukati meimwe shizha. Izvi zvinonyanya kubatsira kana uine misoro kana mazita pamusoro pespredishiti rako uye iwe unofanirwa kugara uchianongedzera usingarasikirwe nawo. Pano iwe unowana mamwe matipi ekuwana inoshanda ⁤kuomesa mitsara muExcel.

Nhanho yekutanga kuenda immobilize rank muExcel ndeyekusarudza mutsara kana mitsara yaunoda kuti irambe ichionekwa pamusoro pespreadsheet rako. Unogona kuita Izvi zvinoitwa nekudzvanya nhamba yemutsara iri kuruboshwe rwespredishiti kuti usarudze mutsara wega kana nekukwevera chitubu pasi kuti usarudze mitsara yakawanda, enda kune "Tarisa" tab mudziyo wekushandisa yeExcel uye tinya "Freeze⁤ mapaneru".

Kana muchida kusafamba kupfuura⁤ imwe mutsara, ita shuwa kuti mutsara uri pamusoro pemitsara yaunoda kuomesa inosarudzwa zvakare. Izvi zvichaita kuti mitsara yakavharwa munzvimbo yakarurama. Pamusoro pezvo, kana uine makoramu ane ruzivo rwakakosha rwaunodawo kuomesa, unogona kutevera matanho akafanana asi uchisarudza makoramu pachinzvimbo chemitsara. Muchiitiko ichi, enda ku "Tarisa" tab uye tinya "Freeze Panels" kugadzirisa makoramu akasarudzwa panzvimbo.

6. Mhinduro kumatambudziko akajairika⁤ kana mitsara yekuomesa muExcel

Kune avo vanoshandisa chirongwa cheExcel spreadsheet nguva nenguva, unogona kuzviwana wava kuda misa mitsetse kufambisa ⁢kuonekwa kwedata. Zvisinei, dzimwe nguva panogona kuva nezvinetso zvakajairika pakuedza kuita basa iri rinogona kuodza mwoyo. Sezvineiwo, kune akati wandei mhinduro dzinogona kubatsira kugadzirisa aya matambudziko uye kuita kuti basa remitsetse yechando rive nyore.

Dambudziko rinowanzoitika kana uchiedza kuomesa mitsara muExcel nderekuti sarudzo yechando inogona kuvharwa. yabviswa. Izvi zvinogona kuitika⁢ kana pasina sero rakasarudzwa mukati memutsara waunoda kuomesa. ⁣Kugadzirisa nekukasira kudambudziko iri kuve nechokwadi chekuti sero mukati memutsara rasarudzwa usati waedza kuiomesa. Kana sero rakakodzera rasarudzwa, sarudzo yeFreeze Rows inofanira kuwanikwa yekushandisa.

Rimwe dambudziko rinowanzoitika nemitsara yekuomesa muExcel nderekuti mitsetse yakaomeswa nechando inogona kufamba kana kunyangarika ⁤ nekupuruzira⁢ kuburikidza nespredishiti. Izvi zvinogona kunyanya kutsamwisa kana uri kushanda nespredishiti hombe. For gadzirisa dambudziko iri, zvakakosha kuve nechokwadi kuti mutsara wechando uri muchikamu chakarurama chespredishiti. Pamusoro pezvo, sarudzo yechando yechando inogona kushandiswa kubaya mitsara uye makoramu, izvo zvinova nechokwadi kuti mitsetse yakaomeswa nechando inogara panzvimbo kunyangwe uchipuruzira muspredishiti.

7. Maitiro ekudzima mitsara yekuomesa muExcel

Kuomesa mitsara muExcel chinhu chinobatsira kwazvo chinokutendera kuti uchengete mimwe mitsara ichioneka, kunyangwe uchipuruzira nepaspredishiti hombe. Nekudaro, panogona kunge paine nguva dzaunoda kudzima chimiro ichi. Tevere, tinokuratidza maitirwo acho.

1. Menu sarudzo: Nzira iri nyore yekudzima kuomesa mitsara ndeye kushandisa ⁤menu sarudzo muExcel. Pamusoro pehwindo, tinya "Tarisa" uye wozosarudza "Freeze Panes." Sarudzo iyi inokuratidza nzira dzakasiyana dzekuomesa nechando dziripo. ‍ Kana uine mitsara kana makoramu akaomeswa nechando, uchaona cheki padivi pesarudzo inoenderana. Simply⁢tinya sarudzo yekudzima mitsara yechando.

2. Nzira pfupi yekhibhodi: Kana iwe uchida kushandisa mapfupi ekhibhodi, Excel inokupa nzira yekukurumidza kudzima mitsara yechando. Ingo bata pasi "Ctrl" kiyi uye, panguva imwe, tinya ⁢ "Shift" kiyi uye "F6" kiyi. Izvi zvinobvisa chero mitsetse yawakaseta muspredishiti.

3. Mupumburu sarudzo: Dzimwe nguva ungangoda kudzima kwenguva mitsara kuomesa nechando paunenge uchitsvaga spreadsheet. Kuti uite izvi, ingo penya kumusoro kana pasi pasi pespredishiti kusvika mitsetse yakapiniwa yanyangarika kubva pachiratidziro. Izvi hazvizobvisi mutsara ⁤kuomesa nechando, ⁢zvinongoidzima kwekanguva kusvika wadzokera panzvimbo yepakutanga muspredishiti.