Nzira yekuwedzera uye kubvisa Rows uye Columns mu Excel

Sezvinenge pane mapurogiramu ose eMicrosoft, kune nzira imwechete yekuita basa. Iyi mirayiridzo inovhara nzira mbiri dzekuwedzera uye kubvisa mitsetse nemakoroni mune pepa re Excel worksheet :

• achishandisa kadhi kfupi
• uchishandisa kodhi yakarurama yemenyu yemenu

Wedzera Mitsara KuAn Excel Worksheet

Apo mazamu nemitsetse ine data ichibviswa, iyo data inobviswa zvakare. Izvi kurasikirwa kunogonawo kuchinja mafomu nemasharu ayo akatarisa deta mumabhururo akadzingwa nemitsara.

Kana iwe uchikanganisa zvinyorwa kana mitsetse ine data, shandisa kushandiswa kwezvinhu paibhoni kana kuti iyi nzira shoma yebhobhoyo kuti udzorere deta yako.

Wedzera Mitsara uchishandisa Shortcut Keys

Iko kemikisi yekukwikwidza kusanganiswa kwekuwedzera mitsetse kune rimwe pepaji ndeyokuti:

Ctrl + Shift + "+" (pamwe nechiratidzo)

Cherechedza : Kana iwe uine kadhibhokisi neNhamba Pad kune kurudyi kwebhodhi rekugara, unogona kushandisa chiratidzo + ipapo pasina Shift key. Iko inosanganiswa inowanikwa chete:

Ctrl + "+" (pamwe nechiratidzo)

• Usati wawedzera mutsara, iwe unoudza Excel apo unoda kuti itsva iiswe nekusarudza muvakidzani wayo. Izvi zvinogonawo kuitwa kuburikidza nekuchera kwebhokisi:

Shift + Spacebar

Excel ichaisa mutsara mutsva pamusoro pemutsara wakasarudzwa.

Kuti Uwedzere Rumwe Rwena uchishandisa Keyboard Shortcut

1. Dzvanya pane sero mumutsara uko iwe unoda mutsva mutsva uwedzerwa.
2. Dhinda uye ubatisise key Shift pane keyboard
3. Dhinda uye ubudise Spacebar pasina kusunungura key Shift .
4. Mutsara wose unofanira kusarudzwa.
5. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
6. Dhinda uye ubudise "+" kiyi pasina kusunungura Ctrl uye Shift keys.
7. Mutsara mutsva unofanira kuwedzerwa pamusoro pemutsara wakasarudzwa.

Kuti Uwedzere Multiple Yakatarisa Rows uchishandisa Keyboard Shortcut

Iwe unoudza Excel kuti yakawanda sei mitsara yakatarisana yaunoda kuwedzera pane pepa rekushanda nekusarudza nhamba yakafanana yemirasi yaivepo.

Kana iwe uchida kuisa mitsara miviri mitsva, sarudza mitsetse miviri iripo apo unoda kuti itsva dzivepo. Kana iwe uchida mitsara mitatu mutsva, sarudza zvitatu zviripo.

Kuti Uwedzere Mitsva mitatu Mutsva kune Pepa Rokushanda

1. Dzvanya pane sero mumutsara apo iwe unoda mitsetse mitsva yakawedzerwa.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dhinda uye ubudise Spacebar pasina kusunungura key Shift .
4. Mutsara wose unofanira kusarudzwa.
5. Ramba uchibata pasi Shift key.
6. Dhinda nekusunungura tsvimbo yeKup Up kaviri kuti usarudze mitsara miviri yakawedzerwa.
7. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
8. Dhinda uye ubudise "+" kiyi pasina kusunungura Ctrl uye Shift keys.
9. Mitsara mitatu mitsva inofanira kuwedzerwa pamusoro pemitsetse yakasarudzwa.

Wedzera Mireza Uchishandisa Mutevedzeri Menyu

Icho chisarudzo mumutauro wemamiriro ezvinhu - kana kurudyi-pikicha menyu - iyo inoshandiswa kuwedzera mitsetse kune rimwe pepa rekuisa in Insert.

Sezvo neyo nzira ye keyboard, pamusoro pekuwedzera mutsara, iwe unoudza Excel apo iwe unoda kuti itsva iiswe nekusarudza muvakidzani wayo.

Nzira yakareruka yekuwedzera mitsetse uchishandisa mamiriro ekutenderera ndeyekusarudza mutsara wose nekunyanya pamutsara weheader .

Kuti Uwedzere Rumwe Rwe Pashanduri Yebasa

1. Dzvanya pamutsara weheader wemutsara uko iwe unoda mutsva mutsva uwedzerwa kusarudza mutsetse wose.
2. Kungofa-bhora pamutsara wakasarudzwa kuti uzarure mamiriro ekutenderera.
3. Sarudza Faka kubva kumenyu.
4. Mutsara mutsva unofanira kuwedzerwa pamusoro pemutsara wakasarudzwa.

