Viga uye Bvisa Mikoko, Row, uye Maselo muExpcel

Unoda kudzidza kuti unganyunyutira sei kana kuvanza mazamu muMicrosoft Excel? Ichi chidiki chekudzidzisa chinotsanangura matanho ose aunoda kutevera basa iroro, kunyanya:

1. Viga Columns
2. Ratidza kana Unhide Columns
3. Nzira Yokuvanza Mitsetse
4. Ratidza kana Unhide Rows

01 ye 04

Vige Columns mu Excel

Mamwe masero haagoni kuvanzwa mu Excel. Kuvanza dhesi iri mune imwe sero, kana iyo yose yakareruka kana musara sekugara inofanirwa kuvanzwa.

Nzira dzekuvanza uye dzisingaverengeki mapuranga nemitsetse dzinogona kuwanikwa pamapeji anotevera:

1. Viga Columns - ona pasi;
2. Unhide Columns - kusanganisira Column A;
3. Viga Mitsara;
4. Unhide Rows - kusanganisira Row 1.

Nzira dzakapedzwa

Sezvinenge pane mapurogiramu ose eMicrosoft, kune nzira imwechete yekuita basa. Mirayiridzo iri mumudzidzisi inovhara nzira nhatu dzekuvanza uye kubatanidza zvinyorwa uye mitsetse muExpcel worksheet:

• achishandisa kadhi kfupi,
• uchishandisa kodhi yakarurama yemenyu yemenu
• uchishandisa maitiro ekusarudza paImba yebhu yebhoni

Dhiyabhorosi Anoshandisa Makomborero Akavanzwa uye Row

Apo misoro nemitsetse ine data yakachengetwa, data haibviswe uye Iyo inogona kudzokororwa mumashira nemarati.

Mamwe mazita akavanzwa aiva nesero zvinyorwa acharamba achivandudza kana data iri mumasero akataridzirwa achichinja.

1. Viga Columns Using Shortcut Keys

Iko kemikisi inokosha yekubatanidzwa kwekuvanza mapurisa ndeyokuti:

Ctrl + 0 (zero)

Kuvanza Imwe Column Rimwe Kushandisa Keyboard Shortcut

1. Dzvanya pane imwe sero iri mumutsetse kuti uvanzwe kuti uite sero rinoshanda.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dhinda uye ubudise "0" pasina kusunungura ctrl .
4. Iyo chinyorwa chine sero rinoshandiswa pamwe chete nedhimwe dingiri iro raive rinofanira kuvanzwa kubva pakuona.

• Kuti uvanze mahwendefa mazhinji uchishandisa nzira yekodhi, tsanangurira kamwe kero rimwe muhomwe imwe neimwe kuti ivanzwe, uye dzokorora matanho 2 ne3 pamusoro.

2. Viga Columns Uchishandisa Mutevedzeri Menyu

Zvisarudzo zviripo mumutauro wemamiriro ezvinhu - kana kurudyi-kanda menu - shandura zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa.

Kana Chekuvhara chisarudzo, sezvakaratidzwa mumufananidzo uri pamusoro, hazviwaniki mumenu yezvakakanganisika zvingangodaro kuti iyo yose koromo yakanga isina kusarudzwa apo menyu yakavhurwa.

Kuvanza Imwe Column

1. Dzvanya pamutsetse wemusoro wei column kuitira kuti uvanzwe kuti usarudze iyo yose yakavhara.
2. Kurudyi pfuurira pane imwe sarudzo yakasarudzwa kuti uzarure mamiriro ekutenderera.
3. Sarudza Kuvanza kubva kumenyu.
4. Tsamba yakasarudzwa, tsamba yekorinhe, uye chero dhesi iri muhomwe ichavanzwa kubva pakuona.

Kuvanza Mazamu Akajeka

Somuenzaniso, unoda kuvanza mapuranga C, D, uye E.

1. Muchikamu chinyorwa, dika uye dhonza nemuongorori we mouse kuti uise pachena misoro mitatu.
2. Kumanikodha pamakorani akasarudzwa.
3. Sarudza Kuvanza kubva kumenyu.
4. Tsanangudzo dzakasarudzwa uye dzinyorwa dzichavanzwa kubva pakuona.

Kuvanza Makamuri Akaparadzaniswa

Somuenzaniso, unoda kuvanza mapuranga B, D, uye F

1. Muchikamu chinyorwa tsvaga pa column yekutanga kuti ivanzwe.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Ramba uchibatisisa Ctrl kiyi uye chovha kamwechete pane imwe imwe yeramende imwe yakavigwa kuti uiite.
4. Bvisa Ctrl .
5. Muchikamu chemusoro, tsanangurira pakarurama pane imwe yemakorani akasarudzwa.
6. Sarudza Kuvanza kubva kumenyu.
7. Tsanangudzo dzakasarudzwa uye dzinyorwa dzichavanzwa kubva pakuona.

