Izinqamlezo zeeNqakrazo zokuCima, ukuCoca, kunye nokuQinisa idatha kwi-Excel

01 ka 02

Kopisha kunye Namathisela Iinkcukacha kwi-Excel Namaqhosha okufutshane

Ukukopisha idatha kwi-Excel isetyenziswa ngokuphindaphindiweyo kwimisebenzi emibili, ifomu, iitshathi kunye nedatha. Indawo entsha ingaba

• kwiphepha elifanayo lomsebenzi ,
• kwiifayile ezisebenzayo
• kwiincwadi zokusebenzela ezahlukeneyo okanye kwiifayile.

Iindlela zokukhuphela idatha

Njengakwiinkqubo zonke zeMicrosoft, kukho indlela engaphezulu kweyodwa yokufeza umsebenzi. Imiyalelo engezantsi iquka iindlela ezintathu zokukopa nokuhambisa idatha kwi-Excel.

• usebenzisa i-shortcut keyboard,
• usebenzisa imenyu yokunqakraza imenyu yomxholo;
• usebenzisa okukhethwa kukho kwimenyu ekhompyutheni lekhaya lasebhoni

I-Clipboard kunye neDatha yeDatha

Ukukopisha idatha akuze kube yinkqubo enye yeendlela ezikhankanywe ngasentla. Xa umyalelo wekopi usebenze iphindi yedatha ekhethiweyo ifakwe kwibhodi yokunamathisela , yindawo yokugcina yesikhashana.

Ukusuka kwibhodi yokunamathisela, idatha ekhethiweyo idluliselwa kwiseli okanye kwindawo yeseli. Amanyathelo amane athathwe kwinkqubo :

1. Khetha idatha eyokukopishwa;
2. Qalisa umyalelo wekopi;
3. Cofa kwiseli yokuya kuyo;
4. Yenza umyalelo wokunamathisela.

Ezinye iindlela zokukopisha idatha ezingabandakanyi ukusebenzisa ibhodi yokunamathisela ziquka ukusebenzisa isibambo sokuzalisa uze udibe uze uphononise nge mouse.

Kopisha idatha kwi-Excel kunye neNqamlezo zeNqamlezo

Ukuhlanganiswa kwekhibhodi ebalulekileyo ekusetshenziselwa ukuhambisa idatha yile:

Ctrl + C (ileta "C") - isebenza umyalelo wekopi Ctrl + V (ileta "V") - isebenzise umyalelo wokunamathisela

Ukukopa idatha ngokusebenzisa izitshixo ezifutshane:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi;
3. Cinezela kwaye ukhulule "C" ngaphandle kokukhulula ikhiye ye Ctrl
4. Iiseli okanye ezikhethiweyo zifanele zijikelezwe ngumda omnyama ohambayo obizwa ngokuba yizintuthwane zokuhamba ukubonisa ukuba idatha kwiiseli okanye kuseli ikopishwa;
5. Cofa kwiseli yokuya kuyo - xa ukopisha iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
6. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi;
7. Cinezela kwaye ukhulule "V" ngaphandle kokukhulula ikhiye ye Ctrl ;
8. Idatha ephindiweyo kufuneka ngoku ikhona kwindawo zombini kunye neendawo zokuya kuyo.

Qaphela: Iimpawu zokucoca kwiikhibhodi zingasetyenziselwa endaweni ye-pointer ye mouse ukuze ukhethe zombini iiseli zendawo kunye neendawo zokuhamba xa ukopisha kwaye udlulisa idatha.

• Ukukhetha iiseli ezininzi ezikufutshane kunye nezitshixo zokucoca, cinezela kwaye ubambe iqhosha leShift .
• Ukukhetha iiseli ezininzi ezingasondelene neefowuni zokucoca, sebenzisa ukhiye weCtrl .

2. Kopisha idatha usebenzisa Imenyu Yemixholo

Nangona iikhompyutheni ezikhoyo kwimenyu yomxholo - okanye imenyu yokucofa kwesokudla - ngokuqhelekileyo utshintshe ngokuxhomekeke kwinto ekhethiweyo xa imenyu ivuliwe, iikopi kunye neenkcukacha zokunamathisela zihlala zikhona.

