Njira Zowonjezera Zodula, Kukopera, ndi Kuyika Dongosolo mu Excel

01 a 02

Lembani ndi kuyika Dongosolo mu Excel Ndi Zowonjezera Zowonjezera

Kulemba deta ku Excel kumagwiritsidwira ntchito mobwerezabwereza ntchito, ndondomeko, ma chart , ndi deta zina. Malo atsopano angakhale

• pa tsamba limodzi,
• pamasamba osiyana
• mu zolemba zosiyana kapena mafayilo.

Njira Zopangira Deta

Monga mu mapulogalamu onse a Microsoft, pali njira imodzi yokwaniritsira ntchito. Malangizo omwe ali pansiwa ali ndi njira zitatu zokopera ndi kusuntha deta ku Excel.

• pogwiritsa ntchito njira yomasulira,
• pogwiritsa ntchito pulogalamu yolumikiza pomwepo;
• pogwiritsa ntchito makasitomala omwe ali pa tsamba la Pakiti la riboni

The Clipboard ndi Pasting Data

Kulemba deta sikuli njira imodzi yokha ya njira zomwe tatchulidwa pamwambapa. Pamene lamulo lako likuloledwa, chophindikizidwa cha deta yosankhidwa chimayikidwa mu bolodi la zojambulajambula , zomwe ndi malo osungirako osakhalitsa.

Kuchokera ku bolodi la zojambulajambula, deta yosankhidwa imadulidwa mu selo loyandikira kapena maselo. Njira zinayi zomwe zikugwiritsidwa ntchito ndi :

1. Sankhani deta kuti ikopedwe;
2. Yambitsani lamulo lakopi;
3. Dinani pa selo lopita;
4. Yambitsani lamulo loyika.

Njira zina zokopera deta zomwe sizikuphatikizapo kugwiritsa ntchito bolodi la zojambulazo zimagwiritsidwa ntchito pogwiritsira ntchito chodzaza ndi kukokera ndi kuponya ndi mbewa.

Lembani Deta mu Excel ndi Zowonjezera Zake

Mipangidwe yamakina a makiyi ogwiritsidwa ntchito kusuntha deta ndi:

Ctrl + C (kalata "C") - imayambitsa lamulo lakopera Ctrl + V (kalata "V") - imayambitsa lamulo

Kukopera deta pogwiritsa ntchito makiyi afuputa:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Koperani ndi kusunga makiyi a Ctrl pa kibokosi;
3. Dinani ndi kumasula "C" popanda kumasula makiyi a Ctrl
4. Maselo osankhidwa ayenera kuzunguliridwa ndi malire akuda akudziwika ngati nyerere kuti azisonyeza kuti deta kapena maselo akukopedwa;
5. Dinani pa selo lopitako - pamene mukujambula maselo angapo a deta, dinani selo ili pamwamba pa ngodya yakutali ya malo opita;
6. Koperani ndi kusunga makiyi a Ctrl pa kibokosi;
7. Koperani ndi kumasula "V" popanda kumasula makiyi a Ctrl ;
8. Deta yobwerezabwereza iyenera kukhala tsopano kumalo oyambirira ndi opita.

Zindikirani: Mitsuko ya makina pa kibokosiyi ingagwiritsidwe ntchito mmalo mwa pointer ya mouse kuti muzisankha maselo omwe amachokera komanso omwe akupita pakukopera ndi kusunga deta.

• Kusankha maselo omwe ali pafupi ndi makiyiwo, fanizani ndi kugwiritsira chinsinsi cha Shift .
• Kusankha maselo ambiri osakhala pafupi ndi makiyi, mugwiritse ntchito makiyi a Ctrl .

2. Lembani Data Pogwiritsa Ntchito Mndandanda wa Mndandanda