Cherechedza : Kana muchivanza mapoka akaparadzana, kana iyo pointer yeguru isiri pamusoro pemusoro wemusoro wepamusoro apo kodzero yekona bundu inenge yakanyedzwa, chisarudzo chisingawanikwi.

02 of 04

Ratidza kana Unhide Columns mu Excel

1. Kubatanidza Kofu A Achishandisa Zita Bhokisi

Iyi nzira inogona kushandiswa kubatanidza chero imwe yendarama - kwete kungowona A.

1. Tora iyo cell reference A1 muZita reBhokisi .
2. Dhinda pikicha yePinda mubhobhoyo kuti usarudze chinyorwa chakavanzika.
3. Dzvanya paImba yebhu yebhoni .
4. Dzvanya paIndaneti icon paibhoni kuti uzarure mhando yezvinyorwa zvezvasarudzo.
5. Muchioneka chechikamu chemenyu , sarudza Hide & Unhide> Unhide Column.
6. Chinyorwa A chichava chichioneka.

2. Unhide Column A Using Shortcut Keys

Iyi nzira inogonawo kushandiswa kubatanidza chero imwe yendarama - kwete kungowona A.

Iko kusanganisa kukuru kwekuvhara mapurumu ndeyokuti:

Ctrl + Shift + 0 (zero)

Kugadzira Unhide Column A Using Shortcut Keys uye Zita Bhokisi

1. Tora iyo cell reference A1 muZita reBhokisi.
2. Dhinda pikicha yePinda mubhobhoyo kuti usarudze chinyorwa chakavanzika.
3. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
4. Dhinda uye kusunungura "0" key kunze kwekusunungura Ctrl uye Shift keys.
5. Chinyorwa A chichava chichioneka.

Kubatanidza Rimwe kana Zvimwe Zvinyorwa Zvichishandisa Kushandura Keys

Kuti unanise imwe kana imwe mikoko, shandisai imwe sero mumakoroni kune rumwe rutivi rwemukoko wakavanzika (s) ane mouse pointer.

Somuenzaniso, unoda kubatanidza zvinyorwa B, D, uye F:

1. Kuti unganise mapuranga ose, chovha uye dhonza ne mouse kuti uise ma column A kusvika kuG.
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
3. Dhinda uye kusunungura "0" key kunze kwekusunungura Ctrl uye Shift keys.
4. Nzvimbo yakavanzwa (s) ichava inooneka.

3. Unhide Columns Uchishandisa Mutsetse Menyu

Sezvo neyo nzira shoma yekutsvaga yepamusoro, unofanidza kusarudza imwe imwe yendarama kune rumwe rutivi rwehandi yakavanzika kana kuti mapuroni kuitira kuti muvabatanise.

Kubatanidza Rimwe kana Mamwe Mavara

Somuenzaniso, kubatanidza zvinyorwa D, E, uye G:

1. Hover the mouse pointer pane column C mumutsetse musoro.
2. Dzvanya uye dhonza ne mouse kuti uise misimboti C kusvika H kuti unanise mapuranga ose panguva imwechete.
3. Kumanikodha pamakorani akasarudzwa.
4. Sarudza Unhide kubva kumenyu.
5. Nzvimbo yakavanzwa (s) ichava inooneka.

4. Nyora Column A mu Excel Versions 97 kusvika 2003

1. Tora iyo cell reference reference A1 muZita reBhokisi uye divhai Enter Enter pakiti.
2. Dzvanya paIma menu.
3. Sarudza Column> Unganidza mumenyu.
4. Chinyorwa A chichava chichioneka.

03 of 04

Nzira Yokuvanza Mitsetse muExcel

1. Viga Mirefu uchishandisa Shortcut Keys

Ikobhokisi yekakani inobatanidza yekuvanza mitsetse ndeyi:

Ctrl + 9 (nhamba mapfumbamwe)

Kuvanza Row Rwemwe uchishandisa Keyboard Shortcut

1. Dzvanya pane sero mumutsara kuti uvanzwe kuti uite sero rinoshanda .
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dhinda nekusunungura "9" pasina kusunungura ctrl .
4. Mutsara waiva nesero inoshandiswa pamwe chete nedhimwe data iyo iripo inofanira kuvanzwa kubva pakuona.

• Kuti uvanze mitsetse yakawanda uchishandisa nzira yekucheka kwebhokisi, shandisa imwe sero mumutsara mumwe nomumwe kuti uvanzwe, uye dzokorora matanho 2 ne3 pamusoro.

2. Viga Mireza Uchishandisa Mutevedzeri Menyu

Zvisarudzo zviripo mumutauro wemamiriro ezvinhu - kana kurudyi-kanda menu - shandura zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa.

Kana Chekuvhara chisarudzo, sezvinoratidzwa mumufananidzo uri pamusoro, hazviwaniki mumenyu yezvakakanganisika zvinowanzoita kuti mutsara wose usina kusarudzwa apo menyu yakavhurwa. Nzira yekuvanza inongowanikwa apo mutsetse wose wakasarudzwa.

Kuvanza Row Rumwe