Ukukopa idatha ngokusebenzisa imenyu yomongo:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Ukucofa ngakwesokudla kwiiseli ezikhethiweyo ukuvula imenyu yomongo;
3. Khetha ikopi kwimenyu ekhoyo yemenyu njengoko kuboniswe kwicala lasekunene lomfanekiso ongentla;
4. Iiseli ezikhethiweyo mazizungezwe ngeentsontsho zokubonisa ukuba idatha kwiiseli okanye kuseli ikopishwa;
5. Cofa kwiseli yokuya kuyo - xa ukopisha iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
6. Ukucofa ngakwesokudla kwiiseli ezikhethiweyo ukuvula imenyu yomongo;
7. Khetha unobumba ukusuka kwimenyu ekhoyo yemenyu;
8. Idatha ephindiweyo kufuneka ngoku ikhona kwindawo zombini kunye neendawo zokuya kuyo.

2. Kopisha idatha usebenzisa i-Menu Options kwi-Tab yasekhaya yeRibhoni

Ikopi kunye neenkcukacha zokunamathisela zifumaneka kwicandelo lebhodi yebhodibhodi okanye ibhokisi ngokuqhelekileyo kufakwe kwicala lasekhohlo lweTable yasekhaya yebhanethi

Ukukopa idatha ngokusebenzisa imiyalelo yombonakalo:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Cofa kwi Kopi icon kwi-Ribbon;
3. Iiselingi (ezikhethiweyo) ezikhethiweyo kufuneka zizungezwe yizintuthwane ezihambayo ukubonisa ukuba idatha kwiiseli okanye kuseli ikopishwa;
4. Cofa kwiseli yokuya kuyo - xa ukopisha iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
5. Cofa kwi- Paste icon kwi-ribbon;
6. Idatha ephindiweyo kufuneka ngoku ikhona kwindawo zombini kunye neendawo zokuya kuyo.

02 we 02

Hambisa Iinkcukacha kwi-Excel kunye neeNqamlezo zokufutshane

Ukuhambisa idatha kwi-Excel isetyenziselwa ukufudula imisebenzi, ifomu, iitshathi kunye nedatha. Indawo entsha ingaba:

• kwiphepha elifanayo lomsebenzi,
• kwiifayile ezisebenzayo
• kwiincwadi zokusebenzela ezahlukeneyo okanye kwiifayile.

Akukho myalelo ohambelayo wokuhambisa okanye uphawu kwi-Excel. Ixesha elisetyenzisiweyo xa ukuhamba kwedatha kunqunyulwa. Idata ichithwe kwindawo yayo yasekuqaleni ize idlulelwe kwi entsha.

I-Clipboard kunye neDatha yeDatha

Idatha yokuhambisa ayisoze ibe yinkqubo enye. Xa umyalelo wokuhambisa usuququzelelwe ikopi yedatha ekhethiweyo ifakwe kwibhodi yokunamathisela , eyindawo yokugcina yesikhashana. Ukusuka kwibhodi yokunamathisela, idatha ekhethiweyo idluliselwa kwiseli okanye kwindawo yeseli.

Amanyathelo amane athathwe kwinkqubo :

1. Khetha idatha ekuhanjiswe;
2. Yenza umyalelo wokusika;
3. Cofa kwiseli yokuya kuyo;
4. Yenza umyalelo wokunamathisela.

Ezinye iindlela zokuhambisa idatha ezingabandakanyi ukusebenzisa ibhodi yokunamathisela ziquka ukusebenzisa udonga uze uphononise nge mouse.

Izindlela ezifihliweyo

Njengakwiinkqubo zonke zeMicrosoft, kukho enye indlela yokuhambisa idatha kwi-Excel. Ezi ziquka:

• usebenzisa i-shortcut keyboard,
• usebenzisa imenyu yokunqakraza yemenu;
• usebenzisa okukhethwa kukho kwimenyu ekhompyutheni lekhaya lasebhoni

Ukuhambisa iDatha kwi-Excel kunye neNqamlezo zeNqamlezo