Kuwedzera Multiple Yakawanda Row

Zvakare, iwe unoudza Excel kuti mitsva yakawanda mitsva ipi yaunoda kuwedzera pane pepa rekushanda nekusarudza nhamba yakafanana yemirasi yaivepo.

Kuti Uwedzere Mitsva mitatu Mutsva kune Pepa Rokushanda

1. Mutsara weheader, dika uye dhonza ne mouse pointer kuti uratidze mitsara mitatu uko iwe unoda mitsetse mitsva yakawedzerwa.
2. Kurudyi pfupa kumiromo yakasarudzwa.
3. Sarudza Faka kubva kumenyu.
4. Mitsara mitatu mitsva inofanira kuwedzerwa pamusoro pemitsetse yakasarudzwa.

Dhonza Rows muExpcel Worksheet

Ikobhokisi yekwiiyo huru yekubatanidza mitsetse kubva pahwheti yepasiti ndeyokuti:

Ctrl + "" (minus sign)

Nzira inonyanya kuvhara mutsara ndeyekusarudza musara wose kuti ushandiswe. Izvi zvinogonawo kuitwa kuburikidza nekuchera kwebhokisi:

Shift + Spacebar

Kugadzirisa imwe Row Rokushandisa uchishandisa Keyboard Shortcut

1. Dzvanya pane sero mumutsara kuti ushandiswe.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dhinda uye ubudise Spacebar pasina kusunungura key Shift .
4. Mutsara wose unofanira kusarudzwa.
5. Bvisa Shift key.
6. Dhinda uye ubatisise kamba Ctrl pane keyboard.
7. Dhinda nekusunungura " - " kiyi pasina kusunungura ctrl .
8. Rutivi rwakasarudzwa rinofanira kubviswa.

Kuchenesa Mitsara Yakakosha uchishandisa Keyboard Shortcut

Kusarudza mitsetse yakatarisana mune pepa rekushanda kuchakubvumira kuti uibvise zvose kamwechete. Kusarudza mitsara yakatarisana kunogona kuitwa uchishandisa miseve yemiseve pabhobhoyo mushure mokunge musara wokutanga wasarudzwa.

Kuchenesa Mitsara mitatu kubva paPepa Rokushanda

1. Dzvanya pane sero mumutsara kumucheto wezasi weboka remitsara inofanira kubviswa.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dhinda uye usunungure bharata rekusara pasina kusunungura key Shift .
4. Mutsara wose unofanira kusarudzwa.
5. Ramba uchibata pasi Shift key.
6. Dhinda nekusunungura tsvimbo yeKup Up kaviri kuti usarudze mitsara miviri yakawedzerwa.
7. Bvisa Shift key.
8. Dhinda uye ubatisise kamba Ctrl pane keyboard.
9. Dhinda nekusunungura " - " kiyi pasina kusunungura ctrl .
10. Mitsara mitatu yakasarudzwa inofanira kubviswa.

Bvisa Ropa Uchishandisa Mutevedzeri Menyu

Icho chisarudzo mumutauro wezvakataurwa-kana kurudyi-kanda menu - iyo inoshandiswa kubvisa mitsetse kubva pahwhepa rekushandisa iChenesa.

Nzira inonyanya kuvhara mitsetse uchishandisa mamiriro ekutenderera ndeyekusarudza mutsara wose nekunyanya pamutsara wemusoro.

Kuchenesa Rumwe Rwendo kune Pepa Rokushanda

1. Dzvanya pamutsara weheader wemuganhu kuti ushandiswe.
2. Kurudyi pfupa pahedheni yakasarudzwa kuti uzarure mamiriro ekutenderera.
3. Sarudza Bvisa kubva kumenyu.
4. Rutivi rwakasarudzwa rinofanira kubviswa.

Kugadzirisa Mamiro Akawanda Anowanikwa

Zvakare, mitsara yakawanda yakatarisana inogona kubviswa panguva imwe chete kana dzose dzakasarudzwa

Kuchenesa Mitsara mitatu kubva paPepa Rokushanda

Mutsara weheader, dika uye dhonza nemuyoti pointer kuisa mitsetse mitatu yakatarisana

1. Kungofa-kworudyi pamisara yakasarudzwa.
2. Sarudza Bvisa kubva kumenyu.
3. Mitsara mitatu yakasarudzwa inofanira kubviswa.

Kuchenesa Mitsara Yakasiyana

Sezvinoratidzwa mumufananidzo wepamusoro, zvakaparadzana, kana zvisingasviki mitsetse zvinogona kubviswa panguva imwe chete nekutanga kusarudza ivo neCtrl key uye mouse.

