Shortcut Mazano Okucheka, Kopota, uye Nyora Data muExpcel

01 ye 02

Kopa uye Nyora Datsetse muExcel ne Shortcut Keys

Kunyora deta muExcel inowanzoshandiswa kuita zvinyorwa zvinyorwa, mazano, marati , nedzimwe nhepfenyuro. Nzvimbo itsva inogona kuva

• pahwendefa rimwechete,
• pamashizha akasiyana-siyana
• mune mabhuku emabasa akasiyana kana mafaira.

Nzira dzeKunyora Data

Sezvinenge pane mapurogiramu ose eMicrosoft, kune nzira imwechete yekuita basa. Iyi mirayiridzo iri pasi apa inofanidza nzira nhatu dzekukopa nekufambisa data mu Excel.

• achishandisa kadhi kfupi,
• uchishandisa mamiriro ekutenderera mamiriro ezvinhu;
• uchishandisa menyu mapeji ari paImba yebhu yebhoni

The Clipboard uye Pasting Data

Kunyora deta hakumboiti nhanho imwechete ye nzira dzakataurwa pamusoro apa. Apo iyo kopi yemirayiridzo inoshandiswa kudhindwa kwe data yakasarudzwa inowanikwa mu clipboard , iyo inzvimbo yekuchengetedza kwenguva pfupi.

Kubva pakodhibhodhi, tsanangudzo yakasarudzwa inopinda mumusero wekuenda kana masero. Nhanho ina dzinobatanidzwa mukugadzirisa ndeizvi :

1. Sarudza deta kuti inyore;
2. Shandisai kopi ikopi;
3. Dzvanya pane sero rekuenda;
4. Shandisai mutemo wekunamatira.

Mimwe nzira yekukopa dhesi iyo isingasanganisi kushandisa bhadhibhodhi inosanganisira kushandiswa kugadzirisa kubata uye kudonha uye kudonha ne mouse.

Kopa Data mu Excel ne Shortcut Keys

Ikobhokisi yekakani inoshandiswa kushandura deta ndeyi:

Ctrl + C (iyo tsamba "C") - inobatsira kopi kopi Ctrl + V (iyo tsamba "V") - inoshandisa mutemo wekunamatira

Kukopa dhevhisi uchishandisa mashomanana ekutsvaga:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Dhinda uye ubatisise kamba Ctrl pane keyboard;
3. Dhinda uye ubudise "C" pasina kusunungura ctrl
4. Sero rakasarudzwa (s) rinofanira kuve rakakomberedzwa nemuganhu wakasviba wakasviba unozivikanwa semhashu dzinofamba kuratidzira kuti data iri mumasero kana masero ari kunyorwa;
5. Dzvanya pane sero rekuenda - kana uchienzanisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekona yeenda kunzvimbo yakatarisana ;
6. Dhinda uye ubatisise kamba Ctrl pane keyboard;
7. Dhinda nekusunungura "V" pasina kusunungura Ctrl key;
8. Izvo zvinyorwa zvinyorwa zvino zvinofanira kunge zvichange zviri munzvimbo dzose dzepakutanga uye dzinosvika.

Cherechedza: Mitsara yemiseve pabhobhoyo inogona kushandiswa panzvimbo yeiyo mutsara weguru kuti usarudze zvose masero uye nzvimbo yekuenda kana uchikopa nekudarika data.

• Kuti usarudze kakawanda masheji ari pedyo nemakwii emiseve, fona uye ubatisise key Shift .
• Kuti usarudze dzimwe dzisingasviki masero masheki, shandisa Ctrl .

2. Kopota Dhina Uchishandisa Mutevedzeri Menyu

Kunyange zvazvo sarudzo dziripo mumutauro wemamiriro ezvinhu - kana kurudyi-kanyanya menu - kazhinji shanduka zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa, kopi uye mirairo yekunamatira inogara iripo.

Kukopa deta uchishandisa mamiriro ekutenderera:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Kona pajecha rakasarudzwa (s) kuti uzarure mamiriro ekutenderera;
3. Sarudza kopi kubva pane zvaunogona kusarudza menyu sezvinoratidzwa kurutivi rworudyi rwemufananidzo kumusoro;
4. Masero akasarudzwa anofanira kukomberedzwa nyerere dzinofamba kuratidzira kuti data iri mumasero kana masero ari kunyorwa;
5. Dzvanya pane sero rekuenda - kana uchienzanisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekona yeenda kunzvimbo yakatarisana;
6. Kona pajecha rakasarudzwa (s) kuti uzarure mamiriro ekutenderera;
7. Sarudza paste kubva pane zviripo menyu zvisarudzo;
8. Izvo zvinyorwa zvinyorwa zvino zvinofanira kunge zvichange zviri munzvimbo dzose dzepakutanga uye dzinosvika.

2. Kopota Dhina uchishandisa Menu Options pane Home Tab yeRibbon

Ikopi uye pasi pemirairo zviri muClipboardboard chikamu kana bhokisi rinowanzowanikwa kuruboshwe-kuru kweTeam tab yebhoni

Kukopa dhidhiyo uchishandisa mirairo yerabhoni:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Dzvanya paKopi icon pane ribhoni;
3. Sero yakasarudzwa (s) inofanira kuve yakakombererwa nemasvosve ekufambisa kuratidza kuti data iri mumasero kana masero ari kunyorwa;
4. Dzvanya pane sero rekuenda - kana uchienzanisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekona yeenda kunzvimbo yakatarisana;
5. Dzvanya paPeta chiratidzo pane ribhoni;
6. Izvo zvinyorwa zvinyorwa zvino zvinofanira kunge zvichange zviri munzvimbo dzose dzepakutanga uye dzinosvika.