Ngakhale zosankha zomwe zilipo mndandanda wa masewera - kapena pang'anizani pomwe-menyu - nthawi zambiri musinthe malinga ndi chinthu chimene mwasankha pamene menyu yatsegulidwa, malamulo ndi kusunga malamulo nthawi zonse amakhalapo.

Kujambula deta pogwiritsa ntchito menyu yoyandikana nawo:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Dinani kumene pa selo yosankhidwa kuti mutsegule zolemba;
3. Sankhani kapepala pamasewero omwe alipo omwe akuwonetsedwa kumbali yakumanja ya chithunzi pamwambapa;
4. Maselo osankhidwa ayenera kuzunguliridwa ndi nyerere kuti azisonyeza kuti deta yanu kapena maselo akukopedwa;
5. Dinani pa selo lopitako - pamene mukujambula maselo angapo a deta, dinani selo ili pamwamba pa ngodya yakutali ya malo opita;
6. Dinani kumene pa selo yosankhidwa kuti mutsegule zolemba;
7. Sankhani phala kuchokera ku menyu omwe mungapeze;
8. Deta yobwerezabwereza iyenera kukhala tsopano kumalo oyambirira ndi opita.

2. Lembani Data Pogwiritsa Ntchito Zosankha Zamkati pa Kabukhu Kakang'ono ka Pakhungu

Malemba ndi kusunga malamulo ali mu Clipboard gawo kapena bokosi nthawi zambiri ili kumbali ya kumanzere kwa Tsamba la Home la Riboni

Kujambula deta pogwiritsa ntchito malamulo a riboni:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Dinani pa chithunzi pa kanema;
3. Maselo osankhidwa ayenera kuzunguliridwa ndi nyerere kuti azisonyeza kuti deta kapena maselo akukopedwa;
4. Dinani pa selo lopitako - pamene mukujambula maselo angapo a deta, dinani selo ili pamwamba pa ngodya yakutali ya malo opita;
5. Dinani pa Pasani chithunzi pa riboni;
6. Deta yobwerezabwereza iyenera kukhala tsopano kumalo oyambirira ndi opita.

02 a 02

Sungani Deta mu Excel ndi Zowonjezera Zowonjezera

Kusuntha deta ku Excel kumagwiritsidwa ntchito popititsa ntchito, ndondomeko, ma chati, ndi zina. Malo atsopano angakhale:

• mu tsamba limodzi,
• m'mabuku osiyana
• mu zolemba zosiyana kapena mafayilo.

Palibe mchitidwe weniweni wosunthira kapena chizindikiro cha Excel. Mawu ogwiritsidwa ntchito pamene kusuntha deta kudulidwa. Deta imadulidwa kuchoka ku malo ake oyambirira ndikupangidwira ku yatsopano.

The Clipboard ndi Pasting Data

Deta yosuntha siyendetsedwe kamodzi. Pamene lamulo loyendetsa likuyankhidwa kopi ya deta yosankhidwa imayikidwa mu bolodi losindikizira , yomwe ili malo osungirako osakhalitsa. Kuchokera ku bolodi la zojambulajambula, deta yosankhidwa imadulidwa mu selo loyandikira kapena maselo.

Njira zinayi zomwe zikugwiritsidwa ntchito ndi :

1. Sankhani deta kuti isunthidwe;
2. Yambitsani lamulo lodulidwa;
3. Dinani pa selo lopita;
4. Yambitsani lamulo loyika.

Njira zina zosuntha deta zomwe sizikuphatikizapo kugwiritsa ntchito bolodi la zojambulazo zimagwiritsa ntchito kukoka ndi kugwetsa ndi mbewa.

Njira Zophimbidwa

Monga mu mapulogalamu onse a Microsoft, pali njira imodzi yosuntha dera ku Excel. Izi zikuphatikizapo:

• pogwiritsa ntchito njira yomasulira,
• pogwiritsa ntchito menyu yoyenera yowonjezera;
• pogwiritsa ntchito makasitomala omwe ali pa tsamba la Pakiti la riboni