Kusarudza Mavara Akasiyana

1. Dzvanya mumutsara wemusoro wezera rokutanga kuti ubvise.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dzvanya pamimwe mitsetse iri mumutsara wemusoro kuti uasarudze.
4. Kungofa-kworudyi pamisara yakasarudzwa.
5. Sarudza Bvisa kubva kumenyu.
6. Mitsetse yakasarudzwa inofanira kubviswa.

Wedzera Columns kune imwe Excel Worksheet

Iko kemikisi huru yekubatanidza kwekuwedzera ma column kumushandi wekushanda kwakafanana nekuwedzera mitsara:

Ctrl + Shift + "+" (pamwe nechiratidzo)

Cherechedza: Kana iwe uine kadhibhokisi neNhamba Pad kune kurudyi kwebhodhi rekugara, unogona kushandisa chiratidzo + ipapo pasina Shift key. Iko inosanganiswa iyo inongova Ctrl + "+".

• Usati wati wandei, unotaurira Excel apo unoda kuti itsva iiswe nekusarudza muvakidzani wayo. Izvi zvinogonawo kuitwa kuburikidza nekuchera kwebhokisi:

Ctrl + Spacebar

Excel ichaisa iyo chinyorwa chitsva kuruboshwe rwe column yakasarudzwa.

Kuti Uwedzere Imwe Column uchishandisa Keyboard Shortcut

1. Dzvanya pane sero iri mumutsara apo iwe unoda humbo hutsva huwedzerwa.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dhinda uye ubudise Spacebar pasina kusunungura Ctrl .
4. Ikosi yose inofanira kusarudzwa.
5. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
6. Dhinda uye ubudise " + " pasina kusunungura Ctrl uye Shift keys.
7. Sirasi itsva inofanira kuwedzerwa kuruboshwe rwesarudzo yakasarudzwa.

Kuwedzera Multiple Adamente Columns uchishandisa Keyboard Shortcut

Iwe unoudza Excel kuti zvipi zvitsva zvitsva zviri pamakamuri iwe unoda kuwedzera pane pepa rekushanda nekusarudza nhamba yakafanana yemakamuri aripo.

Kana iwe uchida kuisa mahwendefa maviri matsva, sarudza mairi emirasi aripo uko iwe unoda kuti itsva dzivepo. Kana iwe uchida zvitatu zvitsva, sarudza zvitatu zviripo.

Kuwedzera Zvitsva Zvitsva zvitatu kune Pepa Rokushanda

1. Dzvanya pane sero iri munhare iyo iwe unoda kuti mapuranga matsva awedzere.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dhinda uye usunungure bharata rega pasina kusunungura kiyi Ctrl .
4. Ikosi yose inofanira kusarudzwa.
5. Bvisa Ctrl .
6. Dhinda uye ubatisise key Shift pane keyboard.
7. Dhinda nekusunungura Tsvimbo Yakarurama yekoni kaviri kuti usarudze mahwendefa maviri.
8. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
9. Dhinda uye ubudise " + " pasina kusunungura Ctrl uye Shift keys.
10. Mitsara mitatu mitsva inofanira kuwedzerwa kuruboshwe kumadzorodzwa akasarudzwa.

Wedzera Columns Uchishandisa Mutevedzeri Menyu

Icho chisarudzo mumutauro wemamiriro ezvinhu - kana kurudyi-pikicha menyu - iyo inoshandiswa kuwedzera ma column kumushandi wePaiti.

Sezvo neyo mhizha yemu keyboard, usati wawedzera imwe koromo, unotaurira Excel apo unoda kuti itsva iiswe nekusarudza muvakidzani wayo.

Nzira inonyanya kuwedzera ma column kuburikidza nemenyu yakatarisana ndeyokusarudza iyo yose yakafuridzirwa nekutarisa pa column column header.

Kuti Uwedzere Imwe Column kune Pepa Rokushanda

1. Dzvanya pahurukuro musoro we column uko iwe unoda kuti mutsara watsva uwedzerwe kusarudza iyo yose column.
2. Kanda-kona pane imwe sarudzo yakasarudzwa kuti uzarure mamiriro ekutenderera.
3. Sarudza Faka kubva kumenyu.
4. Sirasi itsva inofanira kuwedzerwa pamusoro pekhesa rakasarudzwa.

Kuti Uwedzere Mamwe Makoromendi Akawanda

Zvakare sekunge nemitsetse, iwe unoudza Excel kuti mangani emirasi matsva iwe unoda kuwedzera pane pepa rekushanda nekusarudza nhamba yakafanana yehurukuro iripo.

Kuwedzera Zvitsva Zvitsva zvitatu kune Pepa Rokushanda