Ukuhlanganiswa okubalulekileyo kwebhobhoji esetyenzisiweyo ukukopisha idatha:

I-Ctrl + X (ileta "X") - isebenza umyalelo osiweyo u-Ctrl + V (ileta "V") - isebenza umyalelo wokunamathisela

Ukuhambisa idatha usebenzisa izitshixo ezifutshane:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi;
3. Cinezela kwaye ukhulule "X" ngaphandle kokukhulula ikhiye ye Ctrl ;
4. Iiseli okanye ezikhethiweyo zifanele zijikelezwe ngumda omnyama ohambayo obizwa ngokuba yizintuthwane zokuhamba ukubonisa ukuba idatha kwiiseli okanye kuseli ikopishwa;
5. Cofa kwiseli yokuya kuyo - xa ushukumisa iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
6. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi;
7. Cinezela kwaye ukhulule ikhiye "V" ngaphandle kokukhulula ikhiye ye Ctrl ;
8. Idatha ekhethiweyo kufuneka ngoku ikhona kwindawo yokuphela kuyo.

Qaphela: Iimpawu zokucoca kwiikhibhodi zingasetyenziselwa endaweni ye-pointer ye mouse ukuze ukhethe zombini iiseli zendawo kunye neendawo zokuhamba xa usika kwaye udlulisa idatha.

• Ukukhetha iiseli ezininzi ezikufutshane kunye nezitshixo zokucoca, cinezela kwaye ubambe iqhosha leShift .
• Ukukhetha iiseli ezininzi ezingasondelene neefowuni zokucoca, sebenzisa ukhiye weCtrl .

2. Hambisa Iinkcukacha usebenzisa Imenyu Yemixholo

Nangona iikhompyutheni ezikhoyo kwimenyu yomxholo - okanye imenyu yokucofa kwesokudla - ngokuqhelekileyo utshintshe ngokuxhomekeke kwinto ekhethiweyo xa imenyu ivuliwe, iikopi kunye neenkcukacha zokunamathisela zihlala zikhona.

Ukuhambisa idatha usebenzisa imenyu yomongo:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Ukucofa ngakwesokudla kwiiseli ezikhethiweyo ukuvula imenyu yomongo;
3. Khetha ukunqunyulwa kwizinto ezikhethiweyo zemenyu;
4. Iiseli ezikhethiweyo mazizungezwe ngeentsonkqo zokuhamba ukubonisa ukuba idatha kwiseli okanye iiseli ziyasuswa;
5. Cofa kwiseli yokuya kuyo - xa ukopisha iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
6. Ukucofa ngakwesokudla kwiiseli ezikhethiweyo ukuvula imenyu yomongo;
7. Khetha unobumba ukusuka kwimenyu ekhoyo yemenyu;
8. Idatha ekhethiweyo ngoku kufuneka ibe khona kuphela kwindawo yokuya kuyo.

2. Hambisa Iinkcukacha usebenzisa iindlela zeMenyu kwiTable yaseKhaya yeRibhoni

Ikopi kunye neenkcukacha zokunamathisela zifumaneka kwicandelo lebhodi yebhodibhodi okanye ibhokisi ngokuqhelekileyo kufakwe kwicala lasekhohlo lweTable yasekhaya yebhanethi

Ukuhambisa idatha usebenzisa ilayibhoni imiyalelo:

1. Cofa kwiiseli okanye kwiiseli ezininzi ukuzigqamisa;
2. Cofa kwiConcer icon kwi-Ribbon;
3. Iiselingi (s) ezikhethiweyo kufuneka zizungezwe yizintuthwane ezihambelayo ukubonisa ukuba idatha kwiseli okanye iiseli ziyasuswa;
4. Cofa kwiseli yokuya kuyo - xa ukopisha iiseli ezininzi zeedatha, nqakraza kwiseli ekhoneni eliphezulu lasekhohlo lendawo yokuya kuyo;
5. Cofa kwi- Paste icon kwi-ribbon;
6. Idatha ekhethiweyo kufuneka ngoku ikhona kwindawo yokuphela kuyo.