Mirefu Mitsara uye Columns mune imwe Excel Worksheet

Deredza kukwanisa kunzvimbo dzisina kushandiswa dzepaspiritsi.

Purogiramu imwe neimwe iri muExcel inogona kuva nemiganhu inopfuura 1 000 000 uye inopfuura 16,000 mazamu ehuruzivo, asi haisi kazhinji kuti iyo yose inenge ichidiwa. Nenzira yakanaka, unokwanisa kuderedza nhamba yemakoroni nemirara inoratidzwa mune pepanheetti.

Chiremera Kupfurikidza nekukanganisa Nhamba Yemakumbo uye Makoromeni muExcel

Kakawanda, tinoshandisa zvakanyanya zvishoma kudarika nhamba yakawanda yemitsetse nemakoroni uye dzimwe nguva zvingave zvakakosha kugadzirisa kusvika kune nzvimbo dzisina kushandiswa dzebasa.

Somuenzaniso, kuti urege kuchinja kuitika kune imwe data , dzimwe nguva inobatsira kuiisa munzvimbo yebasa rausingawaniki.

Kana, kana vashandi vashoma vane ruzivo vachida kuwana pepa rako rekushanda, kupedzisa kwavanogona kuenda kunogona kuvadzivisa kuti varashike mumiganhu isina chinhu uye ma column anogara kunze kwenharaunda.

Kurambidza Zvishoma Nguva Pepa Rokushanda Ropa

Chero chikonzero ichocho, unogona kuderedza kwekanguva nhamba yemiganhu nemirasi inogamuchirwa nekugadzirisa mararamiro emiganhu inogona kushandiswa uye nemirasi muMupepanzvimbo Area pfuma yebasa rekushanda.

Cherechedza, zvisinei, kuti kuchinja Nzvimbo yeMupumburu ndechiyero chenguva pfupi sezvo ichigadziriswa nguva imwe neimwe bhuku rebhuku rakavharwa uye rinotangazve .

Uyezve, iyo inopinda inofanirwa kunge yakazara- zvisingawani mumasero akaiswa mazita.

Muenzaniso

Matanho ari pasi apa akashandiswa kuchinja zvinhu zvepepaiti yekugadzirisa kukwana nhamba yemiganhu ye30 uye nhamba yemakamuri kusvika 26 sezvinoratidzwa mumufananidzo uri pamusoro.

1. Vhura jeri Excel isina chinhu.
2. Kanda-kanda pane pepa pebhu pasi nechokunze kwechiso cheSheet 1 .
3. Dzvanya View View Code mumenu kuti uzarure Visual Basic for Applications (VBA) editor window.
4. Tsvaga firiji yeZvipfeti zveSheet muzasi kwekona yekweseri yeVBA editor window.
5. Tsvaga Mupumburu Wemugwagwa muzvinyorwa zvemashizha ebasa, sezvinoratidzwa mumufananidzo uri pamusoro.
6. Dzvanya mubhokisi risina chinhu kurudyi rweMupumburu Wechirairo.
7. Tora bhora a1: z30 mubhokisi.
8. Chengeta pepa rekushanda.
9. Vhura VBA editor window uye dzorera pepa rekushanda.
10. Edza pepa rekushanda. Iwe haufaniri kukwanisa:
    • Mipumburu iri pasi mutsara 30 kana kurudyi rwekomba Z;
    • Dzvanya pane sero kuenda kurudyi kana pasi pevharesi Z30 mubasa rekushanda.

Cherechedza: Chifananidzo chinoratidza zvakapinda zvakakura se $ A $ 1: $ Z $ 30. Apo bhuku rebhuku rinoponeswa, mupepeti weVBA anowedzera dhiari zviratidzo ($) kuitira kuti zvinyorwa zvinyorwa zvive zvakakwana .

Bvisa Zvidzidzo Zvokupora

Sezvakataurwa, mitsara yemupumburu inongoguma chero bedzi bhuku rebhuku rinoramba richizaruka. Nzira yakareruka yekubvisa mimwe mitemo yekupukunyuka ndeyekuchengetedza, kuswedera uye kuzarura bhuku rebhuku.

Zvimwewo, shandisa matanho maviri kusvika mana pamusoro apa kuti uwane Zvishandiso zveSheet muVBA mhariri yewindo uye bvisa urongwa hwakarongerwa kuChinyorwa Chimbo cheimba.

Muganhu Mitsara uye Columns pasina VBA

Imwe nzira uye nzira inogara yakagadziriswa yekudzivirira nzvimbo yekushanda kwepafambiti yekushanda ndeyokuvanza mitsetse isina kushandiswa nemadzamu.

Aya ndiwo matanho ekuvanza mitsetse nemakoroni kunze kwezera A1: Z30:

1. Dzvanya pamutsara unotungamirira mutsara 31 kuti usarudze mutsetse wose.
2. Dhinda uye ubatisise Shift uye Ctrl makii pane keyboard.
3. Dhinda nekusunungura kona yeA Down Arrow pakibhodi kuti usarudze mitsetse yose kubva mumuganhu 31 kusvika pasi pebasa.
4. Tsanangurira kurudyi mumutsara mutsara kuti uzarure mamiriro ekutenderera.
5. Sarudza Piga mumenyu kuti uvanze mapuranga akasarudzwa.
6. Dzvanya pahurukuro inotungamira muromo weAA uye dzokorora nhanho 2-5 kumusoro kuti uvanze mapuranga ose mushure mekomba Z.
7. Chengetedza bhuku rebhuku uye mapurumoni uye rows kunze kwebhanhire A1 kusvika Z30 richaramba rakavanzwa.

Unhide Akavanzwa Rows uye Columns

Kana bhuku rebhuku rakachengetedzwa kuchengetedza mitsara nemirasi yakavanzika kana yakazarurirwa zvakare, matanho anotevera achavhura mitsetse nemakoroni kubva pamuenzaniso uri pamusoro apa:

1. Dzvanya pamutsara weheader mumutsara 30 - kana muroti wokupedzisira unooneka mubasa rekushanda - kusarudza mutsara wose.
2. Dzvanya paIndaneti tab yebhoni .
3. Dzvanya Fomu > Hide & Unhide > Unhide Rows mubhubhoni kuti udzore mitsetse yakavanzwa.
4. Dzvanya pamutsetse wemusoro musoro wekhoma AA - kana kuti korona yekupedzisira inoratidzika - uye dzokorora matanho 2-3 kumusoro kuti unanise mapuranga ose.