1. Muchikamu chetemusoro, sarudza uye dhonza nemuongorori we mouse kuti uise misoro mitatu iyo iwe unoda kuti mapuranga matsva awedzere.
2. Kumanikodha pamakorani akasarudzwa.
3. Sarudza Faka kubva kumenyu.
4. Zvitatu zvitatu zvitsva zvinofanira kuwedzerwa kuruboshwe rwemasarudzo akasarudzwa.

Bvisa Columns kubva kune Excel Worksheet

Ikobhobho yekiyo hurukuro yekubatanidza kwekubvisa mapuranga kubva pane pepa rekuita ndeyokuti:

Ctrl + "" (minus sign)

Nzira yakareruka yekudzima korona ndeyokusarudza iyo yose yakafuridzirwa inofanira kubviswa. Izvi zvinogonawo kuitwa kuburikidza nekuchera kwebhokisi:

Ctrl + Spacebar

Kuchenesa Imwe Kumbomusi uchishandisa Keyboard Shortcut

1. Dzvanya pane sero iri mumutsetse kuti ubvise.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dhinda uye ubudise Spacebar pasina kusunungura key Shift .
4. Ikosi yose inofanira kusarudzwa.
5. Ramba uchibatisisa Ctrl kiyi pane keyboard.
6. Dhinda nekusunungura " - " kiyi pasina kusunungura ctrl .
7. Nzvimbo yakasarudzwa inofanira kubviswa.

Kuchenesa Mazamu Akakosha achishandisa Keyboard Shortcut

Kusarudza mbiru dziri pedo mune pepa rekushanda kuchakubvumira kuti udzibvise zvose kamwechete. Kusarudza mbiru dziri pedyo zvinogona kuitwa kuburikidza nemakona ekusvitsa pabhobhodhi mushure mokunge korimusi yekutanga yakasarudzwa.

Kugadzirisa Makoratu Matatu kubva Padhipa Rokushanda

1. Dzvanya pane sero mune imwe chinyorwa pamagumo ekupedzisira eboka remakamuri kuti ribviswe.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dhinda uye usunungure bharata rekusara pasina kusunungura key Shift .
4. Ikosi yose inofanira kusarudzwa.
5. Ramba uchibata pasi Shift key.
6. Dhinda nekusunungura khizha yebhove yepamusoro kaviri kuti usarudze mahwendefa maviri.
7. Bvisa Shift key.
8. Dhinda uye ubatisise kamba Ctrl pane keyboard.
9. Dhinda nekusunungura " - " kiyi pasina kusunungura ctrl .
10. Iyo mitatu mitatu yakasarudzwa inofanira kubviswa.

Bvisa Columns Uchishandisa Context Menu

Icho chisarudzo mumutauro wezvakataurwa-kana kurudyi-kona menu - iyo inoshandiswa kubvisa mapuranga kubva pane pepa rekushandisa iChenesa.

Nzira yakareruka yekubvisa mapurumusi uchishandisa mamiriro ekutenderera ndeyekusarudza iyo yose yakafuridzirwa nekunyanya pa column column.

Kugadzirisa Imwe Kumburu kune Pepa Rokushanda

1. Dzvanya pahurukuro musoro wei column kuti ibvise.
2. Kanda-kona pane imwe sarudzo yakasarudzwa kuti uzarure mamiriro ekutenderera.
3. Sarudza Bvisa kubva kumenyu.
4. Nzvimbo yakasarudzwa inofanira kubviswa.

Kuchenesa Mazamu Akawanda Akawanda

Zvakare, dzakawanda zvakapoteredza ma column dzinogona kubviswa panguva imwe chete kana dzose dzakasarudzwa.

Kugadzirisa Makoratu Matatu kubva Padhipa Rokushanda

1. Muchikamu chinyorwa, dika uye dhonza nemuongorori we mouse kuti uratidze zvitatu zvakatarisana nemirasi.
2. Kumanikodha pamakorani akasarudzwa.
3. Sarudza Bvisa kubva kumenyu.
4. Iyo mitatu mitatu yakasarudzwa inofanira kubviswa.

Kuchenesa Mavara Akaparadzana

Sezvinoratidzwa mumufananidzo wepamusoro, zvakaparadzana, kana zvisingasviki mazamu zvinogona kubviswa panguva imwe chete nekutanga kusarudza ivo neCtrl key uye mouse.

Kusarudza Mavara Akaparadzaniswa

1. Dzvanya mumutsetse wemusoro wekorori yokutanga kuti ubvise.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dzvanya pamimwe mitsetse iri mumutsetse wepamusoro kuti uasarudze.
4. Dzvanya pamakorani akasarudzwa.
5. Sarudza Bvisa kubva kumenyu.
6. Tsanangudzo dzakasarudzwa dzinofanira kubviswa.