1. Dzvanya pamutsara weheader wezera kuti uvanzwe kuti usarudze mutsetse wose.
2. Kurudyi pfupa pahedheni yakasarudzwa kuti uzarure mamiriro ekutenderera
3. Sarudza Kuvanza kubva kumenyu.
4. Rutivi rwakasarudzwa, rutsamba rwemutsara, uye chero data iri mumutsara ichavanzwa kubva pakuona.

Kuvanza Rakanaka Mitsara

Somuenzaniso, unoda kuvanza mitsetse 3, 4, uye 6.

1. Mutsara weheader, dika uye dhonza nemushonga pointer kuisa mitsetse yose mitatu.
2. Kurudyi pfupa kumiromo yakasarudzwa.
3. Sarudza Kuvanza kubva kumenyu.
4. Mitsara yakasarudzwa ichavanzwa kubva pakuona.

Kuvanza Mavara Akaparadzaniswa

Somuenzaniso, unoda kuvanza mitsetse 2, 4, uye 6

1. Mutsara weheader, chengeta pamutsara wokutanga kuti uvanzwe.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Ramba uchibatisisa ctrl kiyi uye chovha kamwe chete pamutsara mumwe oga kuti uvanzwe kuti uzvisarudze.
4. Kurudyi penya pane imwe yemitsetse yakasarudzwa.
5. Sarudza Kuvanza kubva kumenyu.
6. Mitsara yakasarudzwa ichavanzwa kubva pakuona.

04 we 04

Ratidza kana Unhide Rows mu Excel

1. Simudza Row 1 Uchishandisa Zita Bhokisi

Iyi nzira inogona kushandiswa kubatanidza mutsara mumwechete - kwete mutsara 1.

1. Tora iyo cell reference A1 muZita reBhokisi.
2. Dhinda pikicha yePinda mubhobhoyo kuti usarudze mutsara wakavanzika.
3. Dzvanya paImba yebhu yebhoni.
4. Dzvanya paIndaneti icon paibhoni kuti uzarure mhando yezvinyorwa zvezvasarudzo.
5. Muchioneka chechikamu chemenyu , sarudza Hide & Unhide> Unhide Row.
6. Row 1 ruchazoonekwa.

2. Simbisa Row 1 Uchishandisa Shortcut Keys

Iyi nzira inogona kushandiswa kushandura mutsara mumwe chete - kwete mutsara 1.

Iko kuunganidza kukuru kwemasero asina kuvhara ndeokuti:

Ctrl + Shift + 9 (nhamba mapfumbamwe)

Kuti Unhide Row 1 uchishandisa Shortcut Keys uye Zita Bhokisi

1. Tora iyo cell reference A1 muZita reBhokisi.
2. Dhinda pikicha yePinda mubhobhoyo kuti usarudze mutsara wakavanzika.
3. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
4. Dhinda uye usunungure kiyi yakatorwa 9 usingasununguri Ctrl uye Shift keys.
5. Row 1 ruchazoonekwa.

Kubatanidza Rimwe kana Mamwe Mitsara Inoshandisa Shortcut Keys

Kuti unyanise imwe kana kupfuura, tsanangurira imwe sero mumigwagwa kune rumwe rutivi rwemitsetse yakavanzwa (s) ine mouse pointer.

Semuenzaniso, unoda kubatanidza mitsetse 2, 4, uye 6:

1. Kuti unganise mitsetse yose, tora uye dhonza ne mouse kuti uise mitsetse 1 kusvika ku7.
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
3. Dhinda uye usunungure kiyi yakatorwa 9 usingasununguri Ctrl uye Shift keys.
4. Mutsara wakavanzwa (s) uchava kuonekwa.

3. Unhide Rows Uchishandisa Mifananidzo Yemutauro

Sezvo neyo nzira yekambani yepamusoro yepamusoro, unofanidza kusarudza musara rimwe chete kune rumwe rutivi rwemutsara wakavanzwa kana mitsetse kuitira kuti uvananise.

Kubatanidza Rimwe kana Mamwe Mitsara Inoshandisa Mifananidzo Yemaonero

Semuenzaniso, kubatanidza mizere 3, 4, uye 6:

1. Hover the mouse pointer pane mutsara 2 mumutsara weheader.
2. Dzvanya uye dhonza ne mouse kuti uise mitsetse 2 kusvika ku7 kuti unanise mitsetse yose panguva imwechete.
3. Kurudyi pfupa kumiromo yakasarudzwa.
4. Sarudza Unhide kubva kumenyu.
5. Mutsara wakavanzwa (s) uchava kuonekwa.

4. Simbisa Row 1 mune Excel matamba 97 kusvika muna 2003

1. Tora iyo cell reference reference A1 muZita reBhokisi uye divhai Enter Enter pakiti.
2. Dzvanya paIma menu.
3. Sarudza Row> Unganidza mumenyu.
4. Row 1 ruchazoonekwa.

Iwe unofanirwawo kuongorora dzidziso yakabatana pamusoro pokuti ungavanza sei uye unanise maeseji e Excel .