02 of 02

Shandisa Dhavhidha muExcel neChitcut Keys

Kufambisa data muExcel kunowanzoshandiswa kushandura mabasa, mazano, marati, uye nedzimwe nhepfenyuro. Nzvimbo itsva inogona kuva:

• mune rimwe bhuku rekushanda,
• mumashandi akasiyana-siyana
• mune mabhuku emabasa akasiyana kana mafaira.

Hapana huripo chaiyo yekufambisa mutemo kana kuti icon muexcel. Izwi rinoshandiswa apo kushandura data kunopera. Dhiyabhorosi yacho yakatemwa kubva panzvimbo yayo yepakutanga ndokuzopinda mune itsva.

The Clipboard uye Pasting Data

Kufambisa dambudziko hakusi imwe danho rimwe chete. Apo mutemo wekutama unosungirirwa kopi yedata rakasarudzwa inowanikwa mu clipboard , iyo inzvimbo yekuchengetedza kwenguva pfupi. Kubva pakodhibhodhi, tsanangudzo yakasarudzwa inopinda mumusero wekuenda kana masero.

Nhanho ina dzinobatanidzwa mukugadzirisa ndeizvi :

1. Sarudza deta kuti ishandiswe;
2. Shandisai murayiro wakagurwa;
3. Dzvanya pane sero rekuenda;
4. Shandisai mutemo wekunamatira.

Dzimwe nzira dzokufambisa data dzisina kusanganisira kushandisa clipboard dzinosanganisira kushandisa dragha uye udonese ne mouse.

Nzira dzakapedzwa

Sezvinenge pane mapurogiramu ose eMicrosoft, pane nzira imwe chete yekufambisa data mu Excel. Izvi zvinosanganisira:

• achishandisa kadhi kfupi,
• uchishandisa kodhi yemamiriro ekudini yemenu;
• uchishandisa menyu mapeji ari paImba yebhu yebhoni

Moving Data mu Excel ne Shortcut Keys

Iko kemikisi yekakani inoshandiswa kutevedzera deta ndeyi:

Ctrl + X (iyo tsamba "X") - inobvumira mutemo wakachekwa Ctrl + V (iyo tsamba "V") - inoshandisa mutemo wekunamatira

Kugadzirisa dhidhiyo uchishandisa mashomanana ekutsvaga:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Dhinda uye ubatisise kamba Ctrl pane keyboard;
3. Dhinda nekusunungura "X" pasina kusunungura Ctrl key;
4. Sero rakasarudzwa (s) rinofanira kuve rakakomberedzwa nemuganhu wakasviba wakasviba unozivikanwa semhashu dzinofamba kuratidzira kuti data iri mumasero kana masero ari kunyorwa;
5. Dzvanya pane sero rekuenda - kana uchitamisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekweseri yekuenda kwakatarisana;
6. Dhinda uye ubatisise kamba Ctrl pane keyboard;
7. Dhinda nekusunungura kiyi "V" pasina kusunungura ctrl key;
8. Dunhu rakasarudzwa rinofanira kunge riripo munzvimbo yekuenda chete.

Cherechedza: Mitsara yemiseve pabhobhoyo inogona kushandiswa panzvimbo yemushonga we mouse kuti usarudze zvose masero uye maenda masero kana uchicheka uye uchidhonza data.

• Kuti usarudze kakawanda masheji ari pedyo nemakwii emiseve, fona uye ubatisise key Shift .
• Kuti usarudze dzimwe dzisingasviki masero masheki, shandisa Ctrl .

2. Shandisa Dhavhidha Uchishandisa Mutevedzeri Menyu

Kunyange zvazvo sarudzo dziripo mumutauro wemamiriro ezvinhu - kana kurudyi-kanyanya menu - kazhinji shanduka zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa, kopi uye mirairo yekunamatira inogara iripo.

Kutamisa data uchishandisa mamiriro ekutenderera:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Kona pajecha rakasarudzwa (s) kuti uzarure mamiriro ekutenderera;
3. Sarudza kutemwa kubva pane zvinowanikwa menyu;
4. Masero akasarudzwa anofanira kukomberedzwa nyerere dzinofamba kuratidza kuti data iri mumasero kana masero ari kutamiswa;
5. Dzvanya pane sero rekuenda - kana uchienzanisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekona yeenda kunzvimbo yakatarisana;
6. Kona pajecha rakasarudzwa (s) kuti uzarure mamiriro ekutenderera;
7. Sarudza paste kubva pane zviripo menyu zvisarudzo;
8. Dunhu rakasarudzwa rinofanira kunge riripo chete panzvimbo yekuenda.

2. Shandisa Dhiyabhorosi uchishandisa Menu Options pane Home Tab yeRibbon

Ikopi uye pasi pemirairo zviri muClipboardboard chikamu kana bhokisi rinowanzowanikwa kuruboshwe-kuru kweTeam tab yebhoni

Kutamisa dhina uchishandisa mirairo yerabhoni:

1. Dzvanya pane sero kana kuti masero akawanda kuti uvasimbise;
2. Dzvanya paCheka icon pane ribhoni;
3. Sero yakasarudzwa (s) inofanira kuve yakakombererwa nemhashu dzinofamba kuratidzira kuti data iri mumasero kana masero ari kutamiswa;
4. Dzvanya pane sero rekuenda - kana uchienzanisa masero akawanda e data, chengetera pane sero riri kumusoro kwekona yekona yeenda kunzvimbo yakatarisana;
5. Dzvanya paPeta chiratidzo pane ribhoni;
6. Dunhu rakasarudzwa rinofanira kunge riripo munzvimbo yekuenda chete.