Kusuntha Dongosolo mu Excel ndi Zowonjezera Keys

Mapangidwe a makiyi a makiyi omwe amagwiritsidwa ntchito kufotokoza deta ndi awa:

Ctrl + X (kalata "X") - imayambitsa lamulo lodulidwa Ctrl + V (chilembo "V") - limayambitsa lamulo

Kusuntha deta pogwiritsa ntchito mafungulo afupikitsira:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Koperani ndi kusunga makiyi a Ctrl pa kibokosi;
3. Dinani ndi kumasula "X" popanda kumasula makiyi a Ctrl ;
4. Maselo osankhidwa ayenera kuzunguliridwa ndi malire akuda akudziwika ngati nyerere kuti azisonyeza kuti deta kapena maselo akukopedwa;
5. Dinani pa selo lopitako - pamene mukusuntha maselo ambiri a deta, dinani mu selo ili kumbali yakumanzere ya malo omwe akupita;
6. Koperani ndi kusunga makiyi a Ctrl pa kibokosi;
7. Dinani ndi kumasula "V" fungulo popanda kumasula makiyi a Ctrl ;
8. Deta yosankhidwa iyenera kukhala pano komwe mukupita.

Zindikirani: Mitsuko ya makina pa kibokosiyi ingagwiritsidwe ntchito mmalo mwa pointer ya mouse kuti muzisankha maselo omwe amachokera komanso omwe akupita pakadula ndi kudula deta.

• Kusankha maselo omwe ali pafupi ndi makiyiwo, fanizani ndi kugwiritsira chinsinsi cha Shift .
• Kusankha maselo ambiri osakhala pafupi ndi makiyi, mugwiritse ntchito makiyi a Ctrl .

2. Sankhani Dongosolo Pogwiritsa Ntchito Mndandanda wa Mndandanda

Ngakhale zosankha zomwe zilipo mndandanda wa masewera - kapena pang'anizani pomwe-menyu - nthawi zambiri musinthe malinga ndi chinthu chimene mwasankha pamene menyu yatsegulidwa, malamulo ndi kusunga malamulo nthawi zonse amakhalapo.

Kusuntha deta pogwiritsa ntchito mndandanda wazinthu:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Dinani kumene pa selo yosankhidwa kuti mutsegule zolemba;
3. Sankhani kudula kuchokera ku menyu omwe mungapeze;
4. Maselo osankhidwa ayenera kuzunguliridwa ndi nyerere kuti azisonyeza kuti data mu selo kapena maselo akusuntha;
5. Dinani pa selo lopitako - pamene mukujambula maselo angapo a deta, dinani selo ili pamwamba pa ngodya yakutali ya malo opita;
6. Dinani kumene pa selo yosankhidwa kuti mutsegule zolemba;
7. Sankhani phala kuchokera ku menyu omwe mungapeze;
8. Deta yosankhidwa iyenera kukhala pano pokhapokha komwe mukupita.

2. Sinthani Dongosolo Pogwiritsa Ntchito Zosankha Zamkati pa Kabukhu Kakang'ono ka Mphutsi

Malemba ndi kusunga malamulo ali mu Clipboard gawo kapena bokosi nthawi zambiri ili kumbali ya kumanzere kwa Tsamba la Home la Riboni

Kusuntha deta pogwiritsa ntchito malamulo a riboni:

1. Dinani pa selo kapena maselo ambiri kuti muwawonetse iwo;
2. Dinani pa chithunzi cha Cut pa Riboni;
3. Maselo osankhidwa ayenera kuzunguliridwa ndi nyerere kuti azisonyeza kuti deta kapena maselo akusuntha;
4. Dinani pa selo lopitako - pamene mukujambula maselo angapo a deta, dinani selo ili pamwamba pa ngodya yakutali ya malo opita;
5. Dinani pa Pasani chithunzi pa riboni;
6. Deta yosankhidwa iyenera kukhala pano komwe mukupita.