Maitiro ekuomesa nzvimbo muExcel. Kupinza nzvimbo muExcel uye kusapinira

Microsoft Office Excel inowanzogadzira matafura ane ruzivo rwakawanda runonetsa kukwana pane rimwe pepa rebasa. Nekuda kwemamiriro ezvinhu aya, zvakaoma kuti mushandisi aenzanise data iri pamagumo akasiyana egwaro, uye zvinotora nguva yakawanda kupuruzira patafura kuti uwane ruzivo rwakakosha. Kuti udzivise dambudziko rakadaro, nzvimbo dzakakosha muExcel dzinogona kugadziriswa nguva dzose, dzakagadziriswa muchikamu chinooneka chegwaro, kuitira kuti mushandisi anogona kukurumidza kuwana ruzivo rwekufarira kwaari. Ichi chinyorwa chichakurukura nzira dzekupinira uye kusunungura nzvimbo muExcel.

Maitiro ekupinza nzvimbo

Pane nzira dzinoverengeka dzakajairwa kuita basa racho, imwe neimwe inoenderana neshanduro chaiyo yechirongwa. Maitiro emhando dzakasiyana dzeMicrosoft Excel achasiyana zvishoma. Kazhinji, maitiro ekugadzirisa nzvimbo dzinodiwa muchirongwa chiri kutariswa chakakamurwa kuita zvinotevera:

• Sarudza sero rekutanga patafura. Iri sero rinofanira kunge riri pazasi penzvimbo yaunoda kubanira muchikamu chinooneka chechidzitiro. Uyezve, iyo data iri pamusoro uye kuruboshwe kwechinhu chakasarudzwa ichagadziriswa nechirongwa.

• Mushure mekuita iyo yapfuura manipulation, iwe uchafanirwa kushandura kune "View" tab. Inowanikwa mukoramu yesarudzo kumusoro kweExcel interface.

• Tevere, mumutsara wakavhurika wezvakakosha, unofanirwa kudzvanya LMB pane "Window" bhatani kamwe.
• Zvishandiso zvakati wandei zvicharatidzwa, pakati pezvaunoda kudzvanya pane "Freeze panes" icon. Pamamonitor akakura ane chiratidziro chepamusoro, chikamu chekutarisa chinobva charatidza sarudzo dzepinning zvinhu. Avo. Haufanire kudzvanya pane Window bhatani.

• Iva nechokwadi chokuti nzvimbo yakambosarudzwa yakagadziriswa papepa rekushanda. Iye zvino zvese zvaive kumusoro uye kuruboshwe kwesero zvicharatidzwa patafura paunenge uchidzika pasi, uye hazvizonyangarika kubva pakuona.

• Mushandisi anogona zvakare kubaya maseru ese ari pamusoro pemutsara wakasarudzwa. Kuti aite izvi, iye achada kusarudza sero yaanoda pakati petafura, uye nenzira imwechete enda kune "View" tab, apo tinya bhatani re "Freeze nzvimbo". Iyi nzira yekugadzirisa inonyanya kukosha kana munhu achida kugadzirisa musoro wetafura pane rimwe nerimwe rebasa.

Teerera! Kuti ugadzirise ruzivo rwuri kuruboshwe rwesero yakasarudzwa, iwe uchada kusarudza chinhu chepamusoro chekoramu chiri kurudyi rwenzvimbo yaunoda, uye wozoita zvakafanana.

Matunhu anosudururwa sei

Vashandisi vasina ruzivo veMicrosoft Office Excel havazive nzira yekusunungura nzvimbo dzakambokiiwa. Zvose zviri nyore pano, chinhu chikuru ndechokutevera mamwe mazano:

1. Vhura gwaro reExcel. Mushure mekuonekwa kwebasa rekushanda mundiro, haufaniri kusarudza chero masero.
2. Enda kune "Tarisa" tab mune sarudzo ribhoni kumusoro kwehwindo rechirongwa.
3. Zvino iwe unofanirwa kudzvanya pa "Window" bhatani kuti uvhure chidimbu chine pinning zvinhu.
4. LMB tinya pane chinyorwa "Unpin matunhu".
5. Tarisa mhinduro nekudzika pasi patafura. Kugadziriswa kwemasero akasarudzwa kare kunofanira kubviswa.

Mamwe Mashoko! Kubvisa nzvimbo muExcel kunoitwa nenzira chaiyo yakarongeka kana ichienzaniswa nekugadzirisa.

Nzira yekuomesa sei nzvimbo kubva kumakoramu

Dzimwe nguva muExcel unoda kuomesa kwete mitsara, asi makoramu. Kuti uite basa nekukurumidza, unogona kushandisa inotevera algorithm:

• Sarudza pamakoramu anofanirwa kugadziriswa, tsvaga nhamba dzadzo, dzakanyorwa pamusoro peiyo dhizaini muchimiro chemavara A, B, C, D, nezvimwe.
• Shandisa bhatani reruboshwe kuti usarudze mutsara unotevera mutsara wasarudzwa. Semuenzaniso, kana iwe uchida kugadzirisa makoramu A uye B, saka unofanirwa kusarudza koramu C.

• Tevere, iwe unofanirwa kuenda zvakafanana kune "Tarisa" tebhu uye tinya pa "Freeze Nzvimbo" bhatani kugadzirisa unodiwa huwandu hwemakoramu pane rega rega rebasa.

• Muwindo remhando yezvinyorwa, iwe uchafanirwa kusarudza yekutanga sarudzo yekugadzirisa mitsara nemakoramu ematafura.
• Tarisa mhinduro. Padanho rekupedzisira, iwe unofanirwa kupuruzira pasi gwaro uye iva nechokwadi chekuti nzvimbo yakatarwa hainyangarike kubva papepa rebasa, kureva rakanamatirwa pariri.

mhedziso

Chishandiso chekugadzirisa nzvimbo muExcel chinochengetedza nguva yevashandisi vanoshanda nehuwandu hukuru hweruzivo. Chinhu chakapiniwa chinogara chichionekwa papepa rekushanda paunenge uchipfuura mazviri. Kukurumidza kuita basa rakadaro, unofanira kunyatsoverenga mashoko ari pamusoro apa.